public void saveFile(string month, int year, string type, int customerId, HttpPostedFile files)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
var header = cs.clfs_winner_monthly_headers.Where(x => x.EXHIBITOR_ID == customerId && x.REPORTING_MONTH == month && x.SHOW_YEAR == year).FirstOrDefault();
if (header == null)
{
header = new clfs_winner_monthly_headers {
EXHIBITOR_ID = customerId, REPORTING_MONTH = month, SHOW_YEAR = year
};
cs.clfs_winner_monthly_headers.Add(header);
cs.SaveChanges();
}
Stream stream = files.InputStream;
BinaryReader reader = new BinaryReader(stream);
byte[] imgByte = reader.ReadBytes((int)stream.Length);
if (type == "corres")
{
cs.clfs_winner_monthly_documents.Add(new clfs_winner_monthly_documents {
HEADER_ID = header.HEADER_ID, CORRESPONDENCE = imgByte, CORR_FILE_NAME = files.FileName, CORR_FILE_TYPE = GetFileExtension(files.FileName), CORR_SUBMIT_DATE = DateTime.Now
});
cs.clfs_winner_monthly_documents.Add(new clfs_winner_monthly_documents {
HEADER_ID = header.HEADER_ID, CORRESPONDENCE = imgByte, CORR_FILE_NAME = files.FileName, CORR_FILE_TYPE = GetFileExtension(files.FileName), CORR_SUBMIT_DATE = DateTime.Now
});
}
else
{
cs.clfs_winner_monthly_documents.Add(new clfs_winner_monthly_documents {
HEADER_ID = header.HEADER_ID, PHOTO = imgByte, PHOTO_FILE_NAME = files.FileName, PHOTO_FILE_TYPE = GetFileExtension(files.FileName), PHOTO_SUBMIT_DATE = DateTime.Now
});
}
cs.SaveChanges();
}
}
public List <animal> GetAnimals(int cuid)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
return(cs.animals.Where(x => x.CUSTOMER_ID == cuid).ToList());
}
}
public bool UpdateCustomer(customer cu, address addr, animal an)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
var cust = cs.customers.Where(x => x.CUSTOMER_ID == cu.CUSTOMER_ID).FirstOrDefault();
cust.CUSTOMER_NUMBER = cu.CUSTOMER_NUMBER;
cust.FIRST_NAME = cu.FIRST_NAME;
cust.LAST_NAME = cu.LAST_NAME;
cust.LAST_UPDATE_DATE = DateTime.Now;
var address = cs.addresses.Where(x => x.ADDRESS_ID == addr.ADDRESS_ID).FirstOrDefault();
address.ADDRESS1 = addr.ADDRESS1;
address.CITY = addr.CITY;
address.COUNTRY = addr.COUNTRY;
address.CREATED_BY = addr.CREATED_BY;
address.CREATION_DATE = addr.CREATION_DATE;
address.EMAIL = addr.EMAIL;
address.EMAIL_SECOND = addr.EMAIL_SECOND;
address.PHONE = addr.PHONE;
address.POSTAL = addr.POSTAL;
address.STATE = addr.STATE;
address.STATUS = addr.STATUS;
if (an.ANIMAL_ID == 0 && an.ANIMAL_TYPE != null)
{
if (an.ANIMAL_TYPE.Equals("Steer", StringComparison.InvariantCultureIgnoreCase))
{
an.ANIMAL_NAME = "Calf Scrambler";
an.DATE_OF_BIRTH = new DateTime(1901, 1, 1);
}
cs.animals.Add(an);
}
cs.SaveChanges();
return(true);
}
}
public List <clfs_winner_monthly_documents> GetAllAttachmentByHeaderId(int id, string month, int year)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
var header = cs.clfs_winner_monthly_headers.Where(x => x.EXHIBITOR_ID == id && x.REPORTING_MONTH == month && x.SHOW_YEAR == year).FirstOrDefault();
if (header == null)
{
return(null);
}
var data = cs.clfs_winner_monthly_documents.Where(x => x.HEADER_ID == header.HEADER_ID).ToList();
int i = 0;
foreach (var d in data)
{
if (d.CORR_FILE_NAME != null)
{
d.COMMENTS = "corres";
}
else
{
i++;
d.COMMENTS = "photo" + i;
}
}
return(data);
}
}
public clfs_winner_monthly_documents GetAttachmentByHeaderId(int id, string month, int year, string type)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
var header = cs.clfs_winner_monthly_headers.Where(x => x.EXHIBITOR_ID == id && x.REPORTING_MONTH == month && x.SHOW_YEAR == year).FirstOrDefault();
if (type == "corres")
{
return(cs.clfs_winner_monthly_documents.Where(x => x.HEADER_ID == header.HEADER_ID && x.CORR_FILE_NAME != null).FirstOrDefault());
}
else
{
var image = cs.clfs_winner_monthly_documents.Where(x => x.HEADER_ID == header.HEADER_ID && x.PHOTO_FILE_NAME != null).ToArray();
if (type == "photo1")
{
return(image[0]);
}
else if (type == "photo2")
{
return(image[1]);
}
else
{
return(image[2]);
}
}
}
}
public clfs_winner_info GetEssayFile(int id, string month, int year)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
return(cs.clfs_winner_info.Where(x => x.EXHIBITOR_ID == id && x.SHOW_YEAR == year).FirstOrDefault());
}
}
public address GetAddressById(int id)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
return(cs.addresses.Where(x => x.CUSTOMER_ID == id).FirstOrDefault());
}
}
public customer GetCustomerById(int id)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
return(cs.customers.Where(x => x.CUSTOMER_ID == id).FirstOrDefault());
}
}
public bool DeleteExpense(int id)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
cs.clfs_winner_monthly_expenses.RemoveRange(cs.clfs_winner_monthly_expenses.Where(x => x.LINE_ID == id));
cs.SaveChanges();
return(true);
}
}
public bool DeleteDocById(int id)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
cs.clfs_winner_monthly_documents.RemoveRange(cs.clfs_winner_monthly_documents.Where(x => x.CLFS_DOC_ID == id));
cs.SaveChanges();
return(true);
}
}
public animal GetAnimalsById(int id)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
var l = cs.animals.Where(x => x.CUSTOMER_ID == id).ToList();
return(l.Any()?l.FirstOrDefault():new animal {
ANIMAL_ID = 0
});
}
}
//public clfs_winner_info GetAllEssay(int year, int customerId)
//{
// using (CalfScramblerEntities cs = new CalfScramblerEntities())
// {
// return cs.clfs_winner_info.Where(x => x.EXHIBITOR_ID == customerId && x.SHOW_YEAR == year).FirstOrDefault();
// }
//}
public bool DeleteEssay(int id, string type)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
var file = cs.clfs_winner_info.Where(x => x.Line_id == id).FirstOrDefault();
if (file != null)
{
switch (type)
{
case "initass":
///file.ASSESSMENT_INIT = files.FileName;
file.ASSESSMENT_INIT_BLOB = null;
file.ASSESSMENT_INIT_FILE_NAME = null;
file.ASSESSMENT_INIT_FILE_TYPE = null;
file.ASSESSMENT_INIT_SUBMIT_DATE = null;
break;
case "finass":
//// file.ASSESSMENT_FINAL = files.FileName;
file.ASSESSMENT_FINAL_BLOB = null;
file.ASSESSMENT_FINAL_FILE_NAME = null;
file.ASSESSMENT_FINAL_FILE_TYPE = null;
file.ASSESSMENT_FINAL_SUBMIT_DATE = null;
break;
case "monledger":
file.LEDGER_MONTH_BLOB = null;
file.LEDGER_MONTH_FILE_NAME = null;
file.LEDGER_MONTH_FILE_TYPE = null;
file.LEDGER_MONTH_SUBMIT_DATE = null;
break;
case "breedessay":
// file.BREED_ESSAY = files.FileName;
file.BREED_RPT_BLOB = null;
file.BREED_FILE_NAME = null;
file.BREED_FILE_TYPE = null;
file.BREED_RPT_SUBMIT_DATE = null;
break;
case "yearendessay":
// file.YEAR_END_ESSAY = files.FileName;
file.YEAR_END_RPT_BLOB = null;
file.YREND_FILE_NAME = null;
file.YREND_FILE_TYPE = null;
file.YREND_RPT_SUBMIT_DATE = null;
break;
}
}
cs.SaveChanges();
}
return(true);
}
public void SaveAnimal(animal animal)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
if (animal.ANIMAL_TYPE.Equals("Steer", StringComparison.InvariantCultureIgnoreCase))
{
animal.ANIMAL_NAME = "Calf Scrambler";
animal.DATE_OF_BIRTH = new DateTime(1901, 1, 1);
}
cs.animals.Add(animal);
}
}
public IReadOnlyList <ExpenseGridEntity> GetExpenseByYear(int year, int customerid)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
var list = new List <ExpenseGridEntity>();
var header = cs.clfs_winner_monthly_headers.Where(x => x.EXHIBITOR_ID == customerid && x.SHOW_YEAR == year).FirstOrDefault();
if (header != null)
{
foreach (var r in cs.clfs_winner_monthly_expenses.Where(x => x.HEADER_ID == header.HEADER_ID))
{
list.Add(new ExpenseGridEntity {
expenseid = r.LINE_ID, expensetype = r.EXPENSE_TYPE, month = header.REPORTING_MONTH, quantity = (int)r.QUANTITY, unitcost = (decimal)r.UNIT_COST, year = year
});
}
}
return(list);
}
}
public bool AddExpense(ExpenseEntity e)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
var header = cs.clfs_winner_monthly_headers.Where(x => x.EXHIBITOR_ID == e.customerid && x.REPORTING_MONTH == e.month && x.SHOW_YEAR == e.year).FirstOrDefault();
if (header == null)
{
header = new clfs_winner_monthly_headers {
EXHIBITOR_ID = e.customerid, REPORTING_MONTH = e.month, SHOW_YEAR = e.year
};
cs.clfs_winner_monthly_headers.Add(header);
cs.SaveChanges();
}
cs.clfs_winner_monthly_expenses.Add(new clfs_winner_monthly_expenses {
HEADER_ID = header.HEADER_ID, EXPENSE_TYPE = e.expensetype, QUANTITY = e.quantity, UNIT_COST = e.unitcost
});
cs.SaveChanges();
return(true);
}
}
public void saveEssayFile(string month, int year, string type, int customerId, HttpPostedFile files)
{
using (CalfScramblerEntities cs = new CalfScramblerEntities())
{
var winner_info = cs.clfs_winner_info.Where(x => x.EXHIBITOR_ID == customerId && x.SHOW_YEAR == year).FirstOrDefault();
if (winner_info == null)
{
var header = new clfs_winner_info {
EXHIBITOR_ID = customerId, SHOW_YEAR = year, EXHIBITOR_NAME = "", EXHIBITOR_NUMBER = "", DONOR_NAME = "", DONOR_NUMBER = ""
};
cs.clfs_winner_info.Add(header);
cs.SaveChanges();
}
/////////winner_info = cs.clfs_winner_info.Where(x => x.EXHIBITOR_ID == customerId && x.SHOW_YEAR == year).FirstOrDefault();
Stream stream = files.InputStream;
BinaryReader reader = new BinaryReader(stream);
byte[] imgByte = reader.ReadBytes((int)stream.Length);
var file = cs.clfs_winner_info.Where(x => x.EXHIBITOR_ID == customerId && x.SHOW_YEAR == year).FirstOrDefault();
if (file != null)
{
switch (type)
{
case "initass":
///file.ASSESSMENT_INIT = files.FileName;
file.ASSESSMENT_INIT_BLOB = imgByte;
file.ASSESSMENT_INIT_FILE_NAME = files.FileName;
file.ASSESSMENT_INIT_FILE_TYPE = GetFileExtension(files.FileName); /// files.ContentType;
file.ASSESSMENT_INIT_SUBMIT_DATE = DateTime.Now;
break;
case "finass":
//// file.ASSESSMENT_FINAL = files.FileName;
file.ASSESSMENT_FINAL_BLOB = imgByte;
file.ASSESSMENT_FINAL_FILE_NAME = files.FileName;
file.ASSESSMENT_FINAL_FILE_TYPE = GetFileExtension(files.FileName); /// files.ContentType;
file.ASSESSMENT_FINAL_SUBMIT_DATE = DateTime.Now;
break;
case "monledger":
file.LEDGER_MONTH_BLOB = imgByte;
file.LEDGER_MONTH_FILE_NAME = files.FileName;
file.LEDGER_MONTH_FILE_TYPE = GetFileExtension(files.FileName); /// files.ContentType;
file.LEDGER_MONTH_SUBMIT_DATE = DateTime.Now;
break;
case "breedessay":
// file.BREED_ESSAY = files.FileName;
file.BREED_RPT_BLOB = imgByte;
file.BREED_FILE_NAME = files.FileName;
file.BREED_FILE_TYPE = GetFileExtension(files.FileName);/// files.ContentType;
file.BREED_RPT_SUBMIT_DATE = DateTime.Now;
break;
case "yearendessay":
// file.YEAR_END_ESSAY = files.FileName;
file.YEAR_END_RPT_BLOB = imgByte;
file.YREND_FILE_NAME = files.FileName;
file.YREND_FILE_TYPE = GetFileExtension(files.FileName); //s.ContentType;
file.YREND_RPT_SUBMIT_DATE = DateTime.Now;
break;
}
}
cs.SaveChanges();
}
}
