/// <summary>
/// Return Affected Row Or Error If Exist
/// </summary>
/// <param name="request">CellarArea Information</param>
/// <returns>Affected Row Or Error If Exist</returns>
public static GetCellarAreaResponse CellarArea(GetCellarAreaResponse request)
{
GetCellarAreaResponse response = new GetCellarAreaResponse();
response.Error = new Handler.ErrorObject();
try
{
tblCellarArea CellarArea = new tblCellarArea()
{
id = request.CellarArea.id,
name = request.CellarArea.name,
detail = request.CellarArea.detail,
createDate = request.CellarArea.createDate,
upDateDate = DateTime.Now,
deleteDate = null,
state = "Active"
};
var result = CellarAreaData.Update.CellarArea(CellarArea);
if (result.Item1.Error)
{
response.Error.InfoError(result.Item1);
}
else
{
response.Message = result.Item2;
}
}
catch (Exception ex)
{
response.Error.InfoError(ex);
}
return(response);
}
/// <summary>
/// Return CellarArea Information
/// </summary>
/// <param name="request">Cellar Area ID</param>
/// <returns>Department Information</returns>
public static GetCellarAreaResponse GetCellarArea(GetCellarAreaRequest request)
{
GetCellarAreaResponse response = new GetCellarAreaResponse();
response.Error = new Handler.ErrorObject();
response.CellarArea = new CellarArea();
try
{
var GetCellarArea = CellarAreaData.Select.GetCellarArea(request.CellarAreaID);
if (!GetCellarArea.Item1.Error)
{
response.CellarArea = new CellarArea()
{
id = GetCellarArea.Item2.id,
name = GetCellarArea.Item2.name,
detail = GetCellarArea.Item2.detail,
createDate = GetCellarArea.Item2.createDate,
upDateDate = GetCellarArea.Item2.upDateDate,
deleteDate = GetCellarArea.Item2.deleteDate,
state = GetCellarArea.Item2.state
};
}
else
{
response.Error.InfoError(GetCellarArea.Item1);
}
}
catch (Exception ex)
{
response.Error.InfoError(ex);
}
return(response);
}
/// <summary>
/// Return Cellar Area Name
/// </summary>
/// <param name="request">CellarAreaID</param>
/// <returns>Cellar Area Name</returns>
public static GetCellarAreaResponse GetCellarAreaName(int request)
{
GetCellarAreaResponse response = new GetCellarAreaResponse();
response.Error = new Handler.ErrorObject();
response.CellarArea = new CellarArea();
try
{
var GetCellarArea = CellarAreaData.Select.GetCellarAreaName(request);
if (!GetCellarArea.Item1.Error)
{
response.CellarArea = new CellarArea()
{
name = GetCellarArea.Item2.name
};
}
else
{
response.Error.InfoError(GetCellarArea.Item1);
}
}
catch (Exception ex)
{
response.Error.InfoError(ex);
}
return(response);
}
/// <summary>
/// Return Affected Row Or Error If Exist
/// </summary>
/// <param name="CellarAreaID">Cellar Area ID</param>
/// <param name="state">State</param>
/// <returns>Affected Row Or Error If Exist</returns>
public static GetCellarAreaResponse CellarAreaDisable(int CellarAreaID, string state)
{
GetCellarAreaResponse response = new GetCellarAreaResponse();
try
{
var result = CellarAreaData.Delete.CellarAreaDisable(CellarAreaID, state);
if (result.Item1.Error)
{
response.Error.InfoError(result.Item1);
}
else
{
response.Message = result.Item2;
}
}
catch (Exception ex)
{
response.Error.InfoError(ex);
}
return(response);
}
/// <summary>
/// Return Cellar Area List
/// </summary>
/// <returns>Cellar Area List</returns>
public static GetCellarAreaResponse GetCellarAreaList()
{
GetCellarAreaResponse response = new GetCellarAreaResponse();
response.CellarAreaList = new List <CellarArea>();
response.Error = new Handler.ErrorObject();
try
{
var GetCellarArea = CellarAreaData.Select.GetCellarArea();
if (!GetCellarArea.Item1.Error)
{
foreach (var item in GetCellarArea.Item2)
{
response.CellarAreaList.Add(new CellarArea()
{
id = item.id,
name = item.name,
detail = item.detail,
createDate = item.createDate,
upDateDate = item.upDateDate,
deleteDate = item.deleteDate,
state = item.state
});
}
}
else
{
response.Error.InfoError(GetCellarArea.Item1);
}
}
catch (Exception ex)
{
response.Error.InfoError(ex);
}
return(response);
}
