private void SaveItem(object sender, EventArgs e) { if (CustomValidation()) { var item = new Customer(); item.FullName = textFullName.Text; item.Address1 = textAddress1.Text; item.Address2 = textAddress2.Text; item.City = Convert.ToString(drlCity.SelectedItem); item.Segment = Convert.ToString(drlSegment.SelectedItem); item.SMS = textTenSms.Text; item.PostalCode = textPostalCode.Text; item.Tel = textTel.Text; item.Mobile1 = textMobile1.Text; item.Mobile2 = textMobile2.Text; item.Email1 = textEmail1.Text; item.Email2 = textEmail2.Text; if (!string.IsNullOrEmpty(numberDelivery.Text)) { item.Delivery = Convert.ToInt32(numberDelivery.Text); } item.OtherInformation = textOtherInformation.Text; item.Company = txtCompany.Text; item.Mst = textMst.Text; if (itemId > 0) { item.Id = itemId; item.Created = created; item.CreatedByUserId = createdBy; item.Modified = DateTime.Now; item.ModifiedByUserId = currentUser; var biz = new CustomerBiz(); biz.UpdateItem(item); } else { item.Created = DateTime.Now; item.CreatedByUserId = currentUser; item.Modified = DateTime.Now; item.ModifiedByUserId = currentUser; var biz = new CustomerBiz(); biz.SaveItem(item); } this.Close(); } else { this.DialogResult = DialogResult.None; } }
private void ExportDataSet(string fileName) { var biz = new CustomerBiz(); using (var document = SpreadsheetDocument.Open(fileName, false)) { var wbPart = document.WorkbookPart; Sheet theSheet = wbPart.Workbook.Descendants <Sheet>().FirstOrDefault(); var wsPart = (WorksheetPart)(wbPart.GetPartById(theSheet.Id)); var customerListing = new List <CustomerItem>(); for (var i = 2; i <= wsPart.Worksheet.Descendants <Row>().Count(); i++) { int number = 0; var item = new Customer { SMS = IOReader.GetCellValue(document, theSheet, "B" + i), FullName = IOReader.GetCellValue(document, theSheet, "C" + i), Mst = IOReader.GetCellValue(document, theSheet, "D" + i), Company = IOReader.GetCellValue(document, theSheet, "E" + i), Address1 = IOReader.GetCellValue(document, theSheet, "F" + i), Address2 = IOReader.GetCellValue(document, theSheet, "G" + i), City = IOReader.GetCellValue(document, theSheet, "H" + i), PostalCode = IOReader.GetCellValue(document, theSheet, "I" + i), Tel = IOReader.GetCellValue(document, theSheet, "J" + i), Mobile1 = IOReader.GetCellValue(document, theSheet, "K" + i), Mobile2 = IOReader.GetCellValue(document, theSheet, "L" + i), Email1 = IOReader.GetCellValue(document, theSheet, "M" + i), Email2 = IOReader.GetCellValue(document, theSheet, "N" + i), OtherInformation = IOReader.GetCellValue(document, theSheet, "P" + i), Segment = IOReader.GetCellValue(document, theSheet, "Q" + i), }; var delivery = IOReader.GetCellValue(document, theSheet, "O" + i); if (!string.IsNullOrEmpty(delivery) && int.TryParse(delivery, out number)) { item.Delivery = number; } if (!string.IsNullOrEmpty(item.FullName)) { biz.SaveItem(item); } } } }
private void btnInsert_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in dataGridView.Rows) { var isChecked = Convert.ToBoolean(row.Cells["cbo"].Value); if (isChecked) { var item = new Customer(); item.SMS = Convert.ToString(row.Cells["Mr"].Value); item.FullName = Convert.ToString(row.Cells["FirstName"].Value); item.Address1 = Convert.ToString(row.Cells["Address1"].Value); item.Address2 = Convert.ToString(row.Cells["Address2"].Value); item.City = Convert.ToString(row.Cells["City"].Value); item.Segment = Convert.ToString(row.Cells["Segment"].Value); item.PostalCode = Convert.ToString(row.Cells["PostalCode"].Value); item.Tel = Convert.ToString(row.Cells["Tel"].Value); item.Mobile1 = Convert.ToString(row.Cells["Mobile1"].Value); item.Mobile2 = Convert.ToString(row.Cells["Mobile2"].Value); item.Email1 = Convert.ToString(row.Cells["Email1"].Value); item.Email2 = Convert.ToString(row.Cells["Email2"].Value); var delivery = Convert.ToString(row.Cells["Delivery"].Value); if (!string.IsNullOrEmpty(delivery)) { item.Delivery = Convert.ToInt32(delivery); } item.OtherInformation = Convert.ToString(row.Cells["OtherInformation"].Value); item.Created = DateTime.Now; item.CreatedByUserId = currentUser; item.Modified = DateTime.Now; item.ModifiedByUserId = currentUser; var biz = new CustomerBiz(); biz.SaveItem(item); } } FireEvent(); Close(); }
private void ExportDataSet(string fileName) { var biz = new CustomerBiz(); using (var document = SpreadsheetDocument.Open(fileName, false)) { var wbPart = document.WorkbookPart; Sheet theSheet = wbPart.Workbook.Descendants<Sheet>().FirstOrDefault(); var wsPart = (WorksheetPart)(wbPart.GetPartById(theSheet.Id)); var customerListing = new List<CustomerItem>(); for (var i = 2; i <= wsPart.Worksheet.Descendants<Row>().Count(); i++) { int number = 0; var item = new Customer { SMS = IOReader.GetCellValue(document, theSheet, "B" + i), FullName = IOReader.GetCellValue(document, theSheet, "C" + i), Mst = IOReader.GetCellValue(document, theSheet, "D" + i), Company = IOReader.GetCellValue(document, theSheet, "E" + i), Address1 = IOReader.GetCellValue(document, theSheet, "F" + i), Address2 = IOReader.GetCellValue(document, theSheet, "G" + i), City = IOReader.GetCellValue(document, theSheet, "H" + i), PostalCode = IOReader.GetCellValue(document, theSheet, "I" + i), Tel = IOReader.GetCellValue(document, theSheet, "J" + i), Mobile1 = IOReader.GetCellValue(document, theSheet, "K" + i), Mobile2 = IOReader.GetCellValue(document, theSheet, "L" + i), Email1 = IOReader.GetCellValue(document, theSheet, "M" + i), Email2 = IOReader.GetCellValue(document, theSheet, "N" + i), OtherInformation = IOReader.GetCellValue(document, theSheet, "P" + i), Segment = IOReader.GetCellValue(document, theSheet, "Q" + i), }; var delivery = IOReader.GetCellValue(document, theSheet, "O" + i); if (!string.IsNullOrEmpty(delivery) && int.TryParse(delivery, out number)) { item.Delivery = number; } if (!string.IsNullOrEmpty(item.FullName)) { biz.SaveItem(item); } } } }