/// <summary>
/// Insert Assignment Information
/// </summary>
/// <param name="data">Assignment Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, int> Download(tblDownloadAssignment data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
int propertyFind = db.tblDownloadAssignment.Count();
if (propertyFind > 0)
{
data.id = db.tblDownloadAssignment.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblDownloadAssignment.Add(data);
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
return(new Tuple <ErrorObject, int>(erros.IfError(false), data.id));
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, int>(erros, 0));
}
}
/// <summary>
/// Return Downloan Assignment Information By Specific ID
/// </summary>
/// <param name="id">Download Assignment ID</param>
/// <returns>Download Assignment Information</returns>
public static Tuple <ErrorObject, tblDownloadAssignment> GetDownload(int id)
{
tblDownloadAssignment data = new tblDownloadAssignment();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.tblDownloadAssignment.Find(id);
}
erros.Error = false;
return(new Tuple <ErrorObject, tblDownloadAssignment>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblDownloadAssignment>(erros, data));
}
}
private static GetDownloadResponse Downloads(GetDownloadResponse request)
{
GetDownloadResponse response = new GetDownloadResponse();
response.Error = new Handler.ErrorObject();
try
{
tblDownloadAssignment bussines = new tblDownloadAssignment()
{
id = request.Download.id,
amount = request.Download.amount,
idProduct = request.Download.idProduct,
idEmployee = request.Download.idEmployee,
detail = request.Download.detail,
idCategory = request.Download.idCategory,
createDate = request.Download.createDate,
upDateDate = null,
deleteDate = null,
state = "Active"
};
var result = DownloadAssignmentData.Insert.Download(bussines);
if (result.Item1.Error)
{
response.Error.InfoError(result.Item1);
}
else
{
response.Message = result.Item2.ToString();
}
}
catch (Exception ex)
{
response.Error.InfoError(ex);
}
return(response);
}
/// <summary>
/// Update Assignment Information
/// </summary>
/// <param name="data">Assignment Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Download(tblDownloadAssignment data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblDownloadAssignment.Single(p => p.id == data.id);
row.idEmployee = data.idEmployee;
row.detail = data.detail;
row.upDateDate = data.upDateDate;
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
return(new Tuple <ErrorObject, string>(erros.IfError(false), Message));
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, string>(erros, String.Empty));
}
}
public static GetDownloadResponse Downloads(GetDownloadResponse request)
{
GetDownloadResponse response = new GetDownloadResponse();
try
{
tblDownloadAssignment bussines = new tblDownloadAssignment()
{
id = request.Download.id,
amount = request.Download.amount,
detail = request.Download.detail,
idCategory = request.Download.idCategory,
idEmployee = request.Download.idEmployee,
idProduct = request.Download.idProduct,
createDate = request.Download.createDate,
upDateDate = request.Download.upDateDate,
deleteDate = request.Download.deleteDate,
state = request.Download.state
};
var result = DownloadAssignmentData.Update.Download(bussines);
if (result.Item1.Error)
{
response.Error.InfoError(result.Item1);
}
else
{
response.Message = result.Item2;
}
}
catch (Exception ex)
{
response.Error.InfoError(ex);
}
return(response);
}
