public mShelf GetWarehouseShelfByID(long ShelfID, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mShelf shelf = new mShelf(); shelf = (from p in ce.mShelves where p.ID == ShelfID select p).FirstOrDefault(); return(shelf); }
public static string WMSaveRequestHead(object objCon, string State) { string result = ""; CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); mShelf shelf = new mShelf(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objCon; shelf.Name = dictionary["Name"].ToString(); shelf.SortCode = long.Parse(dictionary["SortCode"].ToString()); shelf.Description = dictionary["description"].ToString(); shelf.CompanyID = long.Parse(dictionary["CompanyId"].ToString()); shelf.CustomerID = long.Parse(dictionary["CustomerID"].ToString()); shelf.SectionID = long.Parse(dictionary["hdnsectionID"].ToString()); if (State == "Edit") { shelf.ID = Convert.ToInt64(HttpContext.Current.Session["Shelf"].ToString()); shelf.CreatedBy = profile.Personal.UserID; shelf.CreationDate = DateTime.Now; long FloarID = Warehouseclient.SaveWarehouseShelf(shelf, profile.DBConnection._constr); } else { shelf.CreatedBy = profile.Personal.UserID; shelf.CreationDate = DateTime.Now; long FloarID = Warehouseclient.SaveWarehouseShelf(shelf, profile.DBConnection._constr); } result = "Shelf saved successfully"; } catch { result = "Some error occurred"; } finally { Warehouseclient.Close(); } return(result); }
public long SaveWarehouseShelf(mShelf wshelf, string[] conn) { try { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); if (wshelf.ID == 0) { db.mShelves.AddObject(wshelf); db.SaveChanges(); } else { db.mShelves.Attach(wshelf); db.ObjectStateManager.ChangeObjectState(wshelf, EntityState.Modified); db.SaveChanges(); } return(wshelf.ID); } catch { return(0); } }
protected void GetWarehouseShelfByID() { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); try { mShelf shelf = new mShelf(); shelf = Warehouseclient.GetWarehouseShelfByID(long.Parse(hdnshelfID.Value), profile.DBConnection._constr); if (shelf.Name != null) { txtshelf.Text = shelf.Name.ToString(); } if (shelf.SortCode != null) { txtsortcode.Text = shelf.SortCode.ToString(); } if (shelf.Description != null) { txtdescription.Text = shelf.Description.ToString(); } if (shelf.CustomerID != null) { hdncustomerID.Value = shelf.CustomerID.ToString(); } hdnCompanyID.Value = shelf.CompanyID.ToString(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "WarehousePassage", "GetWarehouseShelfByID"); } finally { Warehouseclient.Close(); } }