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;
}
}
}