Line 1: using System;
Line 2: using System.Data;
Line 3: using System.Configuration;
Line 4: using System.Web;
Line 5: using System.Web.Security;
Line 6: using System.Web.UI;
Line 7: using System;
Line 8: using System.Data;
Line 9: using System.Data.SqlClient;
Line 10: using System.Collections;
Line 11: using System.Text;
Line 12:
Line 13: /// <summary>
Line 14: /// Descrizione di riepilogo per cPuntiCard
Line 15: /// </summary>
Line 16: ///
Line 17: public class cPuntiCard
Line 18: {
Line 19: private SqlConnection Conn = null;
Line 20: public const int fascia1Inizio = 0;
Line 21: public const int fascia1Fine = 125;
Line 22: public const int fascia2Inizio = 126;
Line 23: public const int fascia2Fine = 330;
Line 24: public const int fascia3Inizio = 331;
Line 25: public const int fascia3Fine = 1080;
Line 26: public const int fascia4Inizio = 1001;
Line 27: public const int fascia4Fine = 10000;
Line 28:
Line 29: public cPuntiCard()
Line 30: {
Line 31: System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
Line 32: Conn = new SqlConnection((string)(configurationAppSettings.GetValue("StringaConnessioneDataBaseSebeto", typeof(string))));
Line 33:
Line 34: }
Line 35:
Line 36:
Line 37: public int Fascia1Min
Line 38: {
Line 39: get
Line 40: {
Line 41: return fascia1Inizio;
Line 42: }
Line 43: }
Line 44:
Line 45: public int Fascia1Max
Line 46: {
Line 47: get
Line 48: {
Line 49: return fascia1Fine;
Line 50: }
Line 51: }
Line 52:
Line 53: public int Fascia2Min
Line 54: {
Line 55: get
Line 56: {
Line 57: return fascia2Inizio;
Line 58: }
Line 59: }
Line 60:
Line 61: public int Fascia2Max
Line 62: {
Line 63: get
Line 64: {
Line 65: return fascia2Fine;
Line 66: }
Line 67: }
Line 68:
Line 69: public int Fascia3Min
Line 70: {
Line 71: get
Line 72: {
Line 73: return fascia3Inizio;
Line 74: }
Line 75: }
Line 76:
Line 77: public int Fascia3Max
Line 78: {
Line 79: get
Line 80: {
Line 81: return fascia3Fine;
Line 82: }
Line 83: }
Line 84:
Line 85:
Line 86: public int Fascia4Min
Line 87: {
Line 88: get
Line 89: {
Line 90: return fascia4Inizio;
Line 91: }
Line 92: }
Line 93:
Line 94: public int Fascia4Max
Line 95: {
Line 96: get
Line 97: {
Line 98: return fascia4Fine;
Line 99: }
Line 100: }
Line 101:
Line 102:
Line 103:
Line 104: public DataTable ElencoPremiCatalogo(int min, int max)
Line 105: {
Line 106: SqlCommand cmd = new SqlCommand();
Line 107: cmd.Connection = Conn;
Line 108: cmd.CommandType = CommandType.Text;
Line 109:
Line 110: StringBuilder sb = new StringBuilder();
Line 111:
Line 112: sb.Append(" SELECT * FROM tCarte_tPunti_Premi");
Line 113: sb.Append(" WHERE attivo = 1");
Line 114: sb.Append(" AND punti >="+min);
Line 115: sb.Append(" AND punti <=" + max);
Line 116: sb.Append(" ORDER BY punti asc");
Line 117:
Line 118: cmd.CommandText = sb.ToString();
Line 119:
Line 120: DataSet _ds = new DataSet();
Line 121: try
Line 122: {
Line 123: cmd.Connection.Open();
Line 124: SqlDataAdapter _da = new SqlDataAdapter(cmd);
Line 125: _da.Fill(_ds, "premi");
Line 126: }
Line 127: catch (Exception err)
Line 128: {
Line 129: throw new Exception(err.Message);
Line 130: }
Line 131: finally
Line 132: {
Line 133: cmd.Connection.Close();
Line 134: }
Line 135:
Line 136: return _ds.Tables["premi"];
Line 137: }
Line 138:
Line 139:
Line 140:
Line 141: public int GetSaldoPuntiSpesa(string card)
Line 142: {
Line 143: SqlCommand cmd = new SqlCommand();
Line 144: int _saldopunti = 0;
Line 145:
Line 146: try
Line 147: {
Line 148: cmd.Connection = Conn;
Line 149: cmd.CommandType = CommandType.StoredProcedure;
Line 150: cmd.CommandText = "stored_client_saldopuntispesa";
Line 151:
Line 152: cmd.Parameters.AddWithValue("@card", card);
Line 153:
Line 154: cmd.Connection.Open();
Line 155:
Line 156: _saldopunti = (int)cmd.ExecuteScalar();
Line 157:
Line 158: }
Line 159: catch (Exception err)
Line 160: {
Line 161: _saldopunti = 0;
Line 162: }
Line 163: finally
Line 164: {
Line 165: cmd.Connection.Close();
Line 166: }
Line 167: return _saldopunti;
Line 168:
Line 169: }
Line 170:
Line 171:
Line 172: public string AggiornaPunti(string cardnumber, int punti, int idpremio,string locale)
Line 173: {
Line 174: string codice = "";
Line 175:
Line 176: SqlCommand cmd = new SqlCommand();
Line 177: cmd.Connection = Conn;
Line 178:
Line 179: cmd.CommandType = CommandType.StoredProcedure;
Line 180: cmd.CommandText = "spCalcoloTotaliCarte_Punti_NuovoSaldo";
Line 181:
Line 182: cmd.Parameters.Add("@cardnumber", SqlDbType.VarChar);
Line 183: cmd.Parameters["@cardnumber"].Value = cardnumber;
Line 184:
Line 185: cmd.Parameters.Add("@puntidascalare", SqlDbType.Int);
Line 186: cmd.Parameters["@puntidascalare"].Value = punti;
Line 187:
Line 188: cmd.Parameters.Add("@idpremio", SqlDbType.Int);
Line 189: cmd.Parameters["@idpremio"].Value = idpremio;
Line 190:
Line 191: cmd.Parameters.Add("@locale", SqlDbType.VarChar);
Line 192: cmd.Parameters["@locale"].Value = locale;
Line 193:
Line 194: try
Line 195: {
Line 196: cmd.Connection.Open();
Line 197: codice = cmd.ExecuteScalar().ToString();
Line 198: }
Line 199: catch (Exception exc)
Line 200: {
Line 201: codice = "-1";
Line 202: throw new Exception(exc.Message);
Line 203: }
Line 204: finally
Line 205: {
Line 206: cmd.Connection.Close();
Line 207: }
Line 208:
Line 209: return codice;
Line 210: }
Line 211:
Line 212:
Line 213:
Line 214: public System.Data.DataSet FillLocali()
Line 215: {
Line 216: DataSet objDS = new DataSet();
Line 217:
Line 218: try
Line 219: {
Line 220: string strSql = String.Concat("Select DISTINCT codicelocale as AZI,descrizione From FQAZIE_PARAMETRI where codicelocale not in (select AZI from locali_da_escludere) AND codicelocale != '137' AND codicelocale != '135' AND codicelocale != '1M9' AND (brand='ROSSOPOMODORO' OR brand='ANEMA&COZZE') ORDER BY descrizione ");
Line 221:
Line 222:
Line 223: SqlDataAdapter SQLCommand = new SqlDataAdapter(strSql, Conn);
Line 224: SQLCommand.Fill(objDS, "FQAZIE");
Line 225: }
Line 226: catch (Exception exc)
Line 227: {
Line 228: throw new Exception(exc.Message);
Line 229: }
Line 230: finally
Line 231: {
Line 232: Conn.Close();
Line 233: }
Line 234:
Line 235: return objDS;
Line 236: }
Line 237:
Line 238:
Line 239:
Line 240: public string MailDirettore(string codicelocale)
Line 241: {
Line 242: string mail = "";
Line 243:
Line 244: SqlCommand cmd = new SqlCommand();
Line 245: cmd.Connection = Conn;
Line 246:
Line 247: cmd.CommandType = CommandType.Text;
Line 248: cmd.CommandText = "SELECT ISNULL(MAIL,'') AS MAIL FROM FQAZIE_MAILDIRETTORI WHERE CODICELOCALE = '"+codicelocale+"'";
Line 249:
Line 250: try
Line 251: {
Line 252: cmd.Connection.Open();
Line 253: mail = cmd.ExecuteScalar().ToString();
Line 254: }
Line 255: catch (Exception exc)
Line 256: {
Line 257: mail = "-1";
Line 258: throw new Exception(exc.Message);
Line 259: }
Line 260: finally
Line 261: {
Line 262: cmd.Connection.Close();
Line 263: }
Line 264:
Line 265: return mail;
Line 266: }
Line 267:
Line 268:
Line 269: }
Line 270:
|