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 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 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 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 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 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(); } }