public ActionResult _Destroy([DataSourceRequest]DataSourceRequest request, TB_MessageExt model)
{
string Msg = "";
try
{
TB_MessageRepository modelRepo = new TB_MessageRepository();
if (modelRepo.Delete(model, ref Msg, this) == false)
{
return this.Json(new DataSourceResult { Errors = Msg });
}
}
catch (Exception ex)
{
string hostName1 = Dns.GetHostName();
string GetUserIPAddress = Dns.GetHostByName(hostName1).AddressList[0].ToString();
string PageName = Convert.ToString(Session["PageName"]);
//string GetUserIPAddress = GetUserIPAddress1();
using (BaseRepository baseRepo = new BaseRepository())
{
//BizContext BizContext1 = new BizContext();
BizApplication.AddError(baseRepo.BizDB, PageName, ex.Message, ex.StackTrace, DateTime.Now, GetUserIPAddress);
}
Session["PageName"] = "";
string error = ErrorHandling.HandleException(ex);
return this.Json(new DataSourceResult { Errors = error });
}
return Json(request);
}
public bool Update(TB_MessageExt model, ref string Msg, Controller ctrl)
{
bool status = true;
var obj = db.TB_Message.Where(x => x.ID == model.ID).FirstOrDefault();
obj.MessageSubjectTypeID = model.MessageSubjectID;
obj.MessageStatusID = model.MessageStatusID;
obj.SalutationTypeID = model.TitleID;
obj.Name = model.Name;
obj.Surname = model.Surname;
obj.Email = model.Email;
obj.Phone = model.Phone;
obj.CountryID = model.CountryID;
obj.Text = model.Text;
obj.Active = model.Active;
obj.IPAddress = model.IPAddress;
obj.OpDateTime = DateTime.Now;
obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
db.SaveChanges();
return status;
}
public bool Delete(TB_MessageExt model, ref string Msg, Controller ctrl)
{
bool status = true;
var obj = db.TB_Message.Where(x => x.ID == model.ID).FirstOrDefault();
db.TB_Message.Remove(obj);
db.SaveChanges();
return status;
}
public List<TB_MessageExt> ReadAll(int TableID)
{
List<TB_MessageExt> list = new List<TB_MessageExt>();
DataTable dt = new DataTable();
SQLCon.Open();
SqlCommand cmd = new SqlCommand("B_DisplayTable_BizTbl_Table_Sp", SQLCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TableID", TableID);
cmd.Parameters.AddWithValue("@CultureCode", CultureCode);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
SQLCon.Close();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
TB_MessageExt model = new TB_MessageExt();
model.ID = Convert.ToInt64(dr["ID"]);
model.MessageSubjectName = dr["FK_MessageSubjectTypeID_ID"].ToString();
model.MessageSubjectID = Convert.ToInt32(dr["MessageSubjectID"].ToString());
model.MessageStatusName = dr["FK_MessageStatusID_ID"].ToString();
model.MessageStatusID = Convert.ToInt32(dr["MessageStatusID"].ToString());
model.TitleName = dr["FK_SalutationTypeID_ID"].ToString();
model.TitleID = Convert.ToInt32(dr["SalutationID"].ToString());
model.Name = dr["Name"].ToString();
model.Surname = dr["Surname"].ToString();
model.Email = dr["Email"].ToString();
model.Phone = dr["Phone"].ToString();
model.CountryName = dr["FK_CountryID_ID"].ToString();
model.CountryID = Convert.ToInt32(dr["CountryID"].ToString());
model.Text = dr["Text"].ToString();
model.Active = Convert.ToBoolean(dr["Active"].ToString());
model.IPAddress = dr["IPAddress"].ToString();
list.Add(model);
}
}
return list;
}
public bool Create(TB_MessageExt model, ref string Msg, Controller ctrl)
{
bool status = true;
TB_Message obj = new TB_Message();
// MailTable.MailTemplateID =model.MailTemplateID;
//obj.ID = model.ID;
obj.MessageSubjectTypeID = model.MessageSubjectID;
obj.MessageStatusID = model.MessageStatusID;
obj.SalutationTypeID = model.TitleID;
obj.Name = model.Name;
obj.Surname = model.Surname;
obj.Email = model.Email;
obj.Phone = model.Phone;
obj.CountryID = model.CountryID;
obj.Text = model.Text;
obj.Active = model.Active;
obj.IPAddress = model.IPAddress;
obj.CreateDateTime = DateTime.Now;
obj.OpDateTime = DateTime.Now;
obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
db.TB_Message.Add(obj);
db.SaveChanges();
Int64 id = obj.ID;
return status;
}
