public static Tuple <ErrorObject, GetTransactionConfigurateDataResponse> GetTransaction(int TransactionID)
{
GetTransactionConfigurateDataResponse data = new GetTransactionConfigurateDataResponse();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
data = (from TC in db.tblTransactionConfigurate
join T in db.tblTransaction
on TC.idTransaction equals T.id
join TT in db.tblTransactionType
on TC.idTransactionType equals TT.id
where T.id == TransactionID
select new GetTransactionConfigurateDataResponse()
{
TCid = TC.id,
TCcreateDate = TC.createDate,
TCdeleteDate = TC.deleteDate,
TCdetail = TC.detail,
TCidAnchorTransaction = TC.idAnchorTransaction,
TCidTransaction = TC.idTransaction,
TCidTransactionType = TC.idTransactionType,
TCstate = TC.state,
TCupDateDate = TC.upDateDate,
Tamount = T.amount,
Tstate = T.state,
TcreateDate = T.createDate,
Tdetail = T.detail,
TdeleteDate = T.deleteDate,
TidProvide = T.idProvide,
TupDateDate = T.upDateDate,
TTdetail = TT.detail,
TTcreateDate = TT.createDate,
TTstate = TT.state,
TTname = TT.name,
TTdeleteDate = TT.deleteDate,
TTupDateDate = TT.upDateDate
}).First();
};
return(new Tuple <ErrorObject, GetTransactionConfigurateDataResponse>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, GetTransactionConfigurateDataResponse>(erros, data));
}
}
/// <summary>
/// Update Cellar Information
/// </summary>
/// <param name="data">Cellar Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Cellar(tblCellar data)
{
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
db.Entry(data).State = EntityState.Modified;
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>
/// Return ID To Product ID and Cellar Area ID
/// </summary>
/// <param name="ProductID"></param>
/// <param name="CellarArea"></param>
/// <returns></returns>
public static Tuple <ErrorObject, int> GetCellarIDByProductIDAndCellarArea(int ProductID, int CellarAreaID)
{
int id = 0;
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
id = (int)db.tblCellar.Single(C => C.idProduct == ProductID && C.idcellarArea == CellarAreaID).id;
return(new Tuple <ErrorObject, int>(erros.IfError(false), id));
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, int>(erros, 0));
}
}
/// <summary>
/// Return Cellar Information
/// </summary>
/// <param name="id">Cellar ID</param>
/// <returns>Cellar Information</returns>
public static Tuple <ErrorObject, tblCellar> GetCellar(int id)
{
tblCellar data = new tblCellar();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
data = db.tblCellar.Find(id);
};
return(new Tuple <ErrorObject, tblCellar>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblCellar>(erros, data));
}
}
/// <summary>
/// Return All Cellar To Specific ID
/// </summary>
/// <param name="ProductID">ProductID</param>
/// <returns>All Cellar</returns>
public static Tuple <ErrorObject, List <tblCellar> > GetCellarByProductID(int ProductID)
{
List <tblCellar> data = new List <tblCellar>();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
data = db.tblCellar.Where(c => c.idProduct == ProductID).ToList();
};
return(new Tuple <ErrorObject, List <tblCellar> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblCellar> >(erros, data));
}
}
/// <summary>
/// Return All UserConfiguration To Specific User ID
/// </summary>
/// <param name="UserID">UserID</param>
/// <returns>All UserConfiguration To Specific User ID</returns>
public static Tuple <ErrorObject, List <tblUserConfiguration> > GetUserConfigurationListByUserID(int UserID)
{
List <tblUserConfiguration> data = new List <tblUserConfiguration>();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
data = db.tblUserConfiguration.Where(u => u.idUser == UserID).ToList();
};
return(new Tuple <ErrorObject, List <tblUserConfiguration> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblUserConfiguration> >(erros, data));
}
}
/// <summary>
/// Return All Employee
/// </summary>
/// <returns>All Employee Or null If Exist Error</returns>
public static Tuple <ErrorObject, List <tblEmployee> > GetEmployeeList()
{
List <tblEmployee> data = new List <tblEmployee>();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
data = db.tblEmployee.ToList();
};
return(new Tuple <ErrorObject, List <tblEmployee> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblEmployee> >(erros, data));
}
}
/// <summary>
/// Return All Users
/// </summary>
/// <returns>All User Or null If Exist Error</returns>
public static Tuple <ErrorObject, List <tblUser> > GetUserList()
{
List <tblUser> Users = new List <tblUser>();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
Users = db.tblUser.ToList();
};
return(new Tuple <ErrorObject, List <tblUser> >(erros.IfError(false), Users));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblUser> >(erros, Users));
}
}
/// <summary>
/// Return Users By Specific ID
/// </summary>
/// <param name="id">User ID</param>
/// <returns>User By Specific ID Or null If Exist Error</returns>
public static Tuple <ErrorObject, tblUser> GetUser(int id)
{
tblUser Users = new tblUser();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
Users = db.tblUser.Find(id);
}
erros.Error = false;
return(new Tuple <ErrorObject, tblUser>(erros.IfError(false), Users));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblUser>(erros, Users));
}
}
/// <summary>
/// Get Type Permission Name By Specific ID
/// </summary>
/// <param name="id">TypePermissionID</param>
/// <returns>Type Permission Name By Specific ID</returns>
public static Tuple <ErrorObject, tblTypePermission> GetTypePermissionName(int id)
{
tblTypePermission TypePermission = new tblTypePermission();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
TypePermission.name = db.tblTypePermission.Find(id).name;
}
erros.Error = false;
return(new Tuple <ErrorObject, tblTypePermission>(erros.IfError(false), TypePermission));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblTypePermission>(erros, TypePermission));
}
}
/// <summary>
/// Return All TypePermission
/// </summary>
/// <returns>All TypePermission Or null If Exist Error</returns>
public static Tuple <ErrorObject, List <tblTypePermission> > GetTypePermissionList()
{
List <tblTypePermission> TypePermission = new List <tblTypePermission>();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
TypePermission = db.tblTypePermission.ToList();
};
return(new Tuple <ErrorObject, List <tblTypePermission> >(erros.IfError(false), TypePermission));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblTypePermission> >(erros, TypePermission));
}
}
/// <summary>
/// Return Product Type By Specific ID
/// </summary>
/// <param name="id">Product Type ID</param>
/// <returns>Produc Type By Specific ID Or null If Exist Error</returns>
public static Tuple <ErrorObject, tblProductType> GetProductType(int id)
{
tblProductType productType = new tblProductType();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
productType = db.tblProductType.Find(id);
}
erros.Error = false;
return(new Tuple <ErrorObject, tblProductType>(erros.IfError(false), productType));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblProductType>(erros, productType));
}
}
/// <summary>
/// Update Cellar Amount TO Specific Cellar ID
/// </summary>
/// <param name="CellarID">Cellar ID</param>
/// <param name="CellarAmount">Cellar Amount</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> CellarAmoun(int CellarID, int CellarAmount)
{
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
var row = db.tblCellar.Single(p => p.id == CellarID);
row.amount = CellarAmount;
row.upDateDate = DateTime.Now;
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>
/// Get User Type Name
/// </summary>
/// <param name="id">UserTypeID</param>
/// <returns>User Type Name</returns>
public static Tuple <ErrorObject, string> GetUserTypeName(int id)
{
string UserType = "";
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
UserType = db.tblUserType.Find(id).name;
}
erros.Error = false;
return(new Tuple <ErrorObject, string>(erros.IfError(false), UserType));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, string>(erros, UserType));
}
}
/// <summary>
/// Return All Product Type
/// </summary>
/// <returns>All Product Type Or null If Exist Error</returns>
public static Tuple <ErrorObject, List <tblProductType> > GetProductTypeList()
{
List <tblProductType> productType = new List <tblProductType>();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
productType = db.tblProductType.ToList();
};
return(new Tuple <ErrorObject, List <tblProductType> >(erros.IfError(false), productType));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblProductType> >(erros, productType));
}
}
/// <summary>
/// Return Employee By Specific ID
/// </summary>
/// <param name="id">Employee ID</param>
/// <returns>Employee By Specific ID Or null If Exist Error</returns>
public static Tuple <ErrorObject, tblEmployee> GetEmployee(int id)
{
tblEmployee data = new tblEmployee();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
data = db.tblEmployee.Find(id);
}
erros.Error = false;
return(new Tuple <ErrorObject, tblEmployee>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblEmployee>(erros, data));
}
}
/// <summary>
/// Return UserConfiguration By Specific ID
/// </summary>
/// <param name="id">UserConfiguration ID</param>
/// <returns>UserConfiguration By Specific ID Or null If Exist Error</returns>
public static Tuple <ErrorObject, tblUserConfiguration> GetUserConfiguration(int id)
{
tblUserConfiguration data = new tblUserConfiguration();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
data = db.tblUserConfiguration.Find(id);
}
erros.Error = false;
return(new Tuple <ErrorObject, tblUserConfiguration>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblUserConfiguration>(erros, data));
}
}
/// <summary>
/// Return Product List To Specific Cella Area ID
/// </summary>
/// <param name="CellarAreaID">Cellar Area ID</param>
/// <returns>Product List To Specific Cella Area ID</returns>
public static Tuple <ErrorObject, List <tblProduct> > GetProductByAssignmentType(int CellarAreaID)
{
List <tblProduct> data = new List <tblProduct>();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
data = (from P in db.tblProduct
join C in db.tblCellar on P.id equals C.idProduct
where C.idcellarArea == CellarAreaID
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>
/// Update State Fields To Specific CellarAreaID ID
/// </summary>
/// <param name="ProductTypeID">Cellar Area ID</param>
/// <param name="state">Active Or Disable</param>
/// <returns>ID Department ID</returns>
public static Tuple <ErrorObject, string> ProductTypeDisable(int ProductTypeID, string state)
{
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
var row = db.tblProductType.Single(p => p.id == ProductTypeID);
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>
/// 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 (HSCMEntities db = new HSCMEntities())
{
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="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>
/// 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));
}
}
