public void add(Sms item) { DataTable dt; using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_CUST_TEL", FbDbType.VarChar, item.Cust_Tel); db.SetParameters("@I_MEMO", FbDbType.Text, item.Memo); db.SetParameters("@I_RESULT", FbDbType.SmallInt, item.Result); db.BeginTran(); dt = db.GetDataTableSP("INS_SMS_LIST"); db.Commit(); foreach (DataRow row in dt.Rows) { item.Idx = string.IsNullOrEmpty(row[0].ToString()) == false?int.Parse(row[0].ToString()) : -1; item.Cust_Idx = string.IsNullOrEmpty(row[1].ToString()) == false?int.Parse(row[1].ToString()) : -1; } this.Insert(0, item); } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); } } }
public void add(CallList item) { DataTable dt; using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_DIRECTION", FbDbType.Integer, item.Direction); db.SetParameters("@I_CUST_TEL", FbDbType.VarChar, item.Cust_Tel); db.SetParameters("@I_STARTDATE", FbDbType.TimeStamp, item.Startdate); db.BeginTran(); dt = db.GetDataTableSP("INS_CALL_LIST"); db.Commit(); foreach (DataRow row in dt.Rows) { item.Idx = string.IsNullOrEmpty(row[0].ToString()) == false?int.Parse(row[0].ToString()) : 0; item.Cust_Idx = string.IsNullOrEmpty(row[1].ToString()) == false?int.Parse(row[1].ToString()) : 0; } this.Insert(0, item); } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); } } }
public Smses(SearchCondition1 val) { DataTable dt; using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_SDATE", FbDbType.TimeStamp, val.StartDate); db.SetParameters("@I_EDATE", FbDbType.TimeStamp, val.EndDate); db.SetParameters("@I_NUMBER", FbDbType.VarChar, val.Number); dt = db.GetDataTableSP("GET_SMS_LIST"); foreach (DataRow row in dt.Rows) { this.Add(new Sms() { Idx = string.IsNullOrEmpty(row[0].ToString()) == false ? int.Parse(row[0].ToString()) : -1, Cust_Idx = string.IsNullOrEmpty(row[1].ToString()) == false ? int.Parse(row[1].ToString()) : -1, Cust_Name = row[2].ToString(), Cust_Tel = row[3].ToString(), Regdate = string.IsNullOrEmpty(row[4].ToString()) == false ? DateTime.Parse(row[4].ToString()) : new DateTime(1970, 1, 1, 0, 0, 0, 0, DateTimeKind.Local), Memo = row[5].ToString(), Result = string.IsNullOrEmpty(row[6].ToString()) == false ? int.Parse(row[6].ToString()) : -1 }); } } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); } } }
public void modify(CallList item) { using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_IDX", FbDbType.Integer, item.Idx); db.SetParameters("@I_ENDDATE", FbDbType.TimeStamp, item.Enddate); db.BeginTran(); db.ExcuteSP("MODI_CALL_LIST"); db.Commit(); var itm = this.FirstOrDefault(x => x.Idx == item.Idx); //if (itm != null) //{ // int idx = this.IndexOf(itm); // this.RemoveAt(idx); // this.Insert(idx, item); //} } catch (FbException e) { // util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); throw e; } catch (Exception e) { util.WriteLog(e.Message); } } }
private void FileName2DB(string fn, string ext, string peernum) { try { using (FirebirdDBHelper db = new FirebirdDBHelper(util.strFBDBConn)) { db.SetParameters("@EXTENTION", FbDbType.VarChar, ext); db.SetParameters("@PEERNUMBER", FbDbType.VarChar, peernum); db.SetParameters("@FN", FbDbType.VarChar, fn); try { db.BeginTran(); db.ExcuteSP("INS_RECINFO"); db.Commit(); } catch (FbException e) { util.WriteLog(string.Format("SQL INS ERROR (INS_RECINF)\r\nMessage : {0}", e.Message)); db.Rollback(); } } } catch (FbException e) { util.WriteLog(string.Format("SQL INS ERROR (INS_RECINF)\r\nMessage : {0}", e.Message)); } }
public void remove(Customer item) { using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_IDX", FbDbType.Integer, item.Idx); db.BeginTran(); db.ExcuteSP("RMV_CUSTOMER"); db.Commit(); if (this.Items.Count > 0) { if (this.Items[0].Group_Idx == item.Group_Idx) { this.Remove(item); } } } catch (FbException e) { // util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); throw e; } } }
public void update(GroupList item) { if (item.Idx == -1) { using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_NAME", FbDbType.VarChar, item.Name); db.BeginTran(); string idx = db.GetDataSP("INS_GROUPS").ToString(); db.Commit(); item.Idx = string.IsNullOrEmpty(idx) == false?int.Parse(idx) : -1; } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); } } } else { using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_IDX", FbDbType.Integer, item.Idx); db.SetParameters("@I_NAME", FbDbType.VarChar, item.Name); db.BeginTran(); db.ExcuteSP("MODI_GROUPS"); db.Commit(); } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); throw e; } } } }
public void savememo() { using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_IDX", FbDbType.Integer, this.Idx); db.SetParameters("@I_MEMO", FbDbType.VarChar, util.encStr(this.Memo)); db.BeginTran(); db.ExcuteSP("MODI_CALL_LIST_MEMO"); db.Commit(); } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); throw e; } } }
public void modify(Customer item) { using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_IDX", FbDbType.Integer, item.Idx); db.SetParameters("@I_GROUP_IDX", FbDbType.Integer, item.Group_Idx); db.SetParameters("@I_NAME", FbDbType.VarChar, item.Name); db.SetParameters("@I_COMPANY", FbDbType.VarChar, item.Company); db.SetParameters("@I_TITLE", FbDbType.VarChar, item.Title); db.SetParameters("@I_TEL", FbDbType.VarChar, item.Tel); db.SetParameters("@I_CELLULAR", FbDbType.VarChar, item.Cellular); db.SetParameters("@I_EXTENSION", FbDbType.VarChar, item.Extension); db.SetParameters("@I_EMAIL", FbDbType.VarChar, item.Email); db.SetParameters("@I_ADDR", FbDbType.VarChar, item.Addr); db.BeginTran(); db.ExcuteSP("MODI_CUSTOMER"); db.Commit(); if (this.Items.Count > 0) { if (this.Items[0].Group_Idx == item.Group_Idx) { var itm = this.FirstOrDefault(x => x.Idx == item.Idx); int idx = this.IndexOf(itm); this.RemoveAt(idx); this.Insert(idx, item); } } } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); } } }
public void add(Customer item) { using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_GROUP_IDX", FbDbType.Integer, item.Group_Idx); db.SetParameters("@I_NAME", FbDbType.VarChar, item.Name); db.SetParameters("@I_COMPANY", FbDbType.VarChar, item.Company); db.SetParameters("@I_TITLE", FbDbType.VarChar, item.Title); db.SetParameters("@I_TEL", FbDbType.VarChar, item.Tel); db.SetParameters("@I_CELLULAR", FbDbType.VarChar, item.Cellular); db.SetParameters("@I_EXTENSION", FbDbType.VarChar, item.Extension); db.SetParameters("@I_EMAIL", FbDbType.VarChar, item.Email); db.SetParameters("@I_ADDR", FbDbType.VarChar, item.Addr); db.BeginTran(); string idx = db.GetDataSP("INS_CUSTOMER").ToString(); db.Commit(); item.Idx = string.IsNullOrEmpty(idx) == false?int.Parse(idx) : -1; // var itm = this.Items.FirstOrDefault(x => x.Group_Idx == item.Group_Idx); // if (itm != null) this.Add(item); //if (this.Items.Count > 0) //{ // if (this.Items[0].Group_Idx == item.Group_Idx) // this.Add(item); //} } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); } } }
public void importExcel(Customer item) { if (string.IsNullOrEmpty(item.Group_Name.Trim())) { return; } using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_GROUP_NAME", FbDbType.VarChar, item.Group_Name); db.SetParameters("@I_NAME", FbDbType.VarChar, item.Name); db.SetParameters("@I_COMPANY", FbDbType.VarChar, item.Company); db.SetParameters("@I_TITLE", FbDbType.VarChar, item.Title); db.SetParameters("@I_TEL", FbDbType.VarChar, item.Tel); db.SetParameters("@I_CELLULAR", FbDbType.VarChar, item.Cellular); db.SetParameters("@I_EXTENSION", FbDbType.VarChar, item.Extension); db.SetParameters("@I_EMAIL", FbDbType.VarChar, item.Email); db.SetParameters("@I_ADDR", FbDbType.VarChar, item.Addr); db.BeginTran(); string idx = db.GetDataSP("INS_CUSTOMERS").ToString(); db.Commit(); item.Idx = string.IsNullOrEmpty(idx) == false?int.Parse(idx) : -1; this.Add(item); } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); } } }
public void remove(Sms item) { using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_IDX", FbDbType.Integer, item.Idx); db.BeginTran(); db.ExcuteSP("RMV_SMS_LIST"); db.Commit(); this.Remove(item); } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); } } }
public Customers(int idx) { DataTable dt; using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_GROUP_IDX", FbDbType.Integer, idx); dt = db.GetDataTableSP("GET_CUSTOMER"); foreach (DataRow row in dt.Rows) { this.Add(new Customer() { IsChecked = false, IsSelected = false, Idx = string.IsNullOrEmpty(row[0].ToString()) == false ? int.Parse(row[0].ToString()) : -1, Group_Idx = string.IsNullOrEmpty(row[1].ToString()) == false ? int.Parse(row[1].ToString()) : -1, Group_Name = row[2].ToString(), Name = row[3].ToString(), Company = row[4].ToString(), Title = row[5].ToString(), Tel = row[6].ToString(), Cellular = row[7].ToString(), Extension = row[8].ToString(), Email = row[9].ToString(), Addr = row[10].ToString(), Etc = row[11].ToString() }); } } catch (FbException e) { util.WriteLog(e.ErrorCode, e.Message); } } }
public void remove(GroupList item) { using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn())) { try { db.SetParameters("@I_IDX", FbDbType.Integer, item.Idx); db.BeginTran(); db.ExcuteSP("RMV_GROUPS"); db.Commit(); var itm = this.Items[0].Children.FirstOrDefault(x => x.Idx == item.Idx); this.Items[0].Children.Remove(itm); } catch (FbException e) { // util.WriteLog(e.ErrorCode, e.Message); db.Rollback(); throw e; } } }