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