/// <summary>
/// Update User Type Information
/// </summary>
/// <param name="data">UserType Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> UserType(tblUserType data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblUserType.Single(p => p.id == data.id);
row.name = data.name;
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));
}
}
/// <summary>
/// Update State Fields To Specific Employee ID
/// </summary>
/// <param name="CellarID">Cellar ID</param>
/// <param name="state">Active Or Disable</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> CellarDisable(int CellarID, string state)
{
erros = new ErrorObject();
try
{
// using (HSCMEntities db = new HSCMEntities())
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblEmployee.Single(p => p.id == CellarID);
row.state = state;
row.deleteDate = DateTime.Now;
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
erros.Error = false;
return(new Tuple <ErrorObject, string>(erros.IfError(false), Message));
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, string>(erros, String.Empty));
}
}
/// <summary>
/// Insert Employee Information
/// </summary>
/// <param name="data">Employee Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, int> product(tblProduct data)
{
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
int propertyFind = db.tblProduct.Count();
if (propertyFind > 0)
{
data.id = db.tblProduct.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblProduct.Add(data);
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
if (result > 0)
{
return(new Tuple <ErrorObject, int>(erros.IfError(false), data.id));
}
else
{
return(new Tuple <ErrorObject, int>(erros.IfError(false), result));
}
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, int>(erros, 0));
}
}
/// <summary>
/// Return Product List To Special AssignmentType and AnchorAssignment
/// </summary>
/// <param name="AssignmentType">AssignmentType</param>
/// <param name="AnchorAssingment">AnchorAssingment</param>
/// <returns>Product List</returns>
public static Tuple <ErrorObject, List <tblProduct> > GetProductsOfAssignment(int AssignmentType, int AnchorAssingment)
{
List <tblProduct> data = new List <tblProduct>();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
data = (
from A in db.tblAssignment
join P in db.tblProduct
on A.idProduct equals P.id
where A.idAnchorAssingment == AnchorAssingment && A.idAssignmentType == AssignmentType
select P).ToList();
};
return(new Tuple <ErrorObject, List <tblProduct> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblProduct> >(erros, data));
}
}
/// <summary>
/// Return FileManger By Specific Product ID
/// </summary>
/// <param name="Productid">ProductID</param>
/// <returns>FileManger By Specific Product ID</returns>
public static Tuple <ErrorObject, List <tblFileManager> > GetProductFileManager(int Productid)
{
List <tblFileManager> data = new List <tblFileManager>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = (from FM in db.tblFileManager
join PFM in db.tblProductFileManager on FM.id equals PFM.idFileManager
join P in db.tblProduct on PFM.idProduct equals P.id
where P.id == Productid
select FM
).ToList();
};
return(new Tuple <ErrorObject, List <tblFileManager> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblFileManager> >(erros, data));
}
}
/// <summary>
/// Return Product List To Special AssignmentType and AnchorAssignment
/// </summary>
/// <param name="CategoryID">CategoryID</param>
/// <returns>Product List</returns>
public static Tuple <ErrorObject, List <tblProduct> > GetProductsOfAssignment(int CategoryID)
{
List <tblProduct> data = new List <tblProduct>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = (
from A in db.tblAssignment
join P in db.tblProduct
on A.idProduct equals P.id
where A.idCategory == CategoryID
select P).ToList();
};
return(new Tuple <ErrorObject, List <tblProduct> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblProduct> >(erros, data));
}
}
