public mWarehouseBuilding GetWareBuildingByID(long buildingID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
mWarehouseBuilding building = new mWarehouseBuilding();
building = (from p in ce.mWarehouseBuildings
where p.ID == buildingID
select p).FirstOrDefault();
return(building);
}
protected void GetBuildingByID()
{
CustomProfile profile = CustomProfile.GetProfile();
iWarehouseClient Warehouseclient = new iWarehouseClient();
try
{
mWarehouseBuilding warebuilding = new mWarehouseBuilding();
warebuilding = Warehouseclient.GetWareBuildingByID(long.Parse(hdnbuilding.Value), profile.DBConnection._constr);
if (warebuilding.Name != null)
{
txtbuildname.Text = warebuilding.Name.ToString();
}
if (warebuilding.SortCode != null)
{
txtsortcode.Text = warebuilding.SortCode.ToString();
}
if (warebuilding.Capacity != null)
{
txtcapacity.Text = warebuilding.Capacity.ToString();
}
if (warebuilding.Description != null)
{
txtdescription.Text = warebuilding.Description.ToString();
}
if (warebuilding.CustomerID != null)
{
hdncustomerID.Value = warebuilding.CustomerID.ToString();
}
hdnCompanyID.Value = warebuilding.CompanyID.ToString();
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, this, "AddEditSearchContact", "GetContactDetailByContactID");
}
finally
{
Warehouseclient.Close();
}
}
public static string WMSaveRequestHead(object objCon, string State)
{
string result = "";
CustomProfile profile = CustomProfile.GetProfile();
iWarehouseClient Warehouseclient = new iWarehouseClient();
mWarehouseBuilding building = new mWarehouseBuilding();
try
{
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary = (Dictionary <string, object>)objCon;
building.Name = dictionary["Name"].ToString();
building.SortCode = dictionary["SortCode"].ToString();
building.Capacity = decimal.Parse(dictionary["Capacity"].ToString());
building.Description = dictionary["description"].ToString();
building.CompanyID = long.Parse(dictionary["CompanyId"].ToString());
building.CustomerID = long.Parse(dictionary["CustomerID"].ToString());
building.WarehouseID = long.Parse(dictionary["WarehouseID"].ToString());
if (State == "Edit")
{
building.ID = Convert.ToInt64(HttpContext.Current.Session["BuildingID"].ToString());
long BuildID = Warehouseclient.SaveWareBuilding(building, profile.DBConnection._constr);
}
else
{
building.CreatedBy = profile.Personal.UserID;
building.CreationDate = DateTime.Now;
long BuildID = Warehouseclient.SaveWareBuilding(building, profile.DBConnection._constr);
}
result = "Building saved successfully";
}
catch { result = "Some error occurred"; }
finally { Warehouseclient.Close(); }
return(result);
}
public long SaveWareBuilding(mWarehouseBuilding WBuilding, string[] conn)
{
try
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
if (WBuilding.ID == 0)
{
db.mWarehouseBuildings.AddObject(WBuilding);
db.SaveChanges();
}
else
{
db.mWarehouseBuildings.Attach(WBuilding);
db.ObjectStateManager.ChangeObjectState(WBuilding, EntityState.Modified);
db.SaveChanges();
}
return(WBuilding.ID);
}
catch
{
return(0);
}
}
