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