/// <summary>
/// Return All Assingnment To specific Product, category, Codition and TransactionType IDS
/// </summary>
/// <param name="ProductID"></param>
/// <param name="CategoryID"></param>
/// <param name="ConditionID"></param>
/// <param name="TransactionTypeID"></param>
/// <returns>All Assignment</returns>
public static Tuple <ErrorObject, tblAssignment> GetAssignmentByProductIDAndCategoryWithCondition(int ProductID, int CategoryID, int ConditionID, int TransactionTypeID)
{
tblAssignment data = new tblAssignment();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = (from TC in db.tblTransactionConfigurate
join A in db.tblAssignment on TC.idAnchorTransaction equals A.id
join T in db.tblTransaction on TC.idTransaction equals T.id
where A.idProduct == ProductID && TC.idTransactionType == TransactionTypeID && T.idConditionProduct == ConditionID
select A).First();
}
erros.Error = false;
return(new Tuple <ErrorObject, tblAssignment>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblAssignment>(erros, data));
}
}
/// <summary>
/// Return All Product By Specific Cellar Area ID
/// </summary>
/// <param name="CellarAreaID">CellarAreaID</param>
/// <returns>All Product</returns>
public static Tuple <ErrorObject, List <tblProduct> > GetProductToCellarArea(int CellarAreaID)
{
List <tblProduct> data = new List <tblProduct>();
List <int> ids = new List <int>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
//ids = (from C in db.tblCellar where C.idcellarArea == CellarAreaID select (int)C.idProduct).ToList();
//data = db.tblProduct.ToList();
//for (int v = 0; v < ids.Count; v++)
//{
// var itemToRemove = data.SingleOrDefault(r => r.id == ids[v]);
// if (itemToRemove != null)
// data.Remove(itemToRemove);
//}
data = db.SP_Product_SelectProduct("GetProductToCellarArea", CellarAreaID, 0, 0).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 Specific Infomation to Cellar how Min, Max and detail
/// </summary>
/// <param name="data"></param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> CellarUpdate(tblCellar data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblCellar.Single(p => p.id == data.id);
row.idcellarArea = data.idcellarArea;
row.min = data.min;
row.max = data.max;
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>
/// Insert TransactionType Information
/// </summary>
/// <param name="data">Transaction Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, int> Transaction(tblTransaction data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
int propertyFind = db.tblTransaction.Count();
if (propertyFind > 0)
{
data.id = db.tblTransaction.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblTransaction.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 All User Data with Configuration
/// </summary>
/// <returns>All User Data with Configuration</returns>
public static Tuple <ErrorObject, List <tblUser> > GetUserButConfigurationList()
{
List <tblUser> Users = new List <tblUser>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
Users = (from U in db.tblUser
join UC in db.tblUserConfiguration
on U.id equals UC.idUser
select U
).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>
/// Update Transaction Information
/// </summary>
/// <param name="data">Transaction Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Transaction(tblTransaction data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblTransaction.Single(p => p.id == data.id);
row.amount = data.amount;
row.expeditionDate = data.expeditionDate;
row.idConditionProduct = data.idConditionProduct;
row.idProvide = data.idProvide;
row.state = data.state;
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 Users Information
/// </summary>
/// <param name="data">Users Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Users(tblUser data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblUser.Single(p => p.id == data.id);
if (!String.IsNullOrEmpty(data.password))
{
row.password = data.password;
}
row.user = data.user;
row.upDateDate = 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>
/// Update Product Information
/// </summary>
/// <param name="data">Product Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> product(tblProduct data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblProduct.Single(p => p.id == data.id);
row.name = data.name;
row.code = data.code;
row.unit = data.unit;
row.idProductType = data.idProductType;
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>
/// Insert Employee Information
/// </summary>
/// <param name="data">Employee Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Employee(tblEmployee data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
int propertyFind = db.tblEmployee.Count();
if (propertyFind > 0)
{
data.id = db.tblEmployee.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblEmployee.Add(data);
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 Amoun from Transaction BY Specific AnchorTransactionID and TransactionTypeID
/// </summary>
/// <param name="AnchorTransactionID"></param>
/// <param name="TransactionTypeID"></param>
/// <returns>Amoun from Transaction</returns>
public static Tuple <ErrorObject, int> GetTotalAmountToTransaction(int AnchorTransactionID, int TransactionTypeID)
{
int data = 0;
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = (from TC in db.tblTransactionConfigurate
join T in db.tblTransaction
on TC.idTransaction equals T.id
where TC.idAnchorTransaction == AnchorTransactionID && TC.idTransactionType == TransactionTypeID
select T.amount
).Sum(T => (int)T.Value);
}
erros.Error = false;
return(new Tuple <ErrorObject, int>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, int>(erros, data));
}
}
/// <summary>
/// Update Employee Information
/// </summary>
/// <param name="data">Employee Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Employee(tblEmployee data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblEmployee.Single(p => p.id == data.id);
row.email = data.email;
row.firstName = data.firstName;
row.lastName = data.lastName;
row.idUser = data.idUser;
row.idUserType = data.idUserType;
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>
/// Return All Transaction Condition Detail By Specific TransactionType ID and TransactionAnchorID
/// </summary>
/// <param name="TransactionTypeID">TransactionType ID</param>
/// <param name="TransactionAnchorID">TransactionAnchor ID</param>
/// <param name="ConditionID">Condition ID</param>
/// <returns>All Transaction Condition Detail</returns>
public static Tuple <ErrorObject, bool> GetTransactionTypeConditionDetailCount(int TransactionTypeID, int TransactionAnchorID, int ConditionID)
{
erros = new ErrorObject();
try
{
// using (HSCMEntities db = new HSCMEntities())
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var data = db.tblTransactionTypeConditionDetail.Where(t => t.idTransactionType == TransactionTypeID && t.idTransactionAnchor == TransactionAnchorID && t.idCondition == ConditionID).Count();
erros.Error = false;
if (data > 0)
{
return(new Tuple <ErrorObject, bool>(erros.IfError(false), true));
}
else
{
return(new Tuple <ErrorObject, bool>(erros.IfError(false), false));
}
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, bool>(erros, false));
}
}
/// <summary>
/// Return Amount To ProductID and CellarID From Cellar
/// </summary>
/// <param name="ProductID">Product ID</param>
/// <param name="CellarArea">CellarAreaID</param>
/// <returns>Amount from Cellar</returns>
public static Tuple <ErrorObject, tblCellar> GetCellarByProductIDAndCellarArea(int ProductID, int CellarAreaID, int conditionID, int transactionTypeID)
{
tblCellar Amount = new tblCellar();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
Amount = (
from TC in db.tblTransactionConfigurate
join C in db.tblCellar on TC.idAnchorTransaction equals C.id
join T in db.tblTransaction on TC.idTransaction equals T.id
where C.idProduct == ProductID && C.idcellarArea == CellarAreaID && TC.idTransactionType == transactionTypeID && T.idConditionProduct == conditionID
select C).First();
return(new Tuple <ErrorObject, tblCellar>(erros.IfError(false), Amount));
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblCellar>(erros, Amount));
}
}
/// <summary>
/// Insert Prodcuto File Manager Information
/// </summary>
/// <param name="data">Product FileManager INformaation</param>
/// <returns>Product File Manager ID</returns>
public static Tuple <ErrorObject, int> ProductFileManager(tblProductFileManager data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
int propertyFind = db.tblProductFileManager.Count();
if (propertyFind > 0)
{
data.id = db.tblProductFileManager.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblProductFileManager.Add(data);
result = db.SaveChanges();
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>
/// Update UserConfiguration Information
/// </summary>
/// <param name="data">UserConfiguration Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> UserConfiguration(tblUserConfiguration data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblUserConfiguration.Single(p => p.id == data.id);
row.idUser = data.idUser;
row.idTypePermission = data.idTypePermission;
row.idCellarArea = data.idCellarArea;
row.idAssignmentType = data.idAssignmentType;
row.idAnchorAssignmentType = data.idAnchorAssignmentType;
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>
/// Return All Transaction COnfiguraction Data By Specific AnchorTransactionID and TransactionTypeID
/// </summary>
/// <param name="AnchorTransactionID">AnchorTransaction ID</param>
/// <param name="TransactionTypeID">TransactionType ID</param>
/// <returns>All Transaction COnfiguraction Data</returns>
public static Tuple <ErrorObject, List <GetTransactionConfigurateDataResponse> > GetTransactionList(int AnchorTransactionID, int TransactionTypeID)
{
List <GetTransactionConfigurateDataResponse> data = new List <GetTransactionConfigurateDataResponse>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
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 TC.idAnchorTransaction == AnchorTransactionID && TC.idTransactionType == TransactionTypeID
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,
TexpeditionDate = T.expeditionDate,
TidConditionProduct = T.idConditionProduct,
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
}).ToList();
};
return(new Tuple <ErrorObject, List <GetTransactionConfigurateDataResponse> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <GetTransactionConfigurateDataResponse> >(erros, data));
}
}
/// <summary>
/// Return all items to menu
/// </summary>
/// <returns>All items to menu</returns>
public static Tuple <ErrorObject, List <GetMenuResult> > GetCellarAreaListMenu()
{
List <GetMenuResult> data = new List <GetMenuResult>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var datas = (from CA in db.tblCellarArea
join C in db.tblCategory
on CA.id equals C.idCellarArea
select new GetMenuResult {
Department = CA.name,
CategoryID = C.id,
CellarAreaID = CA.id,
FatherCategoryID = (int)C.idCategory,
Area = C.name
}).OrderBy(C => C.CellarAreaID).ToList();
foreach (var data3 in datas)
{
int f = (from C in db.tblCategory where C.idCategory == data3.CategoryID select C.id).Count();
data.Add(new GetMenuResult()
{
Area = data3.Area,
CellarAreaID = data3.CellarAreaID,
CategoryID = data3.CategoryID,
Department = data3.Department,
FatherCategoryID = data3.FatherCategoryID,
Father = (f > 0 ? true : false)
});
}
};
return(new Tuple <ErrorObject, List <GetMenuResult> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <GetMenuResult> >(erros, data));
}
}
/// <summary>
/// Return All Transaction Condition Detail By Specific TransactionType ID and TransactionAnchorID
/// </summary>
/// <param name="TransactionTypeID">TransactionType ID</param>
/// <param name="TransactionAnchorID">TransactionAnchor ID</param>
/// <param name="ConditionID">Condition ID</param>
/// <returns>All Transaction Condition Detail</returns>
public static Tuple <ErrorObject, List <tblTransactionTypeConditionDetail> > GetTransactionTypeConditionDetailList(int TransactionTypeID, int TransactionAnchorID, int ConditionID)
{
List <tblTransactionTypeConditionDetail> data = new List <tblTransactionTypeConditionDetail>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.tblTransactionTypeConditionDetail.Where(T => T.idTransactionType == TransactionTypeID && T.idTransactionAnchor == TransactionAnchorID && T.idCondition == ConditionID).ToList();
};
return(new Tuple <ErrorObject, List <tblTransactionTypeConditionDetail> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblTransactionTypeConditionDetail> >(erros, data));
}
}
/// <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 (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
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 Department Information
/// </summary>
/// <param name="CategoryID">Category ID</param>
/// <returns>Department Information</returns>
public static Tuple <ErrorObject, tblCategory> GetCategory(int CategoryID)
{
tblCategory c = new tblCategory();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
c = db.tblCategory.Find(CategoryID);
return(new Tuple <ErrorObject, tblCategory>(erros.IfError(false), c));
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblCategory>(erros, c));
}
}
/// <summary>
/// Return All Cellar By Specific Cellar Area ID
/// </summary>
/// <param name="CellarAreaID"></param>
/// <returns>All Cellar</returns>
public static Tuple <ErrorObject, List <tblCellar> > GetCellarToArea(int CellarAreaID)
{
List <tblCellar> data = new List <tblCellar>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.tblCellar.Where(m => m.idcellarArea == CellarAreaID).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 ID To Product ID and Cellar Area ID
/// </summary>
/// <param name="ProductID"></param>
/// <param name="CellarArea"></param>
/// <returns></returns>
public static Tuple <ErrorObject, tblCellar> GetCellarIDByProductIDAndCellarArea(int ProductID, int CellarAreaID)
{
tblCellar data = new tblCellar();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.tblCellar.Single(C => C.idProduct == ProductID && C.idcellarArea == CellarAreaID);
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 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 (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
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 (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
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 Download Assignment By Specific Product ID
/// </summary>
/// <param name="ProductID">Product ID</param>
/// <returns>All Download Assignment</returns>
public static Tuple <ErrorObject, List <tblDownloadAssignment> > GetDownloadByProductID(int ProductID)
{
List <tblDownloadAssignment> data = new List <tblDownloadAssignment>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.tblDownloadAssignment.Where(c => c.idProduct == ProductID).ToList();
};
return(new Tuple <ErrorObject, List <tblDownloadAssignment> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblDownloadAssignment> >(erros, data));
}
}
/// <summary>
/// Return Category List
/// </summary>
/// <returns>Category List</returns>
public static Tuple <ErrorObject, List <tblCategory> > GetCategory()
{
List <tblCategory> c = new List <tblCategory>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
c = db.tblCategory.OrderBy(d1 => d1.idCategory).OrderBy(d1 => d1.id).OrderBy(f => f.idCellarArea).ToList();
return(new Tuple <ErrorObject, List <tblCategory> >(erros.IfError(false), c));
};
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblCategory> >(erros, c));
}
}
/// <summary>
/// Return Cellar
/// </summary>
/// <returns>All Cellar </returns>
public static Tuple <ErrorObject, List <tblCellar> > GetCellarHome()
{
List <tblCellar> data = new List <tblCellar>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.tblCellar.Where(c => c.amount <= c.min).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 Assignment TO AnchorAssignment ID and Assignment Type
/// </summary>
/// <returns>All Assignment Or null If Exist Error</returns>
public static Tuple <ErrorObject, List <tblAssignment> > GetAssignmentByCategoryID(int CategoryID)
{
List <tblAssignment> data = new List <tblAssignment>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.tblAssignment.Where(c => c.idCategory == CategoryID).ToList();
};
return(new Tuple <ErrorObject, List <tblAssignment> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblAssignment> >(erros, data));
}
}
/// <summary>
/// Update Category and All category child
/// </summary>
/// <param name="data">Category information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> CategoryAndAllChildCellarArea(tblCategory data)
{
List <int> Child = new List <int>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblCategory.Single(p => p.id == data.id);
row.name = data.name;
row.idCategory = data.idCategory;
row.idCellarArea = data.idCellarArea;
row.detail = data.detail;
row.upDateDate = data.upDateDate;
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
Child = (
from C in db.tblCategory
where C.idCategory == data.id
select C.id).ToList();
if (Child.Count > 0)
{
foreach (var item in Child)
{
var row2 = db.tblCategory.Single(p => p.id == item);
row2.idCellarArea = data.idCellarArea;
db.SaveChanges();
}
}
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 Transaction By Specific ID
/// </summary>
/// <param name="id">Transaction ID</param>
/// <returns>Transaction By Specific ID Or null If Exist Error</returns>
public static Tuple <ErrorObject, tblTransaction> GetTransaction(int id)
{
tblTransaction data = new tblTransaction();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.tblTransaction.Find(id);
}
erros.Error = false;
return(new Tuple <ErrorObject, tblTransaction>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblTransaction>(erros, data));
}
}
