public ActionResult SearchCard(string searchCardNo , string searchToCardNo , DateTime?searchBeginDate , DateTime?searchEndDate) { var context = new DLSMEntities(); int Userid = Convert.ToInt32(Session["UserID"]); List <StockSerial> list = new List <StockSerial>(); //change store to get only stock serial var listdata = context.sp_SearchCard(Convert.ToString(searchCardNo), Convert.ToString(searchToCardNo), searchBeginDate, searchEndDate).ToList().OrderBy(a => a.SerialBegin); int sarch_card_limit = 500; if (listdata.Count() > 0) { //using loop from stock serial begin to end foreach (var i in listdata) { string sbegin = i.SerialBegin; UInt64 card_serialno = Convert.ToUInt64(sbegin); for (int n = 0; n < i.SerialCount; n++) { StockSerial s = new StockSerial(); s.PdID = n + 1; s.SerialBegin = card_serialno.ToString(); s.WhID = i.whid; list.Add(s); card_serialno++; //check item not over limit if (n > sarch_card_limit) { break; } } } } return(View("Index", list)); }
public ActionResult InsertFailCard(StockSerial model) { var context = new DLSMEntities(); var UserID = Session["UserID"].ToString(); model.CardList.RemoveAt(0); foreach (var a in model.CardList) { StockSerial SS = new StockSerial(); SS.ID = a.ID; SS.WhID = a.WhID; SS.SerialBegin = a.CardSerial; SS.Name = a.CardDate; SS.IpProperty = a.Remark; SaveCardResponse ap = new SaveCardResponse(); using (DLSMEntities db = new DLSMEntities()) { db.Database.Connection.Open(); using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var result = context.sp_SaveCardManual("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", Convert.ToString(SS.WhID), UserID, "", "", SS.SerialBegin, "", Convert.ToDateTime(SS.Name), SS.IpProperty).ToList(); if (result[0].seqno > 0) { db.SaveChanges(); dbContextTransaction.Commit(); ap.resultCode = "1"; ap.cardEIN = SS.SerialBegin; ap.message = "OK"; } else { if (db.Database.Connection != null) { try { dbContextTransaction.Rollback(); } catch { } } ap.cardEIN = SS.SerialBegin; ap.resultCode = "0"; ap.message = "not found"; } //dbContextTransaction.Rollback(); } catch (Exception ex) { if (db.Database.Connection != null) { try { dbContextTransaction.Rollback(); return(Json("ERROR : " + ex.ToString())); } catch { } } ap.cardEIN = SS.SerialBegin; ap.resultCode = "0"; if (ex.InnerException != null) { ap.message = ex.InnerException.Message; if (ex.InnerException.StackTrace != null) { ap.message += " + InnerException.StackTrace: " + ex.InnerException.StackTrace; } } if (ex.Message != null) { ap.message += "+" + ex.Message; if (ex.StackTrace != null) { ap.message += " + StackTrace: " + ex.StackTrace; } } if (ex.InnerException == null && ex.Message == null) { ap.message = "Error: SaveCard catch 2"; } ap.message += " (Step 2)"; //ap.message = ex.InnerException == null ? (ex.Message == null ? "Error: SaveCard catch 2" : ex.Message) : ex.InnerException.Message + " StackTrace:" + ex.StackTrace; } } } //string json = new JavaScriptSerializer().Serialize(ap); //context.Response.ContentType = "text/javascript"; //context.Response.Write(json); } return(Json("success")); }