public ActionResult Edit([Bind(Include = "CASECODE,CASEDESC,MAPSFIX,STAMP")] CSCASE cSCASE)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCASE curRec = newdb.CSCASEs.Find(cSCASE.CASECODE);
if (curRec.STAMP == cSCASE.STAMP)
{
cSCASE.STAMP = cSCASE.STAMP + 1;
db.Entry(cSCASE).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
return(View(cSCASE));
}
public ActionResult Edit([Bind(Include = "CASECODE,FEEID,ITEMTYPE,ITEMDESC,ITEMSPEC,TAXRATE,ITEMAMT1,TAXAMT1,NETAMT1,ITEMAMT2,TAXAMT2,NETAMT2,ITEMAMT,TAXAMT,NETAMT,STAMP")] CSCASEFEE cSCASEFEE)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCASEFEE curRec = newdb.CSCASEFEEs.Find(cSCASEFEE.CASECODE, cSCASEFEE.FEEID);
if (curRec.STAMP == cSCASEFEE.STAMP)
{
cSCASEFEE.STAMP = cSCASEFEE.STAMP + 1;
db.Entry(cSCASEFEE).State = EntityState.Modified;
db.SaveChanges();
//return RedirectToAction("Index");
return(new RedirectResult(Url.Action("Details", "CSCASEs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCASEFEE.CASECODE) }) + "#CASEFEE"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
ViewBag.ITEMTYPE = new SelectList(db.CSITEMs, "ITEMTYPE", "ITEMDESC", cSCASEFEE.ITEMTYPE);
return(View(cSCASEFEE));
}
public ActionResult Edit([Bind(Include = "CONO,INCDATE,INCCTRY,CONSTCODE,INTYPE,PRINOBJ,PRINOBJStr,CONAME,PINDCODE,SINDCODE,WEB,COSTAT,COSTATD,FILETYPE,FILELOC,SEALLOC,STAFFCODE,SPECIALRE,SPECIALREBool,ARRE,ARREBool,CMMT,CMMTStr,REM,SXCODE,SXNAME,REFCODE,SEQNO,STAMP")] CSCOMSTR cSCOMSTR)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
db.Entry(cSCOMSTR).State = EntityState.Modified;
try
{
CSCOMSTR curRec = newdb.CSCOMSTRs.Find(cSCOMSTR.CONO);
if (curRec.STAMP == cSCOMSTR.STAMP)
{
cSCOMSTR.STAMP = cSCOMSTR.STAMP + 1;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
ViewBag.INCCTRY = new SelectList(db.HKCTRies, "CTRYCODE", "CTRYDESC", cSCOMSTR.INCCTRY);
ViewBag.CONSTCODE = new SelectList(db.HKCONSTs, "CONSTCODE", "CONSTDESC", cSCOMSTR.CONSTCODE);
ViewBag.STAFFCODE = new SelectList(db.HKSTAFFs, "STAFFCODE", "STAFFDESC", cSCOMSTR.STAFFCODE);
return(View(cSCOMSTR));
}
public ActionResult Edit([Bind(Include = "BILLNO,ENTDATE,CONO,JOBNO,CASENO,CASECODE,ITEMTYPE,ITEMDESC,ITEMSPEC,TAXRATE,ITEMAMT1,TAXAMT1,NETAMT1,ITEMAMT2,TAXAMT2,NETAMT2,ITEMAMT,TAXAMT,NETAMT,SYSGEN,PRFALLOC,SYSGENBool,PRFALLOCBool,PRFNO,PRFID,STAMP")] CSBILL cSBILL)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSBILL curRec = newdb.CSBILLs.Find(cSBILL.BILLNO);
if (curRec.STAMP == cSBILL.STAMP)
{
cSBILL.STAMP = cSBILL.STAMP + 1;
db.Entry(cSBILL).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
return(CallView(cSBILL));
}
public string DeleteRow(ASIDBConnection mydb, string id, int row)
{
CSCND cSCND = mydb.CSCNDs.Find(MyHtmlHelpers.ConvertByteStrToId(id), row);
CSTRANM cSTRANM = mydb.CSTRANMs.Find("CSCN", cSCND.TRNO, cSCND.TRID);
if (cSTRANM.REFCNT > 0)
{
throw new Exception("cannot delete record that has been applied");
}
mydb.CSTRANMs.Remove(cSTRANM);
mydb.CSCNDs.Remove(cSCND);
return(cSCND.TRNO);
}
public ActionResult Edit([Bind(Include = "CONO,AGMNO,LASTFYE,FYETOFILE,FILEDFYE,AGMLAST,AGMEXT,REMINDER1,REMINDER2,REMINDER3,AGMDATE,AGMFILED,REM,STAMP,CIRCDATE")] CSCOAGM cSCOAGM)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCOAGM curRec = newdb.CSCOAGMs.Find(cSCOAGM.CONO, cSCOAGM.AGMNO);
if (curRec.STAMP == cSCOAGM.STAMP)
{
cSCOAGM.STAMP = cSCOAGM.STAMP + 1;
db.Entry(cSCOAGM).State = EntityState.Modified;
if (cSCOAGM.FILEDFYE != null) // create next year record if AR is filed
{
string sid = cSCOAGM.CONO;
CSCOAGM lastRec = db.CSCOAGMs.Where(m => m.CONO == sid).OrderByDescending(n => n.AGMNO).FirstOrDefault();
if (cSCOAGM.AGMNO == lastRec.AGMNO) // add next year record only if editing the last record
{
CSCOAGM csRec = createNextYearRecord(cSCOAGM);
db.CSCOAGMs.Add(csRec);
}
}
db.SaveChanges();
//return RedirectToAction("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOAGM.CONO) });
return(new RedirectResult(Url.Action("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOAGM.CONO) }) + "#AGM"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
return(View(cSCOAGM));
}
public ActionResult Edit([Bind(Include = "CONO,SDATE,COSTAT,FILETYPE,FILELOC,SEALLOC,EDATE,ROWNO,STAMP")] CSCOSTAT cSCOSTAT)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCOSTAT curRec = newdb.CSCOSTATs.Find(cSCOSTAT.CONO, cSCOSTAT.ROWNO);
if (curRec.STAMP == cSCOSTAT.STAMP)
{
cSCOSTAT.STAMP = cSCOSTAT.STAMP + 1;
UpdatePreviousRow(cSCOSTAT);
db.Entry(cSCOSTAT).State = EntityState.Modified;
db.SaveChanges();
// return RedirectToAction("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) });
return(new RedirectResult(Url.Action("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) }) + "#Status"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
ViewBag.COSTAT = new SelectList(db.CSSTATs, "COSTAT", "COSTAT", cSCOSTAT.COSTAT);
return(View(cSCOSTAT));
}
public ActionResult Edit([Bind(Include = "TRNO,TRID,CASECODE,ITEMTYPE,ITEMDESC,ITEMSPEC,TAXRATE,ITEMAMT1,TAXAMT1,NETAMT1,ITEMAMT2,TAXAMT2,NETAMT2,ITEMAMT,TAXAMT,NETAMT,STAMP")] CSCND cSCND)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
db.Entry(cSCND).State = EntityState.Modified;
try
{
CSCNM parent = newdb.CSCNMs.Find(cSCND.TRNO);
if (parent != null)
{
CSCND curRec = newdb.CSCNDs.Find(cSCND.TRNO, cSCND.TRID);
if (curRec.STAMP == cSCND.STAMP)
{
cSCND.STAMP = cSCND.STAMP + 1;
CSTRANM cSTRANM = db.CSTRANMs.Find("CSCN", cSCND.TRNO, cSCND.TRID);
if (cSTRANM == null)
{
cSTRANM = new CSTRANM();
cSTRANM.STAMP = 0;
UpdateCSTRANM(parent, cSCND, cSTRANM);
db.CSTRANMs.Add(cSTRANM);
}
else
{
UpdateCSTRANM(parent, cSCND, cSTRANM);
db.Entry(cSTRANM).State = EntityState.Modified;
}
db.SaveChanges();
return(RedirectToAction("Edit", "CSCNMs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCND.TRNO) }));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
else
{
ModelState.AddModelError(string.Empty, "Parent Record is missing");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
ViewBag.CASECODE = new SelectList(db.CSCASEs, "CASECODE", "CASEDESC", cSCND.CASECODE);
ViewBag.ITEMTYPE = new SelectList(db.CSITEMs, "ITEMTYPE", "ITEMDESC", cSCND.ITEMTYPE);
return(View(cSCND));
}
public ActionResult Edit([Bind(Include = "CONO,ARNO,LASTAR,ARTOFILE,FILEDAR,REMINDER1,REM,STAMP,SUBMITAR")] CSCOAR cSCOAR)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCOAR curRec = newdb.CSCOARs.Find(cSCOAR.CONO, cSCOAR.ARNO);
if (curRec.STAMP == cSCOAR.STAMP)
{
cSCOAR.STAMP = cSCOAR.STAMP + 1;
db.Entry(cSCOAR).State = EntityState.Modified;
if (cSCOAR.FILEDAR != null) // create next year record if AR is filed
{
string sid = cSCOAR.CONO;
CSCOAR lastRec = db.CSCOARs.Where(m => m.CONO == sid).OrderByDescending(n => n.ARNO).FirstOrDefault();
if (cSCOAR.ARNO == lastRec.ARNO) // add next year record only if editing the last record
{
CSCOAR csRec = createNextYearRecord(cSCOAR);
db.CSCOARs.Add(csRec);
}
}
db.SaveChanges();
//return RedirectToAction("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOAR.CONO) });
return(new RedirectResult(Url.Action("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOAR.CONO) }) + "#Annual"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
cSCOAR.CSCOMSTR = db.CSCOMSTRs.Find(cSCOAR.CONO);
return(View(cSCOAR));
}
public ActionResult Edit([Bind(Include = "CASECODE,CASEDESC,MAPSFIX,STAMP")] CSCASE cSCASE)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCASE curRec = newdb.CSCASEs.Find(cSCASE.CASECODE);
if (curRec.STAMP == cSCASE.STAMP)
{
cSCASE.STAMP = cSCASE.STAMP + 1;
db.Entry(cSCASE).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
return(View(cSCASE));
}
public ActionResult Edit([Bind(Include = "BILLNO,ENTDATE,CONO,JOBNO,CASENO,CASECODE,ITEMTYPE,ITEMDESC,ITEMSPEC,TAXCODE,TAXRATE,ITEMAMT1,TAXAMT1,NETAMT1,ITEMAMT2,TAXAMT2,NETAMT2,ITEMAMT,TAXAMT,NETAMT,SYSGEN,PRFALLOC,SYSGENBool,PRFALLOCBool,PRFNO,PRFID,STAMP")] CSBILL cSBILL)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSBILL curRec = newdb.CSBILLs.Find(cSBILL.BILLNO);
if (curRec.STAMP == cSBILL.STAMP)
{
cSBILL.STAMP = cSBILL.STAMP + 1;
db.Entry(cSBILL).State = EntityState.Modified;
db.SaveChanges();
int page = (int)Session["CSBillPage"];
return(RedirectToAction("Index", new { page = page }));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
return(CallView(cSBILL));
}
public PartialViewResult AddItem(string id, string prfno)
{
string sid = MyHtmlHelpers.ConvertByteStrToId(id);
CSBILL cSBILL = db.CSBILLs.Find(sid);
CSPRF cSPRF = db.CSPRFs.Find(prfno);
if (cSBILL.PRFALLOC == "Y")
{
Response.StatusCode = (int)HttpStatusCode.NotAcceptable;
Response.StatusDescription = "Bill has been Allocated";
}
else
if (cSBILL.refcnt > 0)
{
Response.StatusCode = (int)HttpStatusCode.NotAcceptable;
Response.StatusDescription = "Bill has been touched";
//throw new Exception("Bill has been touched");
}
else
{
int prfId = 0;
string prfnoId = MyHtmlHelpers.ConvertIdToByteStr(prfno);
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSBILL curRec = newdb.CSBILLs.Find(sid);
var cSTRANMs = db.CSTRANMs.Where(x => x.SOURCE == "CSPRF" && x.SOURCENO == prfno);
prfId = 0;
if (cSTRANMs.Count() != 0)
{
prfId = cSTRANMs.Max(y => y.SOURCEID);
}
prfId++;
if (curRec.STAMP == cSBILL.STAMP)
{
cSBILL.STAMP = cSBILL.STAMP + 1;
cSBILL.PRFALLOC = "Y";
cSBILL.PRFNO = prfno;
cSBILL.PRFID = prfId;
db.Entry(cSBILL).State = EntityState.Modified;
CSTRANM cSTRANM = new CSTRANM();
cSTRANM.STAMP = 0;
UpdateCSTRANM(cSPRF, cSBILL, cSTRANM);
db.CSTRANMs.Add(cSTRANM);
db.SaveChanges();
}
else
{
Response.StatusCode = (int)HttpStatusCode.NotAcceptable;
Response.StatusDescription = "bill was modified";
throw new Exception("bill was modified");
}
}
catch (Exception e)
{
Response.StatusCode = (int)HttpStatusCode.NotAcceptable;
Response.StatusDescription = e.Message;
}
finally
{
newdb.Dispose();
}
}
return(BillOpen(MyHtmlHelpers.ConvertIdToByteStr(cSPRF.CONO), MyHtmlHelpers.ConvertIdToByteStr(prfno)));
//return RedirectToAction("Edit/" + prfnoId);
}
public PartialViewResult RemoveItem(string id)
{
string sid = MyHtmlHelpers.ConvertByteStrToId(id);
CSBILL cSBILL = db.CSBILLs.Find(sid);
string prfno = cSBILL.PRFNO;
int? prfId = cSBILL.PRFID;
string prfnoId = MyHtmlHelpers.ConvertIdToByteStr(prfno);
if (cSBILL == null)
{
Response.StatusCode = (int)HttpStatusCode.NotAcceptable;
Response.StatusDescription = "Bill Item is missing";
}
else if (cSBILL.PRFALLOC == "N")
{
Response.StatusCode = (int)HttpStatusCode.NotAcceptable;
Response.StatusDescription = "Bill has been Allocated";
}
else if (cSBILL.refcnt > 0)
{
Response.StatusCode = (int)HttpStatusCode.NotAcceptable;
Response.StatusDescription = "Bill has been touched";
//throw new Exception("Bill has been touched");
}
else
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSBILL curRec = newdb.CSBILLs.Find(sid);
if (curRec.STAMP == cSBILL.STAMP)
{
cSBILL.STAMP = cSBILL.STAMP + 1;
cSBILL.PRFALLOC = "N";
cSBILL.PRFNO = null;
cSBILL.PRFID = null;
db.Entry(cSBILL).State = EntityState.Modified;
CSTRANM cSTRANM = db.CSTRANMs.Find("CSPRF", prfno, prfId);
db.CSTRANMs.Remove(cSTRANM);
db.SaveChanges();
}
else
{
Response.StatusCode = (int)HttpStatusCode.NotAcceptable;
Response.StatusDescription = "bill was modified";
throw new Exception("bill was modified");
}
}
catch (Exception e)
{
Response.StatusCode = (int)HttpStatusCode.NotAcceptable;
Response.StatusDescription = e.Message;
}
finally
{
newdb.Dispose();
}
}
//return RedirectToAction("Edit/" + prfnoId);
return(BillAllocated(MyHtmlHelpers.ConvertIdToByteStr(prfno)));
}
public ActionResult Edit1([Bind(Include = "CONO,SDATE,COSTAT,FILETYPE,FILELOC,SEALLOC,EDATE,ROWNO,STAMP")] CSCOSTAT cSCOSTAT)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
string oldKey = (string)Session["CSCOSTAT_OLDCONO"];
CSCOSTAT curRec = db.CSCOSTATs.Find(oldKey, cSCOSTAT.ROWNO); //allowing for key change
if (curRec.STAMP == cSCOSTAT.STAMP)
{
cSCOSTAT.STAMP = cSCOSTAT.STAMP + 1;
if (oldKey != cSCOSTAT.CONO)
{
curRec.SDATE = new DateTime(3000, 1, 2); // make sure the old previous row date gets reversed
UpdatePreviousRow(curRec);
db.CSCOSTATs.Remove(curRec);
int lastRowNo = 0;
try
{
lastRowNo = db.CSCOSTATs.Where(m => m.CONO == cSCOSTAT.CONO).Max(n => n.ROWNO);
}
catch (Exception e) { lastRowNo = -1; }
finally { };
cSCOSTAT.ROWNO = lastRowNo + 1;
db.CSCOSTATs.Add(cSCOSTAT);
}
else
{
db.Entry(cSCOSTAT).State = EntityState.Modified;
}
if (db.CSCOSTATs.Where(x => x.CONO == cSCOSTAT.CONO).OrderByDescending(x => x.ROWNO).Select(x => x.ROWNO).FirstOrDefault() == cSCOSTAT.ROWNO)
{
UpdateCompany(cSCOSTAT);
}
UpdatePreviousRow(cSCOSTAT); // will always do this for the current record
db.SaveChanges();
// return RedirectToAction("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) });
//return new RedirectResult(Url.Action("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) }) + "#Status");
int page = (int)Session["CSCOSTATPage"];
return(RedirectToAction("Index", new { page = page }));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
ViewBag.CONO = new SelectList(db.CSCOMSTRs.Select(x => new { CONO = x.CONO, CONAME = x.CONAME + " (" + x.CONO + ")" }).OrderBy(y => y.CONAME), "CONO", "CONAME", cSCOSTAT.CONO);
ViewBag.COSTAT = new SelectList(db.CSSTATs, "COSTAT", "COSTAT", cSCOSTAT.COSTAT);
cSCOSTAT.CSCOMSTR = db.CSCOMSTRs.Find(cSCOSTAT.CONO);
return(View(cSCOSTAT));
}
public ActionResult Edit([Bind(Include = "CONO,SDATE,COSTAT,FILETYPE,FILELOC,SEALLOC,EDATE,ROWNO,STAMP")] CSCOSTAT cSCOSTAT)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCOSTAT curRec = newdb.CSCOSTATs.Find(cSCOSTAT.CONO, cSCOSTAT.ROWNO);
if (curRec.STAMP == cSCOSTAT.STAMP)
{
cSCOSTAT.STAMP = cSCOSTAT.STAMP + 1;
// only update the latest record
if (db.CSCOSTATs.Where(x => x.CONO == cSCOSTAT.CONO).OrderByDescending(x => x.ROWNO).Select(x => x.ROWNO).FirstOrDefault() == cSCOSTAT.ROWNO)
{
UpdateCompany(cSCOSTAT);
}
UpdatePreviousRow(cSCOSTAT);
db.Entry(cSCOSTAT).State = EntityState.Modified;
db.SaveChanges();
// return RedirectToAction("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) });
return(new RedirectResult(Url.Action("Edit", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) }) + "#Status"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
ViewBag.COSTAT = new SelectList(db.CSSTATs, "COSTAT", "COSTAT", cSCOSTAT.COSTAT);
cSCOSTAT.CSCOMSTR = db.CSCOMSTRs.Find(cSCOSTAT.CONO);
return(View(cSCOSTAT));
}
public ActionResult Edit([Bind(Include = "TRNO,VDATE,CONO,COADDRID,ATTN,REM,SEQNO,POSTBool,STAMP")] CSCNM cSCNM)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCNM curRec = newdb.CSCNMs.Find(cSCNM.TRNO);
if (curRec.STAMP == cSCNM.STAMP)
{
cSCNM.STAMP = cSCNM.STAMP + 1;
db.Entry(cSCNM).State = EntityState.Modified;
db.SaveChanges();
int page = (int)Session["CSCNMPage"];
return(RedirectToAction("Index", new { page = page }));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
ViewBag.CSCND = db.CSCNDs.Where(x => x.TRNO == cSCNM.TRNO);
ViewBag.CONAME = db.CSCOMSTRs.Where(x => x.CONO == cSCNM.CONO).Select(y => y.CONAME).FirstOrDefault();
ViewBag.CONO = new SelectList(db.CSCOMSTRs.Select(x => new { CONO = x.CONO, CONAME = x.CONAME + " (" + x.CONO + ")" }).OrderBy(y => y.CONAME), "CONO", "CONAME", cSCNM.CONO);
ViewBag.ATTNDESC = new SelectList(db.CSCOPICs.Where(x => x.CONO == cSCNM.CONO).Select(x => new { PRSNAME = x.CSPR.PRSNAME, PRSDESC = x.CSPR.PRSNAME }).OrderBy(y => y.PRSDESC), "PRSNAME", "PRSDESC", cSCNM.ATTN);
ViewBag.COADDR = new SelectList(db.CSCOADDRs.Where(x => x.CONO == cSCNM.CONO).Select(x => new { COADDR = x.CONO + "|" + x.ADDRID, COADDRDESC = x.ADDRTYPE + " | " + x.MAILADDR + " | " + x.ADDR1 + " " + x.ADDR2 + " " + x.ADDR3 }), "COADDR", "COADDRDESC", cSCNM.COADDR);
ViewBag.Title = "Edit Discounted Bill";
return(View("Edit", cSCNM));
}
public ActionResult Edit([Bind(Include = "CASECODE,FEEID,ITEMTYPE,ITEMDESC,ITEMSPEC,TAXRATE,ITEMAMT1,TAXAMT1,NETAMT1,ITEMAMT2,TAXAMT2,NETAMT2,ITEMAMT,TAXAMT,NETAMT,STAMP")] CSCASEFEE cSCASEFEE)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCASEFEE curRec = newdb.CSCASEFEEs.Find(cSCASEFEE.CASECODE, cSCASEFEE.FEEID);
if (curRec.STAMP == cSCASEFEE.STAMP)
{
cSCASEFEE.STAMP = cSCASEFEE.STAMP + 1;
db.Entry(cSCASEFEE).State = EntityState.Modified;
db.SaveChanges();
//return RedirectToAction("Index");
return(new RedirectResult(Url.Action("Details", "CSCASEs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCASEFEE.CASECODE) }) + "#CASEFEE"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
ViewBag.ITEMTYPE = new SelectList(db.CSITEMs, "ITEMTYPE", "ITEMDESC", cSCASEFEE.ITEMTYPE);
return(View(cSCASEFEE));
}
