private void Insert_template(string account, string mess) { DTO_SMS_Template tem = new DTO_SMS_Template(); DAO_SMS_Template _temlate = new DAO_SMS_Template(); tem.ID = _temlate.RandomID(); tem.Account = account; tem.SMS_Template = mess; _temlate.Insert(tem); }
public bool Delete(DTO_SMS_Template _temp) { Connet(); string sql = "delete from SMS_TEMPLATE where ID=@ID"; try { _cmd = new SqlCommand(sql, _conn); _cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _temp.ID; _cmd.ExecuteNonQuery(); _cmd.Dispose(); Disconnet(); } catch (Exception ex) { Disconnet(); return(false); throw ex; } return(true); }
public bool Insert(DTO_SMS_Template _temp) { Connet(); string sql = "insert into SMS_Template( SMS_Template, ID, Account) values (@SMS_Template, @ID, @Account)"; try { _cmd = new SqlCommand(sql, _conn); _cmd.Parameters.Add("@SMS_Template", SqlDbType.NVarChar).Value = _temp.SMS_Template; _cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _temp.ID; _cmd.Parameters.Add("@AccountID", SqlDbType.VarChar).Value = _temp.Account; _cmd.ExecuteNonQuery(); _cmd.Dispose(); Disconnet(); } catch (Exception ex) { Disconnet(); return(false); throw ex; } return(true); }
public bool Update(DTO_SMS_Template _temp) { Connet(); string sql = "update Customer set SMS_Template=@SMS_Template,AccountID=@AccountID Where ID=@ID"; try { _cmd = new SqlCommand(sql, _conn); _cmd.Parameters.Add("@SMS_Template", SqlDbType.NVarChar).Value = _temp.SMS_Template; _cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _temp.ID; _cmd.Parameters.Add("@AccountID", SqlDbType.VarChar).Value = _temp.Account; _cmd.ExecuteNonQuery(); _cmd.Dispose(); Disconnet(); } catch (Exception ex) { Disconnet(); return(false); throw ex; } return(true); }
public bool Update(DTO_SMS_Template _temp) { return(_BUStemp.Update(_temp)); }
public bool Delete(DTO_SMS_Template _temp) { return(_BUStemp.Delete(_temp)); }
public bool Insert(DTO_SMS_Template _temp) { return(_BUStemp.Insert(_temp)); }