public List <AppVersionControlCommon> GetAppVersionList()
{
string sql = "exec sproc_app_version_control ";
sql += " @flag='s'";
var dt = dao.ExecuteDataTable(sql);
var list = new List <AppVersionControlCommon>();
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
AppVersionControlCommon common = new AppVersionControlCommon()
{
VersionId = item["vid"].ToString(),
AppVersion = item["app_version"].ToString(),
AppPlatform = item["app_platform"].ToString(),
IsMajorUpdate = item["is_major_update"].ToString(),
IsMinorUpdate = item["is_minor_update"].ToString(),
CreatedBy = item["created_by"].ToString()
};
list.Add(common);
}
}
return(list);
}
public ActionResult Manage(AppVersionControlModel AVM)
{
ViewBag.platform = ApplicationUtilities.SetDDLValue(LoadDropdownList("platform"), "", "--Select Application Platform--");
if (ModelState.IsValid)
{
if (AVM.IsMajorUpdate.ToUpper() != "Y")
{
AVM.IsMajorUpdate = "N";
}
if (AVM.IsMinorUpdate.ToUpper() != "Y")
{
AVM.IsMinorUpdate = "N";
}
if (AVM.IsMinorUpdate.ToUpper() == "N" && AVM.IsMajorUpdate.ToUpper() == "N")
{
ModelState.AddModelError("IsMajorUpdate", "Invalid Parameter");
return(View(AVM));
}
AppVersionControlCommon AVC = new AppVersionControlCommon();
AVC = AVM.MapObject <AppVersionControlCommon>();
AVC.ActionUser = ApplicationUtilities.GetSessionValue("username").ToString();
AVC.IpAddress = ApplicationUtilities.GetIP();
var dbresp = buss.ManageAppVersion(AVC);
if (dbresp.Code == 0)
{
this.ShowPopup(0, "Successfully Inserted");
return(RedirectToAction("Index"));
}
}
this.ShowPopup(1, "Error");
return(View(AVM));
}
public CommonDbResponse ManageAppVersion(AppVersionControlCommon AVC)
{
string sql = "exec sproc_app_version_control ";
sql += " @flag='i'";
sql += " ,@app_platform=" + dao.FilterString(AVC.AppPlatform);
sql += " ,@app_version=" + dao.FilterString(AVC.AppVersion);
sql += " ,@is_major_update=" + dao.FilterString(AVC.IsMajorUpdate);
sql += " ,@is_minor_update=" + dao.FilterString(AVC.IsMinorUpdate);
sql += " ,@app_update_info=" + dao.FilterString(AVC.AppUpdateInfo);
sql += " ,@ipAddress=" + dao.FilterString(AVC.IpAddress);
sql += " ,@Action_user=" + dao.FilterString(AVC.ActionUser);
return(dao.ParseCommonDbResponse(sql));
}
public CommonDbResponse ManageAppVersion(AppVersionControlCommon AVC)
{
return(repo.ManageAppVersion(AVC));
}
