public static bool AddATCHeader(ATCRequestHeader astBud)
{
try
{
using (BudgetCaptureDBEntities db = new BudgetCaptureDBEntities())
{
db.ATCRequestHeaders.Add(astBud);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
// Utility.WriteError("Error Msg: " + ex.Message);
throw ex;
}
}
public static string GenerateBatchID(int budgetYrID, int deptId, int budgetType)
{
using (BudgetCaptureDBEntities db = new BudgetCaptureDBEntities())
{
var q = from p in db.ATCRequestHeaders.OrderByDescending(p => p.RequestDate) where p.BudgetYrID == budgetYrID && p.DepartmentID == deptId && p.BudgetTypeId == budgetType select p;
if (q != null && q.Count() > 0)
{
ATCRequestHeader rq = q.FirstOrDefault();
string no = rq.BatchID.Split('-')[1];
int val = int.Parse(no);
return((val + 1).ToString());
}
else
{
return("1");
}
}
}
public static bool UpdateATCHeader(ATCRequestHeader astBud)
{
try
{
bool rst = false;
using (var db = new BudgetCaptureDBEntities())
{
db.ATCRequestHeaders.Attach(astBud);
db.Entry(astBud).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
rst = true;
}
return(rst);
}
catch (Exception ex)
{
// Utility.WriteError("Error Msg: " + ex.Message);
throw ex;
}
}
protected void gvDept_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "edt")
{
ATCRequestHeader header = CommonBLL.GetATCHeader(int.Parse(e.CommandArgument.ToString()));
string budgetType = header.BudgetMenuItem.Code;
string batchId = header.BatchID;
int deptId = header.DepartmentID.Value;
if (budgetType == "MO")
{
Response.Redirect(string.Format("MovableAsset.aspx?deptId={0}&&batchId={1}&&Id={2}", deptId, batchId, header.ID), false);
}
if (budgetType == "SA")
{
Response.Redirect(string.Format("ExistingStaffpg.aspx?deptId={0}&&batchId={1}&&Id={2}", deptId, batchId, header.ID), false);
}
if (budgetType == "ID")
{
Response.Redirect(string.Format("IndirectBudgetPg.aspx?deptId={0}&&batchId={1}&&Id={2}", deptId, batchId, header.ID), false);
}
if (budgetType == "DI")
{
Response.Redirect(string.Format("DirectBudgetPg.aspx?deptId={0}&&batchId={1}&&Id={2}", deptId, batchId, header.ID), false);
}
if (budgetType == "CA")
{
Response.Redirect(string.Format("CapexBudgetPg.aspx?deptId={0}&&batchId={1}&&Id={2}", deptId, batchId, header.ID), false);
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!";
Utility.WriteError("Error: " + ex.InnerException);
}
}
