public bool Update(MessageExt model, ref string Msg, Controller ctrl) { bool status = true; using (DBEntities DE = new DBEntities()) { var MessageTable = DE.BizTbl_Message.Where(x => x.ID == model.ID).FirstOrDefault(); MessageTable.Code = model.Code; MessageTable.Description_en = model.Description_en; MessageTable.Description_tr = model.Description_tr; MessageTable.Description_de = model.Description_de; MessageTable.Description_es = model.Description_es; MessageTable.Description_fr = model.Description_fr; MessageTable.Description_ru = model.Description_ru; MessageTable.Description_it = model.Description_it; MessageTable.Description_ar = model.Description_ar; MessageTable.Description_ja = model.Description_ja; MessageTable.Description_pt = model.Description_pt; MessageTable.Description_zh = model.Description_zh; MessageTable.IsCommon = model.IsCommon; MessageTable.OpDateTime = DateTime.Now; MessageTable.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); DE.SaveChanges(); } //var IDParam = new SqlParameter("@ID", model.ID); //var CodeParam = new SqlParameter("@Code", model.Code); //var Description_trparam = new SqlParameter("@Description_tr", model.Description_tr); //var Description_enparam = new SqlParameter("@Description_en", model.Description_en); //var Description_deparam = new SqlParameter("@Description_de", model.Description_de); //var Description_esparam = new SqlParameter("@Description_es", model.Description_es); //var Description_frParam = new SqlParameter("@Description_fr", model.Description_fr); //var Description_ruparam = new SqlParameter("@Description_ru", model.Description_ru); //var Description_itparam = new SqlParameter("@Description_it", model.Description_it); //var Description_arparam = new SqlParameter("@Description_ar", model.Description_ar); //var Description_jaParam = new SqlParameter("@Description_ja", model.Description_ja); //var Description_ptParam = new SqlParameter("@Description_pt", model.Description_pt); //var Description_zhparam = new SqlParameter("@Description_zh", model.Description_zh); //var IsCommonparam = new SqlParameter("@IsCommon", model.IsCommon); //var i = updateentity.Database.ExecuteSqlCommand("B_Ex_Update_BizTbl_Message_SP @ID,@Code,@Description_tr,@Description_en,@Description_de,@Description_es,@Description_fr,@Description_ru,@Description_it,@Description_ar,@Description_ja,@Description_pt,@Description_zh,@IsCommon", IDParam, CodeParam, Description_trparam, Description_enparam, Description_deparam, Description_esparam, Description_frParam, Description_ruparam, Description_itparam, Description_itparam, Description_arparam, Description_jaParam, Description_ptParam, Description_zhparam, IsCommonparam); return status; }
public bool Delete(MessageExt model, ref string Msg, Controller ctrl) { bool status = true; //DBEntities insertentity = new DBEntities(); //var IDParam = new SqlParameter("@ID", model.ID); //int i = insertentity.Database.ExecuteSqlCommand("B_Ex_Delete_BizTbl_Message_SP @ID", IDParam); using (DBEntities DE = new DBEntities()) { var MessageTable = DE.BizTbl_Message.Where(x => x.ID == model.ID).FirstOrDefault(); DE.BizTbl_Message.Remove(MessageTable); DE.SaveChanges(); } return status; }
public List<MessageExt> GetAllMessages() { DBEntities entity = new DBEntities(); var result = entity.Database.SqlQuery<BizTbl_Message>("B_EX_GetAllMessage_BizTbl_Message_SP").ToList(); List<MessageExt> ListOfModel = new List<MessageExt>(); DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("Code"); dt.Columns.Add("Description_en"); dt.Columns.Add("Description_tr"); dt.Columns.Add("Description_de"); dt.Columns.Add("Description_es"); dt.Columns.Add("Description_fr"); dt.Columns.Add("Description_ru"); dt.Columns.Add("Description_it"); dt.Columns.Add("Description_ar"); dt.Columns.Add("Description_ja"); dt.Columns.Add("Description_pt"); dt.Columns.Add("Description_zh"); dt.Columns.Add("IsCommon"); foreach (BizTbl_Message dr in result) { dt.Rows.Add(dr.ID, dr.Code, dr.Description_en, dr.Description_tr, dr.Description_de, dr.Description_es, dr.Description_fr, dr.Description_ru, dr.Description_it, dr.Description_ar, dr.Description_ja, dr.Description_pt, dr.Description_zh, dr.IsCommon); } if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { MessageExt MsgObj = new MessageExt(); MsgObj.ID = Convert.ToInt32(dr["ID"]); MsgObj.Code = dr["Code"].ToString(); MsgObj.Description_en = dr["Description_en"].ToString(); MsgObj.Description_tr = dr["Description_tr"].ToString(); MsgObj.Description_de = dr["Description_de"].ToString(); MsgObj.Description_es = dr["Description_es"].ToString(); MsgObj.Description_fr = dr["Description_fr"].ToString(); MsgObj.Description_ru = dr["Description_ru"].ToString(); MsgObj.Description_it = dr["Description_it"].ToString(); MsgObj.Description_ar = dr["Description_ar"].ToString(); MsgObj.Description_ja = dr["Description_ja"].ToString(); MsgObj.Description_pt = dr["Description_pt"].ToString(); MsgObj.Description_zh = dr["Description_zh"].ToString(); MsgObj.IsCommon = Convert.ToBoolean(dr["IsCommon"].ToString()); ListOfModel.Add(MsgObj); } } return ListOfModel; }
public bool Create(MessageExt model, ref string Msg, Controller ctrl) { bool status = true; DBEntities insertentity = new DBEntities(); BizTbl_Message MsgObj = new BizTbl_Message(); MsgObj.Code = model.Code; MsgObj.Description_tr = model.Description_tr; MsgObj.Description_en = model.Description_en; MsgObj.Description_de = model.Description_de; MsgObj.Description_es = model.Description_es; MsgObj.Description_fr = model.Description_fr; MsgObj.Description_ru = model.Description_ru; MsgObj.Description_it = model.Description_it; MsgObj.Description_ar = model.Description_ar; MsgObj.Description_ja = model.Description_ja; MsgObj.Description_pt = model.Description_pt; MsgObj.Description_zh = model.Description_zh; MsgObj.Description_pt = model.Description_pt; MsgObj.IsCommon = true; MsgObj.OpDateTime = DateTime.Now; MsgObj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); insertentity.BizTbl_Message.Add(MsgObj); insertentity.SaveChanges(); int id = MsgObj.ID; return status; }