public bool UpdateBranch(FA_Branch location)
{
string sql = " Update FA_Branch set BranchName=@BranchName,BranchCode=@BranchCode,OrganizationId=@OrganizationId," +
" LastUpdatedBy=@LastUpdatedBy,LastUpdatedDate=@LastUpdatedDate" +
" where BranchId=@BranchId";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Execute(sql, location);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
public bool InsertBranch(FA_Branch location)
{
string sql = " Insert into FA_Branch (BranchName,BranchCode,OrganizationId,EnteredBy,EnteredDate," +
" LastUpdatedBy,LastUpdatedDate,IsDeleted,DeletedDate,DeletedBy) " +
" values " +
"(@BranchName,@BranchCode,@OrganizationId,@EnteredBy,@EnteredDate," +
"0,null,0,null,0)";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Execute(sql, location);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
// GET: Branch/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FA_Branch branch = db.GetBranchById((int)id);
if (branch == null)
{
return(HttpNotFound());
}
//ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", branch.OrganizationId);
return(View(branch));
}
public ActionResult Edit(FormCollection frm)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
FA_Branch branch = db.GetBranchById(Convert.ToInt32(frm["BranchId"]));
branch.BranchName = frm["BranchName"];
branch.BranchCode = frm["BranchCode"];
branch.OrganizationId = orgid;// Convert.ToInt32(frm["OrganizationId"]);
branch.LastUpdatedBy = (User as CustomPrincipal).UserId;
branch.LastUpdatedDate = DateTime.Now;
if (ModelState.IsValid)
{
db.UpdateBranch(branch);
return(RedirectToAction("Index"));
}
return(View(branch));
}
public ActionResult Create(FormCollection frm)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
FA_Branch branch = new FA_Branch();
branch.BranchName = frm["BranchName"];
branch.BranchCode = frm["BranchCode"];
branch.OrganizationId = orgid;// Convert.ToInt32(frm["OrganizationId"]);
branch.EnteredBy = (User as CustomPrincipal).UserId;
branch.EnteredDate = DateTime.Now;
if (ModelState.IsValid)
{
db.InsertBranch(branch);
return(RedirectToAction("Index"));
}
//ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", branch.OrganizationId);
return(View(branch));
}
