public ActionResult addMoreB2BLC(short id, int?page)
{
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
List <BACKTOBACKLC> b2bList = new List <BACKTOBACKLC>();
EXBOND exbond = db.EXBONDs.Find(id);
int id1 = exbond.BONDER.BONDERSLNO;
bool flag = false;
var b2b = db.BACKTOBACKLCs.Where(eb => eb.BONDERID == id1 && (eb.BACKTOBACKPRODUCTs.Count() > 0)).ToList();
for (int i = 0; i < b2b.Count(); i++)
{
BACKTOBACKLC b2blc = db.BACKTOBACKLCs.Find(b2b[i].ID);
if (b2blc != null && b2blc.EXBONDBACKTOBACKs.Count() < 1)
{
flag = true;
b2bList.Add(b2blc);
}
}
if (!flag)
{
return(RedirectToAction("Edit/" + id, new { error = "Sorry! There is no more Back to Back LC exist for this bonder" }));
}
ViewBag.ExbondID = id;
ViewBag.resultofbonderID = exbond.BONDERID;
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", exbond.BONDER.BONDERNAME);
int pageSize = recordNumbers;
int pageNumber = (page ?? 1);
return(View("Lcselector", b2bList.ToPagedList(pageNumber, pageSize)));
// return View("Lcselector", b2bList);
}
public ActionResult Addmore(string errorMessage, short id = 0)
{
BACKTOBACKLC backtobacklc = db.BACKTOBACKLCs.Find(id);
if (backtobacklc == null)
{
return(HttpNotFound());
}
ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backtobacklc.BUYERSBANKBRANCHID);
ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backtobacklc.BUYERSBANKID);
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
if (loggedinUser != null && loggedinUser.BONDERID != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", loggedinUser.BONDERID);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID);
}
//ViewBag.QUANTITYUNIT = new SelectList("Piece", "KG");
ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.QUANTITYUNIT);
ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backtobacklc.PRICEUNIT);
for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++)
{
ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.BACKTOBACKPRODUCTs[i].QUANTITYUNIT);
}
if (errorMessage != null && !errorMessage.Trim().Equals(""))
{
ModelState.AddModelError("editerror", errorMessage);
return(View(backtobacklc));
}
return(View(backtobacklc));
}
protected void Application_PostAuthenticateRequest(Object sender, EventArgs e)
{
if (FormsAuthentication.CookiesSupported == true)
{
if (Request.Cookies[FormsAuthentication.FormsCookieName] != null)
{
try
{
//let us take out the username now
string username = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name;
String userRole = "";
using (OracleEntitiesConnStr db = new OracleEntitiesConnStr())
{
APPUSER appuser = db.APPUSERs.SingleOrDefault(u => u.USERNAME.Equals(username, StringComparison.OrdinalIgnoreCase));
USERPERMISSION userpermission = db.USERPERMISSIONs.SingleOrDefault(u => u.USERID == appuser.ID);
string role = userpermission.ROLENAME;
userRole = role;
System.Web.HttpContext.Current.User = new System.Security.Principal.GenericPrincipal(
new System.Security.Principal.GenericIdentity(username, "Forms"), new[] { userRole });
}
}
catch (Exception)
{
}
}
}
}
public ActionResult DeleteConfirmed(short id)
{
USERPERMISSION userpermission = db.USERPERMISSIONs.Find(id);
db.USERPERMISSIONs.Remove(userpermission);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Details(short id = 0)
{
USERPERMISSION userpermission = db.USERPERMISSIONs.Find(id);
if (userpermission == null)
{
return(HttpNotFound());
}
return(View(userpermission));
}
public ActionResult BondEntitlementList()
{
if (!(System.Web.HttpContext.Current.User.IsInRole("Bonder"))) // added By Mizan (18 Aug 2016)--
{
var EntitlementList = from e in db.BONDERANNUALENTITLEMENTs
group e by e.BONDERSLNO
into g
select new
{
bonderslno = g.Key,
aeslno = (from t2 in g select t2.AESLNO).Max()
};
List <BONDERANNUALENTITLEMENT> entlmntlst = new List <BONDERANNUALENTITLEMENT>();
foreach (var item in EntitlementList)
{
entlmntlst.Add(
new BONDERANNUALENTITLEMENT
{
AESLNO = item.aeslno,
BONDERSLNO = item.bonderslno,
INPUTBY = (from t2 in db.BONDERs where t2.BONDERSLNO == item.bonderslno select t2.BONDERNAME).FirstOrDefault(),
MODIFIEDBY = (from t2 in db.BONDERs where t2.BONDERSLNO == item.bonderslno select t2.BONDLICENSENO).FirstOrDefault()
});
}
return(View(entlmntlst));
}
else // added By Mizan (18 Aug 2016)--
{
USERPERMISSION permission = session.getStoredUserPermission();
var bonderName = permission.BONDER.BONDERNAME;
var EntitlementList = from e in db.BONDERANNUALENTITLEMENTs.Where(e => e.BONDER.BONDERNAME == bonderName)
group e by e.BONDERSLNO
into g
select new
{
bonderslno = g.Key,
aeslno = (from t2 in g select t2.AESLNO).Max()
};
List <BONDERANNUALENTITLEMENT> entlmntlst = new List <BONDERANNUALENTITLEMENT>();
foreach (var item in EntitlementList)
{
entlmntlst.Add(
new BONDERANNUALENTITLEMENT
{
AESLNO = item.aeslno,
BONDERSLNO = item.bonderslno,
INPUTBY = (from t2 in db.BONDERs where t2.BONDERSLNO == item.bonderslno select t2.BONDERNAME).FirstOrDefault(),
MODIFIEDBY = (from t2 in db.BONDERs where t2.BONDERSLNO == item.bonderslno select t2.BONDLICENSENO).FirstOrDefault()
});
}
return(View(entlmntlst));
}
}
public ActionResult AddRawMaterial(BACKTOBACKPRODUCT backtobackProduct)
{
USERPERMISSION userpermission = sessionAttributeRetreival.getStoredUserPermission();
foreach (var item in backtobackProduct.RAWMATERIALs)
{
item.PRODUCTID = backtobackProduct.ID;
}
DateTime thisDay = DateTime.Now;
var user = "******";
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " ModelState.IsValid: " + ModelState.IsValid);
// if (ModelState.IsValid)
if (true)
{
try
{
foreach (var rawMaterial in backtobackProduct.RAWMATERIALs)
{
var productId = rawMaterial.PRODUCTID;
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " productId: " + productId);
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " backtobackProduct.BACKTOBACKLCID: " + backtobackProduct.BACKTOBACKLCID);
using (var dbRawMaterial = new OracleEntitiesConnStr())
{
RAWMATERIAL newRawMaterial = new RAWMATERIAL();
newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE;
newRawMaterial.QUANTITY = rawMaterial.QUANTITY;
newRawMaterial.UNIT = rawMaterial.UNIT;
newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE;
newRawMaterial.PRODUCTID = productId;
if (userpermission != null)
{
newRawMaterial.CREATEDBY = userpermission.APPUSER.USERNAME;
}
newRawMaterial.CREATEDDATE = thisDay;
dbRawMaterial.RAWMATERIALs.Add(newRawMaterial);
dbRawMaterial.SaveChanges();
}
}
return(RedirectToAction("Details/" + backtobackProduct.BACKTOBACKLCID));
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("Create(BACKTOBACKPRODUCTs): Time-" + thisDay + " Exception = " + e.StackTrace);
}
}
return(View());
}
public ActionResult Edit(short id = 0)
{
USERPERMISSION userpermission = db.USERPERMISSIONs.Find(id);
if (userpermission == null)
{
return(HttpNotFound());
}
ViewBag.USERID = new SelectList(db.APPUSERs, "ID", "USERNAME", userpermission.USERID);
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", userpermission.BONDERID);
ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME", userpermission.EMPLOYID);
return(View(userpermission));
}
public ActionResult Edit(USERPERMISSION userpermission)
{
if (ModelState.IsValid)
{
db.Entry(userpermission).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.USERID = new SelectList(db.APPUSERs, "ID", "USERNAME", userpermission.USERID);
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", userpermission.BONDERID);
ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME", userpermission.EMPLOYID);
return(View(userpermission));
}
public USERPERMISSION getStoredUserPermission()
{
string username = FormsAuthentication.Decrypt(HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name;
APPUSER appuser = db.APPUSERs.SingleOrDefault(u => u.USERNAME.Equals(username, StringComparison.OrdinalIgnoreCase));
try
{
USERPERMISSION userpermission = db.USERPERMISSIONs.SingleOrDefault(u => u.USERID == appuser.ID);
return(userpermission);
}
catch (NullReferenceException exp) {
return(null);
}
}
//------------Mizan Work ----------------------
public ActionResult EntitlementReport()
{
if (!(System.Web.HttpContext.Current.User.IsInRole("Bonder"))) // added By Mizan (18 Aug 2016)--
{
ViewBag.AESLNO = new SelectList(db.BONDERANNUALENTITLEMENTs, "AESLNO", "AESLNO");
}
else // added By Mizan (18 Aug 2016)--
{
USERPERMISSION permission = session.getStoredUserPermission();
var bonderName = permission.BONDER.BONDERNAME;
ViewBag.AESLNO = new SelectList(db.BONDERANNUALENTITLEMENTs.Where(x => x.BONDER.BONDERNAME == bonderName), "AESLNO", "AESLNO");
}
return(View("EntitlementDetailsCrReport"));
}
public ActionResult Create()
{
ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME");
ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME");
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
if (loggedinUser != null && loggedinUser.BONDERID != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", loggedinUser.BONDERID);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME");
}
ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text");
ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text");
return(View());
}
public ActionResult Login(LoginModel loginModel, string returnUrl)
{
if (loginModel.USERNAME == null || loginModel.PASSWARD == null || loginModel.USERNAME.Trim().Equals("") || loginModel.PASSWARD.Trim().Equals(""))
{
ModelState.AddModelError("", "Wrong Username or Password");
}
List <APPUSER> appusers = db.APPUSERs.ToList();
foreach (var appuser in appusers)
{
if (appuser.USERNAME.Equals(loginModel.USERNAME) && encryptionDecryptionUtil.VerifyPassword(appuser.PASSWARD, loginModel.PASSWARD, appuser.SALT))
{
FormsAuthentication.SetAuthCookie(loginModel.USERNAME, false);
if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") &&
!returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\"))
{
return(Redirect(returnUrl));
}
else
{
USERPERMISSION userpermission = db.USERPERMISSIONs.SingleOrDefault(u => u.USERID == appuser.ID);
if (userpermission == null)
{
FormsAuthentication.SignOut();
return(RedirectToAction("AccessDenied", "Error", null));
}
appuser.LASTLOGIN = DateTime.Now;
db.Entry(appuser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
}
}
if (ModelState.IsValid)
{
ModelState.AddModelError("", "Wrong Username or Password");
}
return(View(loginModel));
}
public ActionResult Create(APPUSER appuser)
{
USERPERMISSION userpermission = db.USERPERMISSIONs.SingleOrDefault(u => u.USERID == appuser.ID);
if (userpermission == null)
{
List <APPUSER> appusers = new List <APPUSER>();
List <SelectListItem> listItem = new List <SelectListItem>();
listItem.Add(new SelectListItem
{
Text = "Bonder",
Value = "Bonder",
});
listItem.Add(new SelectListItem
{
Text = "Operation Admin",
Value = "Operation Admin",
});
appusers.Add(appuser);
ViewBag.USERID = new SelectList(appusers, "ID", "USERNAME");
ViewBag.ROLENAME = listItem;
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME");
ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME");
}
else
{
List <APPUSER> appusers = new List <APPUSER>();
appusers.Add(appuser);
List <SelectListItem> listItem = new List <SelectListItem>();
if (userpermission.ROLENAME.Equals("Bonder"))
{
listItem.Add(new SelectListItem
{
Text = "Bonder",
Value = "Bonder",
Selected = true,
});
listItem.Add(new SelectListItem
{
Text = "Operation Admin",
Value = "Operation Admin"
});
}
else if (userpermission.ROLENAME.Equals("Operation Admin"))
{
listItem.Add(new SelectListItem
{
Text = "Bonder",
Value = "Bonder",
});
listItem.Add(new SelectListItem
{
Text = "Operation Admin",
Value = "Operation Admin",
Selected = true
});
}
ViewBag.USERID = new SelectList(appusers, "ID", "USERNAME");
if (userpermission.BONDER != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", userpermission.BONDER.BONDERNAME);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME");
}
if (userpermission.EMPLOYEE != null)
{
ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME", userpermission.EMPLOYEE.EMPLOYEENAME);
}
else
{
ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME");
}
ViewBag.ROLENAME = listItem;
ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME");
}
return(View());
}
public ActionResult CreateorEditExbond(IList <BACKTOBACKLC> backtobacklcs, short ID = 0)
{
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
IList <BACKTOBACKLC> b2bList = new List <BACKTOBACKLC>();
EXBOND exbond = new EXBOND();
if (backtobacklcs == null)
{
return(RedirectToAction("Create", new { error = "Please select at least one back to back lc" }));
}
bool flag = true;
bool isanyselected = false;
for (int i = 0; i < backtobacklcs.Count(); i++)
{
int id = backtobacklcs[i].ID;
if (backtobacklcs[i].IsSelected)
{
isanyselected = true;
BACKTOBACKLC back2backlc = db.BACKTOBACKLCs.Find(id);
int productCount = back2backlc.BACKTOBACKPRODUCTs.Count();
if (productCount < 1)
{
flag = false;
}
else
{
exbond.BONDERID = backtobacklcs[i].BONDER.BONDERSLNO;
b2bList.Add(back2backlc);
}
}
}
if (!isanyselected && ID <= 0)
{
return(RedirectToAction("Create", new { error = "Please select at least one back to back lc" }));
}
if (!flag && ID <= 0)
{
return(RedirectToAction("Create", new { error = "Sorry! please check all selected LC has at least one product" }));
}
else
{
short lastInserted = 0;
//if (ModelState.IsValid)
//{
if (ID <= 0) //add new exbond
{
if (loggedinUser != null)
{
exbond.CREATEDBY = loggedinUser.APPUSER.USERNAME;
}
//else
//{
// exbond.CREATEDBY = "" + loggedinUser.USERID;
//}
exbond.CREATEDDATE = DateTime.Today;
db.EXBONDs.Add(exbond);
try
{
db.SaveChanges();
}
catch (Exception e) {
Console.WriteLine(e.ToString());
}
lastInserted = db.EXBONDs.Max(item => item.ID);
}
else //edit new exbond
{
using (var db2 = new OracleEntitiesConnStr())
{
exbond = db.EXBONDs.Find(ID);
EXBOND newExbond = new EXBOND();
newExbond.ID = ID;
newExbond.BONDERID = exbond.BONDERID;
newExbond.DESCRIPTION = exbond.DESCRIPTION;
if (loggedinUser != null)
{
newExbond.MODIFIEDBY = loggedinUser.APPUSER.USERNAME;
}
newExbond.MODIFIEDDATE = DateTime.Today;
newExbond.CREATEDDATE = exbond.CREATEDDATE;
newExbond.CREATEDBY = exbond.CREATEDBY;
db2.Entry(newExbond).State = EntityState.Modified;
db2.SaveChanges();
}
lastInserted = ID;
}
for (int x = 0; x < b2bList.Count(); x++)
{
using (var db1 = new OracleEntitiesConnStr())
{
EXBONDBACKTOBACK exbondb2b = new EXBONDBACKTOBACK();
exbondb2b.BACKTOBACKID = b2bList[x].ID;
exbondb2b.EXBONDID = lastInserted;
db1.EXBONDBACKTOBACKs.Add(exbondb2b);
db1.SaveChanges();
}
}
// }
if (ID <= 0)
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Edit/" + ID));
}
}
}
private IQueryable <BACKTOBACKLC> GetBackToBackRolesBySearchCriterial(String LCNo, String FromDate, String ToDate, USERPERMISSION loggedinUser, int BONDERID)
{
var backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER);
if (!string.IsNullOrEmpty(LCNo))
{
LCNo = LCNo.Trim();
}
System.Diagnostics.Debug.WriteLine("LCNo = " + LCNo + ", FromDate = " + FromDate + ", ToDate = " + ToDate);
if ((LCNo != null && !LCNo.Equals(String.Empty)) && (FromDate != null && !FromDate.Equals(String.Empty)) && (ToDate != null && !ToDate.Equals(String.Empty)))
{
System.Diagnostics.Debug.WriteLine("else if 1");
DateTime fromLCDate = Convert.ToDateTime(FromDate);
DateTime toLCDate = Convert.ToDateTime(ToDate);
backtobacklcs = backtobacklcs.Where(b => b.LCNUMBER.Contains(LCNo) && (b.LCDATE >= fromLCDate && b.LCDATE <= toLCDate)).Include(b => b.BANKBRANCH).OrderByDescending(b => b.ID);
}
else if ((FromDate != null && !FromDate.Equals(String.Empty)) && (ToDate != null && !ToDate.Equals(String.Empty)))
{
System.Diagnostics.Debug.WriteLine("else if 2");
DateTime fromLCDate = Convert.ToDateTime(FromDate);
DateTime toLCDate = Convert.ToDateTime(ToDate);
backtobacklcs = backtobacklcs.Where(b => (b.LCDATE >= fromLCDate && b.LCDATE <= toLCDate)).Include(b => b.BANKBRANCH).OrderByDescending(b => b.ID);
}
else if (LCNo != null && !LCNo.Equals(String.Empty))
{
System.Diagnostics.Debug.WriteLine("else if 3");
backtobacklcs = backtobacklcs.Where(b => b.LCNUMBER.Contains(LCNo)).Include(b => b.BANKBRANCH).OrderByDescending(b => b.ID);
}
else if (FromDate != null && !FromDate.Equals(String.Empty))
{
System.Diagnostics.Debug.WriteLine("else if 4");
DateTime fromLCDate = Convert.ToDateTime(FromDate);
backtobacklcs = backtobacklcs.Where(b => b.LCDATE >= fromLCDate).OrderByDescending(b => b.ID);
}
else if (ToDate != null && !ToDate.Equals(String.Empty))
{
System.Diagnostics.Debug.WriteLine("else if 5");
DateTime toLCDate = Convert.ToDateTime(ToDate);
backtobacklcs = backtobacklcs.Where(b => b.LCDATE <= toLCDate).OrderByDescending(b => b.ID);
}
if (loggedinUser.BONDERID > 0)
{
backtobacklcs = backtobacklcs.Where(e => e.BONDERID == loggedinUser.BONDERID).OrderByDescending(b => b.ID);
}
else if (BONDERID > 0)
{
backtobacklcs = backtobacklcs.Where(e => e.BONDERID == BONDERID).OrderByDescending(b => b.ID);
}
return(backtobacklcs);
;
}
public ActionResult Create(BACKTOBACKLC backToBackLC)
{
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
if (loggedinUser != null)
{
backToBackLC.CREATEDBY = loggedinUser.APPUSER.USERNAME;
}
if (loggedinUser != null && loggedinUser.BONDERID != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", loggedinUser.BONDERID);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME");
}
foreach (var item in backToBackLC.BACKTOBACKPRODUCTs)
{
item.BACKTOBACKLCID = backToBackLC.ID;
}
DateTime thisDay = DateTime.Now;
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " ModelState.IsValid: " + ModelState.IsValid);
var errors = ModelState.Values.SelectMany(v => v.Errors);
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " errors: " + errors);
//if (ModelState.IsValid)
if (true)
{
try
{
if (backToBackLC.BACKTOBACKPRODUCTs != null && backToBackLC.BACKTOBACKPRODUCTs.Count > 0)
{
if (backToBackLC.BONDERID != null)
{
USERPERMISSION userpermission = sessionAttributeRetreival.getStoredUserPermission();
int bonderId = backToBackLC.BONDERID;
if (userpermission != null)
{
List <INBONDRAWMATERIAL> inbondRawMaterials = db.INBONDRAWMATERIALs.Where(inb => inb.INBOND.BONDERID == bonderId).ToList();
if (inbondRawMaterials != null)
{
decimal bonderUsedQuantity = inbondRawMaterials.Sum(item => item.PRODUCTQUANTITY);
decimal?bonderProvidedQuantity = backToBackLC.BACKTOBACKPRODUCTs.Sum(item => item.QUANTITY);
if (bonderUsedQuantity < bonderProvidedQuantity)
{
ModelState.AddModelError("", "Your Remaining Inbond Raw Material Quantity " + bonderUsedQuantity);
ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backToBackLC.BUYERSBANKBRANCHID);
ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backToBackLC.BUYERSBANKID);
if (userpermission != null && userpermission.BONDERID != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == userpermission.BONDERID), "BONDERSLNO", "BONDERNAME", userpermission.BONDERID);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backToBackLC.BONDERID);
}
ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.QUANTITYUNIT);
ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backToBackLC.PRICEUNIT);
for (int i = 0; i < backToBackLC.BACKTOBACKPRODUCTs.Count(); i++)
{
ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.BACKTOBACKPRODUCTs[i].QUANTITYUNIT);
}
return(View(backToBackLC));
}
}
}
}
BACKTOBACKLC newBacktobacklc = new BACKTOBACKLC();
newBacktobacklc.BUYERSNAME = backToBackLC.BUYERSNAME;
newBacktobacklc.BUYERSADDRESS = backToBackLC.BUYERSADDRESS;
newBacktobacklc.LCNUMBER = backToBackLC.LCNUMBER;
newBacktobacklc.LCDATE = backToBackLC.LCDATE;
newBacktobacklc.BUYERSBANKID = backToBackLC.BUYERSBANKID;
newBacktobacklc.BUYERSBANKBRANCHID = backToBackLC.BUYERSBANKBRANCHID;
newBacktobacklc.SHIPPINGDATE = backToBackLC.SHIPPINGDATE;
newBacktobacklc.CORRECTIONDATE = backToBackLC.CORRECTIONDATE;
newBacktobacklc.PRODUCTQUANTITY = backToBackLC.PRODUCTQUANTITY;
newBacktobacklc.QUANTITYUNIT = backToBackLC.QUANTITYUNIT;
newBacktobacklc.LCUSEDPRICE = backToBackLC.LCUSEDPRICE;
newBacktobacklc.PRICEUNIT = backToBackLC.PRICEUNIT;
newBacktobacklc.MASTERLCNUMBER = backToBackLC.MASTERLCNUMBER;
newBacktobacklc.MASTERLCCORRECTIONDATE = backToBackLC.MASTERLCCORRECTIONDATE;
newBacktobacklc.UDNUMBER = backToBackLC.UDNUMBER;
newBacktobacklc.UDDATE = backToBackLC.UDDATE;
newBacktobacklc.UDCORRECTIONDATE = backToBackLC.UDCORRECTIONDATE;
newBacktobacklc.UDPRODUCTDETAIL = backToBackLC.UDPRODUCTDETAIL;
newBacktobacklc.BONDERID = backToBackLC.BONDERID;
if (loggedinUser != null)
{
newBacktobacklc.CREATEDBY = loggedinUser.APPUSER.USERNAME;
}
newBacktobacklc.CREATEDDATE = thisDay;
db.BACKTOBACKLCs.Add(newBacktobacklc);
db.SaveChanges();
short lastBackToBackId = db.BACKTOBACKLCs.Max(item => item.ID);
foreach (var product in backToBackLC.BACKTOBACKPRODUCTs)
{
using (var dbBackToBackProduct = new OracleEntitiesConnStr())
{
BACKTOBACKPRODUCT newProduct = new BACKTOBACKPRODUCT();
newProduct.NAME = product.NAME;
newProduct.SIZEANDDETAIL = product.SIZEANDDETAIL;
newProduct.QUANTITY = product.QUANTITY;
newProduct.QUANTITYUNIT = product.QUANTITYUNIT;
newProduct.BACKTOBACKLCID = lastBackToBackId;
newProduct.CREATEDBY = backToBackLC.CREATEDBY;
newProduct.CREATEDDATE = thisDay;
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " BACKTOBACKPRODUCTs " + backToBackLC.BACKTOBACKPRODUCTs.Count());
dbBackToBackProduct.BACKTOBACKPRODUCTs.Add(newProduct);
dbBackToBackProduct.SaveChanges();
short lastProductId = db.BACKTOBACKPRODUCTs.Max(itemBack2Back => itemBack2Back.ID);
//System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " lastProductId = " + lastProductId);
foreach (var rawMaterial in product.RAWMATERIALs)
{
using (var dbRawMaterial = new OracleEntitiesConnStr())
{
RAWMATERIAL newRawMaterial = new RAWMATERIAL();
newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE;
newRawMaterial.QUANTITY = rawMaterial.QUANTITY;
newRawMaterial.UNIT = rawMaterial.UNIT;
newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE;
newRawMaterial.PRODUCTID = lastProductId;
newRawMaterial.CREATEDDATE = thisDay;
dbRawMaterial.RAWMATERIALs.Add(newRawMaterial);
dbRawMaterial.SaveChanges();
}
}
}
}
}
else
{
backToBackLC.CREATEDDATE = thisDay;
db.BACKTOBACKLCs.Add(backToBackLC);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult item in ex.EntityValidationErrors)
{
// Get entry
DbEntityEntry entry = item.Entry;
string entityTypeName = entry.Entity.GetType().Name;
// Display or log error messages
foreach (DbValidationError subItem in item.ValidationErrors)
{
string message = string.Format("Error '{0}' occurred in {1} at {2}", subItem.ErrorMessage, entityTypeName, subItem.PropertyName);
System.Diagnostics.Debug.WriteLine("Create(BACKTOBACKPRODUCTs): Time-" + thisDay + " Exception = " + message);
ViewBag.error = message;
}
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("Create(BACKTOBACKPRODUCTs): Time-" + thisDay + " Exception = " + e.StackTrace);
}
}
ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backToBackLC.BUYERSBANKBRANCHID);
ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backToBackLC.BUYERSBANKID);
ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.QUANTITYUNIT);
ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backToBackLC.PRICEUNIT);
for (int i = 0; i < backToBackLC.BACKTOBACKPRODUCTs.Count(); i++)
{
ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.BACKTOBACKPRODUCTs[i].QUANTITYUNIT);
}
return(View(backToBackLC));
}
public ActionResult Create(USERPERMISSION userpermission, string type = "")
{
if (ModelState.IsValid)
{
USERPERMISSION userpermissionFound = db.USERPERMISSIONs.SingleOrDefault(u => u.USERID == userpermission.USERID);
if (userpermissionFound != null)
{
if (userpermission.BONDERID != null)
{
if (userpermission.ROLENAME == "Bonder")
{
BONDER bonder = db.BONDERs.SingleOrDefault(u => u.BONDERSLNO == userpermission.BONDERID);
userpermission.BONDER = bonder;
}
else
{
userpermission.BONDERID = null;
}
}
else if (userpermission.EMPLOYID != null)
{
EMPLOYEE employee = db.EMPLOYEEs.SingleOrDefault(u => u.EMPLOYEESLNO == userpermission.EMPLOYID);
userpermission.EMPLOYEE = employee;
}
if (userpermissionFound.EMPLOYID == null && userpermission.EMPLOYID != null)
{
userpermission.BONDER = null;
userpermission.BONDERID = null;
}
if (userpermissionFound.BONDERID == null && userpermission.BONDERID != null)
{
userpermission.EMPLOYEE = null;
userpermission.EMPLOYID = null;
}
if (userpermission.USERID > 0)
{
APPUSER appuser = db.APPUSERs.SingleOrDefault(u => u.ID == userpermission.USERID);
userpermission.APPUSER = appuser;
userpermissionFound.APPUSER = appuser;
}
((IObjectContextAdapter)db).ObjectContext.Detach(userpermissionFound);
USERPERMISSION userpermissionFnd = db.USERPERMISSIONs.Find(userpermissionFound.ID);
db.USERPERMISSIONs.Remove(userpermissionFnd);
db.SaveChanges();
//db.Entry(userpermission).State = EntityState.Modified;
if (type.Equals("Operation Admin"))
{
userpermission.BONDER = null;
userpermission.BONDERID = null;
}
else if (type.Equals("Bonder"))
{
userpermission.EMPLOYEE = null;
userpermission.EMPLOYID = null;
}
db.USERPERMISSIONs.Add(userpermission);
db.SaveChanges();
}
else
{
if (type.Equals("Operation Admin"))
{
userpermission.BONDER = null;
userpermission.BONDERID = null;
}
else if (type.Equals("Bonder"))
{
userpermission.EMPLOYEE = null;
userpermission.EMPLOYID = null;
}
db.USERPERMISSIONs.Add(userpermission);
db.SaveChanges();
}
return(RedirectToAction("Index", "AppUser", null));
}
ViewBag.USERID = new SelectList(db.APPUSERs, "ID", "USERNAME", userpermission.USERID);
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", userpermission.BONDERID);
ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME", userpermission.EMPLOYID);
return(View(userpermission));
}
public ActionResult ProductAndRawMaterialStatus(int?BonderID, int?UPNO)
{
var requestType = this.HttpContext.Request.RequestType;
System.Diagnostics.Debug.WriteLine("requestType = " + requestType);
List <BonderProductRawMaterial> bonderProductRawMaterialList = null;
if ("GET" == requestType)
{
}
else if ("POST" == requestType)
{
if (null != BonderID && null != UPNO)
{
ViewBag.SearchBonderID = BonderID;
ViewBag.SearchUPNO = UPNO;
//Do the query based on parameters
bonderProductRawMaterialList = getBonderProductRawMaterialQueryData(UPNO);
if (null != bonderProductRawMaterialList && bonderProductRawMaterialList.Count == 0)
{
bonderProductRawMaterialList = null;
ViewBag.ErrorMsg = "No data found!!!! ";
}
}
else
{
ViewBag.ErrorMsg = "Please select Bonder and UP No!!!! ";
}
}
else
{
// Error handel
}
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
if (loggedinUser != null && loggedinUser.BONDERID != null)
{
ViewBag.BonderID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", loggedinUser.BONDERID);
}
else
{
ViewBag.BonderID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME");
}
if (null != UPNO)
{
ViewBag.UPNO = new SelectList(db.UPs.Where(b => b.BONDERID == BonderID), "ID", "UPNO", UPNO);
}
else
{
ViewBag.UPNO = new SelectList(db.UPs.Where(b => b.BONDERID == 0), "ID", "UPNO");
}
return(View(bonderProductRawMaterialList));
}
public ActionResult Edit(BACKTOBACKLC backtobacklc)
{
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
if (loggedinUser != null)
{
backtobacklc.MODIFIEDBY = loggedinUser.APPUSER.USERNAME;
}
if (loggedinUser != null && loggedinUser.BONDERID != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID);
}
foreach (var item in backtobacklc.BACKTOBACKPRODUCTs)
{
item.BACKTOBACKLCID = backtobacklc.ID;
}
DateTime thisDay = DateTime.Now;
bool isAddMore = false;
if (true)
{
try
{
if (backtobacklc.BACKTOBACKPRODUCTs != null && backtobacklc.BACKTOBACKPRODUCTs.Count > 0)
{
if (backtobacklc.BONDERID != null)
{
USERPERMISSION userpermission = sessionAttributeRetreival.getStoredUserPermission();
int bonderId = backtobacklc.BONDERID;
if (userpermission != null)
{
List <INBONDRAWMATERIAL> inbondRawMaterials = db.INBONDRAWMATERIALs.Where(inb => inb.INBOND.BONDERID == bonderId).ToList();
if (inbondRawMaterials != null)
{
decimal bonderUsedQuantity = inbondRawMaterials.Sum(item => item.PRODUCTQUANTITY);
decimal?bonderProvidedQuantity = backtobacklc.BACKTOBACKPRODUCTs.Sum(item => item.QUANTITY);
if (bonderUsedQuantity < bonderProvidedQuantity)
{
ModelState.AddModelError("", "Your Remaining Inbond Raw Material Quantity " + bonderUsedQuantity);
ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backtobacklc.BUYERSBANKBRANCHID);
ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backtobacklc.BUYERSBANKID);
if (userpermission != null && userpermission.BONDERID != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == userpermission.BONDERID), "BONDERSLNO", "BONDERNAME", userpermission.BONDERID);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID);
}
ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.QUANTITYUNIT);
ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backtobacklc.PRICEUNIT);
for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++)
{
ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.BACKTOBACKPRODUCTs[i].QUANTITYUNIT);
}
for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++)
{
return(RedirectToAction("Addmore", new { errorMessage = "Your Remaining Inbond Raw Material Quantity " + bonderUsedQuantity, id = backtobacklc.ID }));
}
return(View(backtobacklc));
}
}
}
}
System.Diagnostics.Debug.WriteLine("Edit(BACKTOBACKPRODUCTs): Time-" + thisDay + " BACKTOBACKPRODUCTs count = " + backtobacklc.BACKTOBACKPRODUCTs.Count);
foreach (var item in backtobacklc.BACKTOBACKPRODUCTs)
{
if (item.NAME != null)
{
System.Diagnostics.Debug.WriteLine("Edit(BACKTOBACKPRODUCTs): Time-" + thisDay + " item.ID = " + item.ID);
if (item.ID == 0)
{
using (var db1 = new OracleEntitiesConnStr())
{
BACKTOBACKPRODUCT newItem = new BACKTOBACKPRODUCT();
newItem.ID = item.ID;
newItem.BACKTOBACKLCID = item.BACKTOBACKLCID;
newItem.NAME = item.NAME;
newItem.QUANTITY = item.QUANTITY;
newItem.QUANTITYUNIT = item.QUANTITYUNIT;
newItem.CREATEDDATE = thisDay;
newItem.SIZEANDDETAIL = item.SIZEANDDETAIL;
newItem.ID = item.ID;
db1.BACKTOBACKPRODUCTs.Add(newItem);
db1.SaveChanges();
}
short lastProductId = db.BACKTOBACKPRODUCTs.Max(itemBack2Back => itemBack2Back.ID);
foreach (var rawMaterial in item.RAWMATERIALs)
{
using (var dbRawMaterial = new OracleEntitiesConnStr())
{
RAWMATERIAL newRawMaterial = new RAWMATERIAL();
newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE;
newRawMaterial.QUANTITY = rawMaterial.QUANTITY;
newRawMaterial.UNIT = rawMaterial.UNIT;
newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE;
newRawMaterial.PRODUCTID = lastProductId;
newRawMaterial.CREATEDDATE = thisDay;
dbRawMaterial.RAWMATERIALs.Add(newRawMaterial);
dbRawMaterial.SaveChanges();
}
}
}
if (item.ID > 0)
{
using (var db1 = new OracleEntitiesConnStr())
{
BACKTOBACKPRODUCT newItem = new BACKTOBACKPRODUCT();
newItem.ID = item.ID;
newItem.BACKTOBACKLCID = item.BACKTOBACKLCID;
newItem.NAME = item.NAME;
newItem.QUANTITY = item.QUANTITY;
newItem.QUANTITYUNIT = item.QUANTITYUNIT;
newItem.CREATEDDATE = thisDay;
newItem.SIZEANDDETAIL = item.SIZEANDDETAIL;
newItem.ID = item.ID;
db1.Entry(newItem).State = EntityState.Modified;
db1.SaveChanges();
}
foreach (var rawMaterial in item.RAWMATERIALs)
{
using (var dbRawMaterial = new OracleEntitiesConnStr())
{
RAWMATERIAL newRawMaterial = new RAWMATERIAL();
newRawMaterial.ID = rawMaterial.ID;
newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE;
newRawMaterial.QUANTITY = rawMaterial.QUANTITY;
newRawMaterial.UNIT = rawMaterial.UNIT;
newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE;
newRawMaterial.PRODUCTID = item.ID;
newRawMaterial.CREATEDDATE = thisDay;
dbRawMaterial.Entry(newRawMaterial).State = EntityState.Modified;
dbRawMaterial.SaveChanges();
}
}
}
}
}
BACKTOBACKLC newBacktobacklc = new BACKTOBACKLC();
newBacktobacklc.BUYERSNAME = backtobacklc.BUYERSNAME;
newBacktobacklc.BUYERSADDRESS = backtobacklc.BUYERSADDRESS;
newBacktobacklc.LCNUMBER = backtobacklc.LCNUMBER;
newBacktobacklc.LCDATE = backtobacklc.LCDATE;
newBacktobacklc.BUYERSBANKID = backtobacklc.BUYERSBANKID;
newBacktobacklc.BUYERSBANKBRANCHID = backtobacklc.BUYERSBANKBRANCHID;
newBacktobacklc.SHIPPINGDATE = backtobacklc.SHIPPINGDATE;
newBacktobacklc.CORRECTIONDATE = backtobacklc.CORRECTIONDATE;
newBacktobacklc.PRODUCTQUANTITY = backtobacklc.PRODUCTQUANTITY;
newBacktobacklc.QUANTITYUNIT = backtobacklc.QUANTITYUNIT;
newBacktobacklc.LCUSEDPRICE = backtobacklc.LCUSEDPRICE;
newBacktobacklc.PRICEUNIT = backtobacklc.PRICEUNIT;
newBacktobacklc.MASTERLCNUMBER = backtobacklc.MASTERLCNUMBER;
newBacktobacklc.MASTERLCCORRECTIONDATE = backtobacklc.MASTERLCCORRECTIONDATE;
newBacktobacklc.UDNUMBER = backtobacklc.UDNUMBER;
newBacktobacklc.UDDATE = backtobacklc.UDDATE;
newBacktobacklc.UDCORRECTIONDATE = backtobacklc.UDCORRECTIONDATE;
newBacktobacklc.UDPRODUCTDETAIL = backtobacklc.UDPRODUCTDETAIL;
newBacktobacklc.BONDERID = backtobacklc.BONDERID;
newBacktobacklc.CREATEDBY = backtobacklc.CREATEDBY;
newBacktobacklc.CREATEDDATE = backtobacklc.CREATEDDATE;
if (loggedinUser != null)
{
newBacktobacklc.MODIFIEDBY = loggedinUser.APPUSER.USERNAME;
}
newBacktobacklc.MODIFIEDDATE = thisDay;
newBacktobacklc.ID = backtobacklc.ID;
db.Entry(newBacktobacklc).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception e)
{
ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backtobacklc.BUYERSBANKBRANCHID);
ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backtobacklc.BUYERSBANKID);
ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.QUANTITYUNIT);
ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backtobacklc.PRICEUNIT);
for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++)
{
if (backtobacklc.BACKTOBACKPRODUCTs[i].ID <= 0)
{
isAddMore = true;
}
ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.BACKTOBACKPRODUCTs[i].QUANTITYUNIT);
}
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(c => c.ErrorMessage));
ViewBag.error = "all field values are required for product!";
if (isAddMore)
{
return(RedirectToAction("Addmore", new { errorMessage = message, id = backtobacklc.ID }));
}
return(Redirect(ControllerContext.HttpContext.Request.UrlReferrer.ToString()));
}
}
return(View(backtobacklc));
}
//public ActionResult Search()
//{
// return View("Index");
//}
//[HttpPost]
public ActionResult Search(string BondLicenseNo)
{
if (!(System.Web.HttpContext.Current.User.IsInRole("Bonder")))
{
var bonderslno = (from b in db.BONDERs where b.BONDLICENSENO == BondLicenseNo select b.BONDERSLNO).SingleOrDefault();
System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand();
System.Data.OracleClient.OracleConnection conn = ConnectBMS.Connection();
cmd.Connection = conn;
System.Data.OracleClient.OracleTransaction bmsTransaction = conn.BeginTransaction();
cmd.Transaction = bmsTransaction;
cmd.CommandText = "select STATUS,BSDATE,SUBMITTEDBYNM,REMARKS from BONDSTATUS where BONDERSLNO=:BONDERSLNO ";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("BONDERSLNO", bonderslno);
System.Data.OracleClient.OracleDataReader drBondStatus = cmd.ExecuteReader();
if (drBondStatus.HasRows)
{
drBondStatus.Read();
ViewBag.STATUS = drBondStatus.GetValue(0);
ViewBag.BSDATE = drBondStatus.GetValue(1);
ViewBag.SUBMITTEDBYNM = drBondStatus.GetValue(2);
ViewBag.REMARKS = drBondStatus.GetValue(3);
}
try
{
return(View(getRenewalInfo(bonderslno)));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
ViewBag.Message = "Insertion Failed";
return(View("RenewalForm"));
}
return(RedirectToAction("Index"));
}
else
{
USERPERMISSION permission = session.getStoredUserPermission();
var bonderName = permission.BONDER.BONDERNAME;
var bonderslno = (from b in db.BONDERs where b.BONDLICENSENO == BondLicenseNo && b.BONDERNAME == bonderName select b.BONDERSLNO).SingleOrDefault();
System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand();
System.Data.OracleClient.OracleConnection conn = ConnectBMS.Connection();
cmd.Connection = conn;
System.Data.OracleClient.OracleTransaction bmsTransaction = conn.BeginTransaction();
cmd.Transaction = bmsTransaction;
cmd.CommandText = "select STATUS,BSDATE,SUBMITTEDBYNM,REMARKS from BONDSTATUS where BONDERSLNO=:BONDERSLNO";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("BONDERSLNO", bonderslno);
System.Data.OracleClient.OracleDataReader drBondStatus = cmd.ExecuteReader();
if (drBondStatus.HasRows)
{
drBondStatus.Read();
ViewBag.STATUS = drBondStatus.GetValue(0);
ViewBag.BSDATE = drBondStatus.GetValue(1);
ViewBag.SUBMITTEDBYNM = drBondStatus.GetValue(2);
ViewBag.REMARKS = drBondStatus.GetValue(3);
}
try
{
return(View(getRenewalInfo(bonderslno)));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
ViewBag.Message = "Insertion Failed";
return(View("RenewalForm"));
}
return(RedirectToAction("Index"));
}
}
public ActionResult Index(int?page, int filterBonderId = 0, int BONDERID = 0)
{
if (TempData["Message"] != null)
{
ViewBag.Message = TempData["Message"].ToString();
TempData.Remove("Message");
}
int pageSize = recordNumbers;
int pageNumber = (page ?? 1);
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME");
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
var exbonds = db.EXBONDs.Include(e => e.BONDER).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID);
if (BONDERID == 0 && filterBonderId == 0 && !User.IsInRole("Bonder"))
{
List <EXBOND> exbond = new List <EXBOND>();
ViewBag.resultofbonderID = BONDERID;
return(View(exbond.ToList().ToPagedList(pageNumber, pageSize)));
}
if (BONDERID != 0)
{
page = 1;
}
else
{
if (BONDERID == 0)
{
BONDERID = filterBonderId;
}
}
ViewBag.filterBonderId = BONDERID;
if (loggedinUser.BONDERID > 0)
{
ViewBag.resultofbonderID = loggedinUser.BONDERID;
exbonds = db.EXBONDs.Include(e => e.BONDER).Where(e => e.BONDERID == loggedinUser.BONDERID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID);
}
else if (BONDERID > 0)
{
ViewBag.resultofbonderID = BONDERID;
exbonds = db.EXBONDs.Include(e => e.BONDER).Where(e => e.BONDERID == BONDERID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID);
}
ViewBag.lcNo = db.BACKTOBACKLCs.Include(e => e.ID);
ViewBag.userBonderId = loggedinUser.BONDERID;
if (BONDERID != 0)
{
if (loggedinUser.BONDERID > 0)
{
ViewBag.resultofbonderID = loggedinUser.BONDERID;
exbonds = db.EXBONDs.Include(e => e.BONDER).Where(e => e.BONDERID == loggedinUser.BONDERID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID);
}
else if (BONDERID > 0)
{
ViewBag.resultofbonderID = BONDERID;
exbonds = db.EXBONDs.Include(e => e.BONDER).Where(e => e.BONDERID == BONDERID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID);
}
}
return(View(exbonds.ToPagedList(pageNumber, pageSize)));
}
public ActionResult CreateOREditUP(IList <UPREQUEST> requests, string UPNO, short ID = 0)
{
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
IList <UPREQUEST> requestList = new List <UPREQUEST>();
UP up = new UP();
bool flag = true;
bool isanyselected = false;
if (UPNO == null || UPNO.Equals(""))
{
return(RedirectToAction("Create", new { error = "Please Provide UP NO" }));
}
else
{
UP duplicateUp = db.UPs.SingleOrDefault(u => u.UPNO.Equals(UPNO));
if (duplicateUp != null)
{
return(RedirectToAction("Create", new { error = "UP No Already Exists" }));
}
}
for (int i = 0; i < requests.Count(); i++)
{
int id = requests[i].ID;
if (requests[i].IsSelected)
{
isanyselected = true;
UPREQUEST request = db.UPREQUESTs.Find(id);
int productCount = request.UPEXBONDLISTs.Count();
if (productCount < 1)
{
flag = false;
}
else
{
requestList.Add(request);
up.BONDERID = request.BONDERID;
}
}
}
if (!isanyselected && ID <= 0)
{
return(RedirectToAction("Create", new { error = "Please select at least one exbond" }));
}
if (!flag && ID <= 0)
{
return(RedirectToAction("Create", new { error = "Sorry! please check all selected Requests has at least one exbond" }));
}
else
{
short lastInserted = 0;
if (ID <= 0)//add new UP
{
DateTime thisDay = DateTime.Today;
up.CREATEDDATE = thisDay;
if (loggedinUser != null)
{
up.CREATEDBY = loggedinUser.APPUSER.USERNAME;
}
up.UPNO = UPNO;
db.UPs.Add(up);
db.SaveChanges();
lastInserted = db.UPs.Max(item => item.ID);
}
else//Edit existing UP
{
if (loggedinUser != null)
{
up.MODIFIEDBY = loggedinUser.APPUSER.USERNAME;
}
up = db.UPs.Find(ID);
UP newUp = new UP();
newUp.ID = ID;
newUp.BONDERID = up.BONDERID;
newUp.UPNO = up.UPNO;
newUp.MODIFIEDDATE = DateTime.Today;
newUp.CREATEDDATE = up.CREATEDDATE;
newUp.CREATEDBY = up.CREATEDBY;
using (var db2 = new OracleEntitiesConnStr())
{
db2.Entry(newUp).State = EntityState.Modified;
db2.SaveChanges();
}
lastInserted = ID;
}
for (int x = 0; x < requestList.Count(); x++)
{
using (var db1 = new OracleEntitiesConnStr())//save value to relational table
{
UPREQUESTLIST uprequestList = new UPREQUESTLIST();
uprequestList.UPREQUESTID = requestList[x].ID;
uprequestList.UPID = lastInserted;
db1.UPREQUESTLISTs.Add(uprequestList);
db1.SaveChanges();
}
using (var db2 = new OracleEntitiesConnStr()) //change status of up request as approved
{
UPREQUEST request = new UPREQUEST(); // db.UPREQUESTs.Find(requestList[x].ID);
request.ID = requestList[x].ID;
request.BONDERID = requestList[x].BONDERID;
request.STATUS = 20; //approved
db2.Entry(request).State = EntityState.Modified;
db2.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
}
public ActionResult ApplicantsList()
{
if (!(System.Web.HttpContext.Current.User.IsInRole("Bonder"))) // added By Mizan (18 Aug 2016)--
{
var docatt = db.DOCUMENTATTACHMENTs.Where(x => x.BONDER.BONDSTATUS == "R").
GroupBy(x => new { x.BONDERSLNO, x.BONDER.BONDLICENSENO, x.BONDER.BONDERNAME }).
Select(x => new { x.Key.BONDERSLNO, x.Key.BONDLICENSENO, x.Key.BONDERNAME }).ToList();
List <BONDER> bonder = new List <BONDER>();
foreach (var item in docatt)
{
bonder.Add(
new BONDER
{
BONDERSLNO = item.BONDERSLNO,
BONDLICENSENO = item.BONDLICENSENO,
BONDERNAME = item.BONDERNAME
}
);
}
return(View(bonder));
}
else // added By Mizan (18 Aug 2016)--
{
USERPERMISSION permission = session.getStoredUserPermission();
var bonderName = permission.BONDER.BONDERNAME;
var docatt = db.DOCUMENTATTACHMENTs.Where(x => x.BONDER.BONDSTATUS == "R" && x.BONDER.BONDERNAME == bonderName).
GroupBy(x => new { x.BONDERSLNO, x.BONDER.BONDLICENSENO, x.BONDER.BONDERNAME }).
Select(x => new { x.Key.BONDERSLNO, x.Key.BONDLICENSENO, x.Key.BONDERNAME }).ToList();
List <BONDER> bonder = new List <BONDER>();
foreach (var item in docatt)
{
bonder.Add(
new BONDER
{
BONDERSLNO = item.BONDERSLNO,
BONDLICENSENO = item.BONDLICENSENO,
BONDERNAME = item.BONDERNAME
}
);
}
return(View(bonder));
}
//List<DOCUMENTATTACHMENT> documentattachment = new List<DOCUMENTATTACHMENT>();
//foreach (var item in docatt)
//{
// documentattachment.Add(
// new DOCUMENTATTACHMENT
// {
// BONDERSLNO = item.BONDERSLNO,
// DOCHEADINGNAMEBG = item.BONDLICENSENO,
// RGATTCHNAMEBG = item.BONDERNAME
// }
// );
//}
}
public ActionResult Create(int?page, int BONDERID = 0, int filterBonderId = 0)
{
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME");
ViewBag.error = Request.QueryString["error"];
ViewBag.ExbondID = (short)0;
ViewBag.userBonderId = loggedinUser.BONDERID;
var requestType = this.HttpContext.Request.RequestType;
var backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1);
int pageSize = recordNumbers;
int pageNumber = (page ?? 1);
if (loggedinUser.BONDERID > 0)
{
backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1 && b.BONDERID == loggedinUser.BONDERID);
}
if (BONDERID == 0 && filterBonderId == 0 && !User.IsInRole("Bonder"))
{
List <BACKTOBACKLC> lcs = new List <BACKTOBACKLC>();
ViewBag.resultofbonderID = BONDERID;
return(View("Lcselector", lcs.ToPagedList(pageNumber, pageSize)));
}
if (BONDERID != 0)
{
page = 1;
}
else
{
if (BONDERID == 0)
{
BONDERID = filterBonderId;
}
}
ViewBag.filterBonderId = BONDERID;
if (requestType == "GET")
{
if (BONDERID > 0)
{
backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1 && b.BONDERID == BONDERID);
ViewBag.resultofbonderID = BONDERID;
}
if (loggedinUser != null && loggedinUser.BONDERID != null)
{
ViewBag.resultofbonderID = loggedinUser.BONDERID;
backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1 && b.BONDERID == loggedinUser.BONDERID);
}
return(View("Lcselector", backtobacklcs.ToPagedList(pageNumber, pageSize)));
}
else if (requestType == "POST")
{
if (BONDERID > 0)
{
ViewBag.resultofbonderID = BONDERID;
backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1 && b.BONDERID == BONDERID);
}
}
if (loggedinUser != null && loggedinUser.BONDERID != null)
{
ViewBag.resultofbonderID = loggedinUser.BONDERID;
backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1 && b.BONDERID == loggedinUser.BONDERID);
}
return(View("Lcselector", backtobacklcs.ToPagedList(pageNumber, pageSize)));
}
