public List <string> syncColumnValues(DaftarTable daftar, Int64 syncValue) { try { DaftarModelDataContext db = new DaftarModelDataContext(cn); var data = from a in db.DaftarTables.Where(x => x.Id == daftar.Id) select a; List <string> list = new List <string>(); list.Add("شناسه های "); foreach (var a in data) { a.DepositDetail = daftar.DepositDetail; a.CodeBudget = daftar.CodeBudget; list.Add(a.Id.ToString() + " " + a.DepositOwnerDetail.ToString() + " با موفقیت بروزرسانی شد "); } db.SubmitChanges(); return(list); } catch (Exception ex) { MessageBox.Show(ex.Message); List <string> list = new List <string>(); Reporter rpt = new Reporter(list, (int)errorImages.info); rpt.Show(); return(list); } }
private IQueryable <DaftarTable> ConvertElementToQuery(XElement data) { var d = data.Elements(); List <DaftarTable> listData = new List <DaftarTable>(); try { foreach (var a in d) { DaftarTable readXml = new DaftarTable(); readXml.AccountType = a.Element("AccountType").Value; readXml.BillDetailCode = Convert.ToInt64(a.Element("BillDetailCode").Value); readXml.CityID = Convert.ToInt64(a.Element("CityID").Value); readXml.CodeBudget = Convert.ToInt64(a.Element("CodeBudget").Value); readXml.Date = a.Element("Date").Value; readXml.Deposit = Convert.ToInt64(a.Element("Deposit").Value); readXml.DepositDetail = Convert.ToInt64(a.Element("DepositDetail").Value); readXml.DepositOwnerDetail = a.Element("DepositOwnerDetail").Value; readXml.PlaceName = a.Element("PlaceName").Value; readXml.Refund = Convert.ToInt64(a.Element("Refund").Value); readXml.RealDate = Convert.ToInt64(a.Element("RealDate").Value); readXml.Id = Convert.ToInt64(a.Element("Id").Value); listData.Add(readXml); } return(listData.AsQueryable()); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(listData.AsQueryable()); } }
public List <String> addRow(DaftarTable daftar) { try { List <string> report = new List <string>(); DaftarModelDataContext db = new DaftarModelDataContext(cn); db.DaftarTables.InsertOnSubmit(daftar); db.SubmitChanges(); string person = daftar.Id.ToString() + " " + daftar.DepositOwnerDetail.ToString(); report.Add(" با موفقیت اضافه گردید" + " " + person); return(report); } //duplicate record catch (System.Data.SqlClient.SqlException) { // MessageBox.Show(ex.ToString()); // DaftarModelDataContext db = new DaftarModelDataContext(cn); List <string> report = new List <string>(); report.Add(daftar.Id + "" + " شناسه تکراری است . تاریخ یا کد سپرده می بایست متفاوت باشد"); return(report); } //catch (Exception ex) //{ // //MessageBox.Show(ex.Message); // return false; //} }
private void NoteBookDataGridView_SelectionChanged_1(object sender, EventArgs e) { dataForchanging.Clear(); foreach (DataGridViewRow row in NoteBookDataGridView.SelectedRows) { try { DaftarTable data = new DaftarTable(); data.Id = Convert.ToInt64(row.Cells[0].Value); data.Refund = Convert.ToInt64(row.Cells[1].Value); data.BillDetailCode = Convert.ToInt64(row.Cells[2].Value); data.Date = row.Cells[3].Value.ToString(); data.PlaceName = row.Cells[4].Value.ToString(); data.AccountType = row.Cells[5].Value.ToString(); data.DepositOwnerDetail = row.Cells[6].Value.ToString(); data.DepositDetail = Convert.ToInt64(row.Cells[7].Value); data.Deposit = Convert.ToInt64(row.Cells[8].Value); data.CodeBudget = Convert.ToInt64(row.Cells[9].Value); data.CityID = Convert.ToInt64(row.Cells[10].Value); data.RealDate = Convert.ToInt64(row.Cells[11].Value); dataForchanging.Add(data); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }
private void editButton_Click(object sender, EventArgs e) { try { if (!inputValidation()) { return; } Utility utl = new Utility(); SqlManipulator sql = new SqlManipulator(); DaftarTable newDaftar = new DaftarTable(); if (login.permission) { var itm = (ComboboxItem)placeComboBox.SelectedItem; login.cityID = itm.Value; } else { newDaftar.CityID = login.cityID; } newDaftar.Id = data.Id; //var item = (ComboboxItem)placeComboBox.SelectedItem; //newDaftar.CityID = item.Value; newDaftar.Refund = Convert.ToInt64(this.refundTextBox.Text); newDaftar.AccountType = this.AccountTypeComboBox.SelectedItem.ToString(); // newDaftar.BillDetailCode = Convert.ToInt64(this.billDetailCodetextBox.Text); newDaftar.CodeBudget = Convert.ToInt64(this.BudgetCodetextBox.Text); //newDaftar.Date = this.dateMaskedTextBox.Text; newDaftar.PlaceName = placeComboBox.SelectedItem.ToString(); // newDaftar.RealDate = utl.changeToRealDate(newDaftar.Date); newDaftar.Deposit = Convert.ToInt64(this.DepositTextBox.Text); newDaftar.RealDate = data.RealDate; newDaftar.DepositDetail = Convert.ToInt64(this.DepositDetailtextBox.Text); newDaftar.DepositOwnerDetail = this.DepositOwnerDetailTextBox.Text; newDaftar.CityID = data.CityID; if (sql.isRestricted(newDaftar, login.permission)) { MessageBox.Show("دسترسی شما به این تاریخ توسط مدیر سیستم محدود شده است", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } ; Reporter rpt = new Reporter(sql.update(newDaftar, godmode), (int)errorImages.info); rpt.Show(); form.refreshLastState(lastState, pageNumber, false); this.Hide(); } catch (Exception ex) { MessageBox.Show("ورودی های خود را کنترل نمائید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); MessageBox.Show(ex.Message); } }
public EditForm(DaftarTable data, MainForm form, LoginInfo login, bool godmode, int pageNumber, LasteStateClass lastState) { InitializeComponent(); this.data = data; this.form = form; this.pageNumber = pageNumber; this.lastState = lastState; this.godmode = godmode; this.login = login; }
public AddEditForm(LoginInfo login, MainForm form, bool addCopiedRow, DaftarTable data, int pageNumber, LasteStateClass lastState) { InitializeComponent(); this.login = login; this.form = form; this.data = data; this.lastState = lastState; this.AccountTypeComboBox.SelectedIndex = 0; this.pageNumber = pageNumber; this.copy = addCopiedRow; setPlaceComboBox(); }
public Boolean isRestricted(DaftarTable data, bool permission) { try { if (permission) { return(false); } ValidationDataClassesDataContext db = new ValidationDataClassesDataContext(cn); var valid = (from c in db.validationTables.Where(x => x.City == data.CityID && data.RealDate >= x.startDate && data.RealDate <= x.enDate) select c).Any(); return(valid); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public List <string> update(DaftarTable daftar, bool godmode) { try { DaftarModelDataContext db = new DaftarModelDataContext(cn); var data = from a in db.DaftarTables.Where(x => x.Id == daftar.Id) select a; List <string> list = new List <string>(); list.Add("شناسه های "); foreach (var a in data) { if ((Math.Abs(Convert.ToInt64(a.Refund))) > 0 && !godmode) { list.Add(a.Id.ToString() + " " + a.DepositOwnerDetail.ToString() + " استرداد شده است! غیر قابل ویرایش می باشد "); } else { a.Id = daftar.Id; //a.PlaceName = daftar.PlaceName; //a.CityID = daftar.CityID; a.Refund = daftar.Refund; //a.Date = daftar.Date; a.Deposit = daftar.Deposit; a.DepositDetail = daftar.DepositDetail; a.DepositOwnerDetail = daftar.DepositOwnerDetail; a.CodeBudget = daftar.CodeBudget; a.AccountType = daftar.AccountType; // a.RealDate = daftar.RealDate; // a.BillDetailCode = daftar.BillDetailCode; list.Add(a.Id.ToString() + " " + a.DepositOwnerDetail.ToString() + " با موفقیت بروزرسانی شد "); } } db.SubmitChanges(); return(list); } catch (Exception ex) { MessageBox.Show(ex.Message); List <string> list = new List <string>(); Reporter rpt = new Reporter(list, (int)errorImages.info); rpt.Show(); return(list); } }
public Boolean excelToSqlCopy(IQueryable <Daftarcs> excelQuery, long cityID) { try { Utility utl = new Utility(); DaftarModelDataContext db = new DaftarModelDataContext(cn); List <DaftarTable> listDaftar = new List <DaftarTable>(); foreach (var row in excelQuery) { DaftarTable newDaftar = new DaftarTable(); newDaftar.DepositOwnerDetail = row.DepositOwnerDetail; newDaftar.PlaceName = row.PlaceName; newDaftar.AccountType = row.AccountType; newDaftar.Date = row.Date; newDaftar.RealDate = utl.changeToRealDate(newDaftar.Date); newDaftar.BillDetailCode = Convert.ToInt64(row.BillDetailCode); newDaftar.CodeBudget = Convert.ToInt64(row.CodeBudget); newDaftar.Deposit = Convert.ToInt64(row.Deposit); newDaftar.DepositDetail = Convert.ToInt64(row.DepositDetail); newDaftar.Refund = Convert.ToInt64(row.Refund); newDaftar.Id = utl.idGenerator(cityID, newDaftar.Date, newDaftar.BillDetailCode); newDaftar.CityID = cityID; listDaftar.Add(newDaftar); } db.BulkInsertAll(listDaftar); excelQuery = null; return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public MapClassToPersianClass(DaftarTable t) { }
partial void DeleteDaftarTable(DaftarTable instance);
partial void UpdateDaftarTable(DaftarTable instance);
partial void InsertDaftarTable(DaftarTable instance);
public List <string> refundFromFile(IQueryable <Daftarcs> excelQuery, long cityID) { try { List <string> report = new List <string>(); Utility utl = new Utility(); DaftarModelDataContext db = new DaftarModelDataContext(cn); List <DaftarTable> listDaftar = new List <DaftarTable>(); StartEndMonthClass date = findMinMaxInQuery(excelQuery); foreach (var row in excelQuery) { DaftarTable newDaftar = new DaftarTable(); newDaftar.DepositOwnerDetail = row.DepositOwnerDetail; newDaftar.PlaceName = row.PlaceName; newDaftar.AccountType = row.AccountType; newDaftar.Date = row.Date; newDaftar.RealDate = utl.changeToRealDate(newDaftar.Date); newDaftar.BillDetailCode = Convert.ToInt64(row.BillDetailCode); newDaftar.CodeBudget = Convert.ToInt64(row.CodeBudget); newDaftar.Deposit = Convert.ToInt64(row.Deposit); newDaftar.DepositDetail = Convert.ToInt64(row.DepositDetail); newDaftar.Refund = Convert.ToInt64(row.Refund); newDaftar.Id = utl.idGenerator(cityID, newDaftar.Date, newDaftar.BillDetailCode); newDaftar.CityID = cityID; listDaftar.Add(newDaftar); } var query = listDaftar.AsQueryable(); var search = (from c in db.DaftarTables.Where(x => x.CityID == cityID && x.RealDate >= date.startDate && x.RealDate <= date.endDate) select c); foreach (var b in query) { bool refunded = false; foreach (var a in search) { if (a.Id == b.Id) { if (b.Refund != 0 && b.Deposit == 0 && a.Refund == 0) { a.Refund = a.Deposit; a.Deposit = 0; report.Add(a.DepositOwnerDetail + " " + a.Id + "استرداد شد"); refunded = true; } } } if (!refunded) { report.Add(b.DepositOwnerDetail + " " + b.Id + "خطا در استرداد"); } } db.SubmitChanges(); excelQuery = null; return(report); } catch (Exception ex) { string exp = "خطا"; List <string> report = new List <string>(); report.Add(ex.ToString()); report.Add(exp); return(report); } }