public CmnItemSize GetItemSizeById(int id)
{
CmnItemSize objItemSize = null;
try
{
objItemSize = objItemSizeService.GetItemSizeById(id).FirstOrDefault();
}
catch (Exception e)
{
e.ToString();
}
return(objItemSize);
}
public HttpResponseMessage SaveUpdateItemSize(CmnItemSize model)
{
int result = 0;
try
{
if (ModelState.IsValid)
{
result = objItemSizeService.SaveUpdateItemSize(model);
}
}
catch (Exception e)
{
e.ToString();
result = -0;
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
/// Static CompanyID Provided
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through ORM</para>
/// </summary>
public int SaveUpdateItemSize(CmnItemSize model)
{
GenericFactory_EF_ItemSize = new CmnItemSize_EF();
int result = 0;
if (model.SizeID > 0)
{
try
{
if (model.IsDeleted == false)
{
model.StatusID = 1;
model.CompanyID = 1;
model.UpdateBy = 1;
model.UpdateOn = DateTime.Today;
model.UpdatePc = HostService.GetIP();
GenericFactory_EF_ItemSize.Update(model);
GenericFactory_EF_ItemSize.Save();
}
else
{
model.StatusID = 1;
model.CompanyID = 1;
model.DeleteBy = 1;
model.DeleteOn = DateTime.Today;
//model.DeletePc = HostService.GetIP();
GenericFactory_EF_ItemSize.Update(model);
GenericFactory_EF_ItemSize.Save();
}
result = 1;
}
catch (Exception e)
{
e.ToString();
result = 0;
}
}
else
{
//long NextId = GenericFactory_EF_ItemSize.getMaxVal_int("SizeID", "CmnItemSize");
string strTblName = model.ToString().Substring(model.ToString().LastIndexOf(".") + 1);
object[] parameters = { strTblName };
string spName = "[SPMaxRowID]";
//long NextId = GenericFactory_EF_Color.getMaxValBySp_string("SPMaxRowID", strTblName);
long NextId = GenericFactory_EF_ItemSize.getMaxValBySp(spName, parameters);
try
{
model.SizeID = Convert.ToInt32(NextId);
model.StatusID = 1;
model.CompanyID = 1;
model.CreateBy = 1;
model.CreateOn = DateTime.Today;
model.CreatePc = HostService.GetIP();
GenericFactory_EF_ItemSize.Insert(model);
GenericFactory_EF_ItemSize.Save();
result = 1;
}
catch (Exception e)
{
e.ToString();
result = 0;
}
}
return(result);
}
