public List <StaticDataCommon> GetStaticDataList(string staticdatatypeid) { string sql = "exec [sproc_static_data_setup]"; sql += " @flag='sdlst'"; sql += " ,@sdata_type_id=" + dao.FilterString(staticdatatypeid); var dt = dao.ExecuteDataTable(sql); List <StaticDataCommon> lst = new List <StaticDataCommon>(); if (dt != null) { foreach (DataRow item in dt.Rows) { StaticDataCommon SDC = new StaticDataCommon { StaticDataTypeId = item["sdata_type_id"].ToString(), StaticDataId = item["static_data_row_id"].ToString(), StaticDataValue = item["static_data_value"].ToString(), StaticDataLabel = item["static_data_label"].ToString(), IsDeleted = item["is_deleted"].ToString(), StaticDataDescription = item["static_data_description"].ToString() }; lst.Add(SDC); } } return(lst); }
public JsonResult EnableSData(string sdatatypeId, string sdataid) { if (!string.IsNullOrEmpty(sdataid) && !string.IsNullOrEmpty(sdatatypeId)) { sdataid = sdataid.DecryptParameter(); sdatatypeId = sdatatypeId.DecryptParameter(); if (!string.IsNullOrEmpty(sdataid) && !string.IsNullOrEmpty(sdatatypeId)) { StaticDataCommon sdc = new StaticDataCommon(); sdc.StaticDataId = sdataid; sdc.StaticDataTypeId = sdatatypeId; sdc.ActionUser = Session["username"].ToString(); CommonDbResponse dbresp = buss.block_unblockStaticData(sdc, "N"); if (dbresp.Code == 0) { dbresp.Message = "Successfully Un-Blocked Static Data"; dbresp.SetMessageInTempData(this); } return(Json(dbresp)); } } return(Json(new CommonDbResponse { ErrorCode = 1, Message = "Invalid Static Data" })); }
public CommonDbResponse block_unblockStaticData(StaticDataCommon SDC, string status) { string sql = "exec sproc_static_data_setup "; sql += "@flag='d'"; sql += ",@status=" + dao.FilterString(status); sql += ",@sdatarowid=" + dao.FilterString(SDC.StaticDataId); sql += ",@sdata_type_id=" + dao.FilterString(SDC.StaticDataTypeId); sql += ",@createdby=" + dao.FilterString(SDC.ActionUser); return(dao.ParseCommonDbResponse(sql)); }
public DbResponse Manage(StaticDataCommon model) { var sql = "EXEC proc_tblStaticData "; sql += " @FLAG = " + dao.FilterString((model.UniqueId > 0 ? "U" : "I")); sql += ",@User = "******",@Id = " + dao.FilterString(model.UniqueId.ToString()); sql += ",@StaticCode = " + dao.FilterString(model.TypeCode); sql += ",@Code = " + dao.FilterString(model.DataCode); sql += ",@Value = " + dao.FilterString(model.DataValue); sql += ",@IsActive= " + dao.FilterString(model.IsActive);; //ssql += ",@NepValue = " + dao.FilterString_NVARCHAR(model.NepValue); return(dao.ParseDbResponse(sql)); }
public CommonDbResponse ManageStaticData(StaticDataCommon sdc) { string sql = "exec [sproc_static_data_setup]"; sql += " @flag='" + (string.IsNullOrEmpty(sdc.StaticDataId)?"i":"u") + "'"; sql += " ,@sdata_type_id=" + dao.FilterString(sdc.StaticDataTypeId); sql += " ,@sdatarowid=" + dao.FilterString(sdc.StaticDataId); sql += " ,@slabel=" + dao.FilterString(sdc.StaticDataLabel); sql += " ,@svalue=" + dao.FilterString(sdc.StaticDataValue); sql += " ,@sdatatype=" + dao.FilterString(sdc.StaticDataDescription); sql += " ,@createdby=" + dao.FilterString(sdc.ActionUser); return(dao.ParseCommonDbResponse(sql)); }
public ActionResult Manage(string code, string id) { //StaticData.CheckFunctionId(AddEditId); id = StaticData.GetIdFromQuery(); var data = buss.GetList(StaticData.GetUser(), id, "", 0); if (data.Count == 0) { StaticDataCommon model = new StaticDataCommon(); model.BreadCum = ApplicationGrid.GetBreadCum("SetUp |Static Data |Manage "); return(View(model)); } data[0].BreadCum = ApplicationGrid.GetBreadCum("SetUp |Static Data |Manage"); return(View(data[0])); }
public ActionResult Manage(StaticDataCommon model) { //StaticData.CheckFunctionId(AddEditId); if (ModelState.IsValid) { model.User = StaticData.GetUser(); var response = buss.Manage(model); if (response.ErrorCode == 1) { ModelState.AddModelError("", response.Message); return(View(model)); } return(RedirectToAction("Index")); } return(View(model)); }
public List <StaticDataCommon> GetGridList(GridParam gridParam) { var list = new List <StaticDataCommon>(); try { var sql = "EXEC proc_tblStaticData "; sql += " @FLAG = " + dao.FilterString("A"); sql += ",@User = "******",@Search = " + dao.FilterString(gridParam.Search); sql += ",@DisplayLength = " + dao.FilterString(gridParam.DisplayLength.ToString()); sql += ",@DisplayStart = " + dao.FilterString(gridParam.DisplayStart.ToString()); sql += ",@SortDir = " + dao.FilterString(gridParam.SortDir); sql += ",@SortCol = " + dao.FilterString(gridParam.SortCol.ToString()); var dt = dao.ExecuteDataTable(sql); if (null != dt) { int sn = 1; foreach (System.Data.DataRow item in dt.Rows) { var common = new StaticDataCommon() { UniqueId = Convert.ToInt32(item["RowNum"]), TypeCode = item["StaticCode"].ToString(), DataCode = item["Code"].ToString(), DataValue = item["Value"].ToString(), IsActive = item["IsActive"].ToString(), User = item["CreatedBy"].ToString(), CreatedDate = item["CreatedDate"].ToString(), FilterCount = item["FilterCount"].ToString(), }; sn++; list.Add(common); } } return(list); } catch (Exception e) { return(list); } }
public List <StaticDataCommon> GetList(string user, string id, string Search, int Pagesize) { var list = new List <StaticDataCommon>(); try { var sql = "EXEC proc_tblStaticData "; sql += " @FLAG = " + dao.FilterString(id != "0" ? "S" : "A"); sql += ",@User = "******",@ID = " + dao.FilterString(id.ToString()); sql += ",@Search = " + dao.FilterString(Search); sql += ",@Pagesize = " + dao.FilterString(Pagesize.ToString()); var dt = dao.ExecuteDataTable(sql); if (null != dt) { int sn = 1; foreach (DataRow item in dt.Rows) { var common = new StaticDataCommon() { UniqueId = Convert.ToInt32(item["Id"]), TypeCode = item["StaticCode"].ToString(), //StaticData = item["StaticData"].ToString(), DataCode = item["Code"].ToString(), DataValue = item["Value"].ToString(), IsActive = item["IsActive"].ToString(), User = item["CreatedBy"].ToString(), CreatedDate = item["CreatedDate"].ToString() }; sn++; list.Add(common); } } } catch (Exception e) { return(list); } return(list); }
/* * public List<StaticDataCommon> GetList(string user, string id, string Search, int Pagesize) * { * var list = new List<StaticDataCommon>(); * try * { * * var sql = "EXEC proc_tblStaticData "; * sql += " @FLAG = " + dao.FilterString(id != "0" ? "S" : "A"); * sql += ",@User = "******",@ID = " + dao.FilterString(id.ToString()); * sql += ",@Search = " + dao.FilterString(Search); * sql += ",@Pagesize = " + dao.FilterString(Pagesize.ToString()); * * var dt = dao.ExecuteDataTable(sql); * if (null != dt) * { * int sn = 1; * foreach (DataRow item in dt.Rows) * { * var common = new StaticDataCommon() * { * * UniqueId = item["Id"].ToString(), * TypeCode = item["StaticCode"].ToString(), * DataCode = item["Code"].ToString(), * DataValue = item["Value"].ToString(), * NepValue = item["NepValue"].ToString(), * ActionUser = item["CreatedBy"].ToString(), * * }; * sn++; * list.Add(common); * } * } * } * catch (Exception e) * { * * return list; * } * * return list; * }*/ public List <StaticDataCommon> GetStaticDataTypeList() { string sql = "exec [sproc_static_data_setup]"; sql += " @flag='st'"; var dt = dao.ExecuteDataTable(sql); List <StaticDataCommon> lst = new List <StaticDataCommon>(); if (dt != null) { foreach (DataRow item in dt.Rows) { StaticDataCommon SDC = new StaticDataCommon { StaticDataTypeId = item["sdata_type_id"].ToString(), StaticDataTypeName = item["static_data_name"].ToString(), StaticDataTypeDescription = item["static_data_description"].ToString() }; lst.Add(SDC); } } return(lst); }
public StaticDataCommon GetStaticDataById(string staticdataId, string staticdatatypeId) { string sql = "exec [sproc_static_data_setup]"; sql += " @flag='sdid'"; sql += " ,@sdata_type_id=" + dao.FilterString(staticdatatypeId); sql += " ,@sdatarowid=" + dao.FilterString(staticdataId); var dt = dao.ExecuteDataRow(sql); StaticDataCommon SDC = new StaticDataCommon(); if (dt != null) { SDC.StaticDataId = dt["static_data_row_id"].ToString(); SDC.StaticDataTypeId = dt["sdata_type_id"].ToString(); SDC.StaticDataLabel = dt["static_data_label"].ToString(); SDC.StaticDataValue = dt["static_data_value"].ToString(); SDC.StaticDataDescription = dt["static_data_description"].ToString(); SDC.AdditionalValue1 = dt["additional_value1"].ToString(); SDC.AdditionalValue2 = dt["additional_value2"].ToString(); SDC.AdditionalValue3 = dt["additional_value3"].ToString(); SDC.AdditionalValue4 = dt["additional_value4"].ToString(); } return(SDC); }
public ActionResult ManageStaticData(string sdatatypeId, string sdataid = "") { StaticDataCommon SDC = new StaticDataCommon(); StaticDataModel SDM = new StaticDataModel(); if (!string.IsNullOrEmpty(sdatatypeId)) { SDM.StaticDataTypeId = sdatatypeId; sdatatypeId = sdatatypeId.DecryptParameter().ToString(); if (!string.IsNullOrEmpty(sdatatypeId) && !string.IsNullOrEmpty(sdataid)) { sdataid = sdataid.DecryptParameter(); if (!string.IsNullOrEmpty(sdataid)) { SDC = buss.GetStaticDataById(sdataid, sdatatypeId); SDC.StaticDataTypeId = SDC.StaticDataTypeId.EncryptParameter(); SDC.StaticDataId = SDC.StaticDataId.EncryptParameter(); SDM = SDC.MapObject <StaticDataModel>(); } } return(View(SDM)); } return(RedirectToAction("StaticDataList", new { SdatatypeID = SDM.StaticDataTypeId })); }
public ActionResult ManageStaticData(StaticDataModel SDM) { StaticDataCommon SDC = new StaticDataCommon(); if (ModelState.IsValid) { SDC = SDM.MapObject <StaticDataCommon>(); SDC.StaticDataTypeId = SDC.StaticDataTypeId.DecryptParameter(); if (!string.IsNullOrEmpty(SDC.StaticDataId)) { SDC.StaticDataId = SDC.StaticDataId.DecryptParameter(); } SDC.ActionUser = Session["username"].ToString(); CommonDbResponse dbresp = buss.ManageStaticData(SDC); if (dbresp.Code == 0) { this.ShowPopup(0, dbresp.Message); return(RedirectToAction("StaticDataList", new { SdatatypeID = SDM.StaticDataTypeId })); } } this.ShowPopup(1, "Error"); return(View(SDM)); }
public CommonDbResponse block_unblockStaticData(StaticDataCommon SDC, string status) { return(repo.block_unblockStaticData(SDC, status)); }
public CommonDbResponse ManageStaticData(StaticDataCommon sdc) { return(repo.ManageStaticData(sdc)); }
public DbResponse Manage(StaticDataCommon model) { return(repo.Manage(model)); }