private void btnDelete_Click(object sender, EventArgs e)
{
if (DialogResult.OK == MessageBox.Show("Are you want to delete " + txtCode.Text + " ?", "Confirmation!", MessageBoxButtons.OKCancel))
{
CCompanyBranch oCompanyBranch = GetFormData();
CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
CResult oResult = new CResult();
oResult = oCompanyBranchBO.Delete(oCompanyBranch);
if (oResult.IsSuccess)
{
if (oResult.Data.ToString() == "0")
{
MessageBox.Show("Deletion Not Possible", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFormData();
}
else
{
MessageBox.Show("Deleted successfully");
ClearFormData();
}
}
else
{
MessageBox.Show(oResult.ErrMsg);
}
LoadAllCompanyBranch();
}
}
private void LoadAllCompanyBranch()
{
lv_CCSDDSS.Items.Clear();
List <CCompanyBranch> oList;
CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
CResult oResult = new CResult();
oResult = oCompanyBranchBO.ReadAll();
if (oResult.IsSuccess)
{
oList = (List <CCompanyBranch>)oResult.Data;
Load_lv_CCSDDSS(oList);
}
}
private void LoadComapanyBranch()
{
CResult oResult = new CResult();
CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
oResult = oCompanyBranchBO.ReadAll();
if (oResult.IsSuccess)
{
cmbBranch.DataSource = oResult.Data as List <CCompanyBranch>;
cmbBranch.DisplayMember = "CompBrn_Code";
cmbBranch.ValueMember = "CompBrn_OId";
}
else
{
MessageBox.Show("Loading error...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
CCompanyBranch oCompanyBranch = GetFormData();
CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
CResult oResult = new CResult();
oResult = oCompanyBranchBO.Create(oCompanyBranch);
if (oResult.IsSuccess)
{
MessageBox.Show("Saved successfully");
}
else
{
MessageBox.Show(oResult.ErrMsg);
}
LoadAllCompanyBranch();
}
private void LoadReportBranch2()
{
CResult oResult = new CResult();
CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
oResult = oCompanyBranchBO.ReadAll();
if (oResult.IsSuccess)
{
ddlRptBranch2.DataSource = oResult.Data as List <CCompanyBranch>;
ddlRptBranch2.DisplayMember = "CompBrn_Code";
ddlRptBranch2.ValueMember = "CompBrn_OId";
ddlRptBranch2.SelectedValue = currentBranch.CompBrn_OId.Trim();
}
else
{
MessageBox.Show("Loading error...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
CCompanyBranch oCompanyBranch = GetFormData();
CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
CResult oResult = new CResult();
if (DialogResult.OK == MessageBox.Show("Are you want to delete " + txtCode.Text + " ?", "Confirmation!", MessageBoxButtons.OKCancel))
{
oResult = oCompanyBranchBO.Update(oCompanyBranch);
}
if (oResult.IsSuccess)
{
MessageBox.Show("Updated successfully");
}
else
{
MessageBox.Show(oResult.ErrMsg);
}
LoadAllCompanyBranch();
}
//private void LoadBranch()
//{
// // lvUserList.Items.Clear();
// CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
// CResult oResult = new CResult();
// CCompanyBranch oCompanyBranch = new CCompanyBranch();
// oResult = oCompanyBranchBO.ReadAll();
// if (oResult.IsSuccess)
// {
// foreach (CCompanyBranch obj in oResult.Data as ArrayList)
// {
// // ListViewItem oItem = new ListViewItem();
// ArrayList oItemList = oResult.Data as ArrayList;
// cmbBranch.DataSource = oItemList;
// cmbBranch.DisplayMember = "CompBrn_Name";
// cmbBranch.ValueMember = "CompBrn_Code";
// cmbBranch.SelectedIndex = -1;
// //oItem.Text = obj.CompBrn_Name.ToString();
// //oItem.SubItems.Add(obj.CompBrn_Code.ToString());
// // lvUserList.Items.Add(oItem);
// }
// //dgvUserList.DataSource = oResult.Data;
// }
// else
// {
// MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// }
//}
private void LoadAllBranch()
{
List <CCompanyBranch> oList;
CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
CResult oResult = new CResult();
oResult = oCompanyBranchBO.ReadAll();
if (oResult.IsSuccess)
{
oList = (List <CCompanyBranch>)oResult.Data;
//Load_lv_CCSDDSS(oList);
// ArrayList oEmployeeList = oResult.Data as ArrayList;
cmbBranch.DataSource = oList;
cmbBranch.DisplayMember = "CompBrn_Name";
cmbBranch.ValueMember = "CompBrn_OID";
cmbBranch.SelectedIndex = -1;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
CCompanyBranch oCompanyBranch = GetFormData();
CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
CResult oResult = new CResult();
if (validatedata())
{
if (txtOId.Text.Trim() != string.Empty)
{
if (DialogResult.OK == MessageBox.Show("Are you want to Update " + txtCode.Text + " ?", "Confirmation!", MessageBoxButtons.OKCancel))
{
oResult = oCompanyBranchBO.Update(oCompanyBranch);
}
}
else
{
if (!IsUpdateMode)
{
oResult = oCompanyBranchBO.Create(oCompanyBranch);
}
}
if (oResult.IsSuccess)
{
MessageBox.Show("Saved successfully");
}
else
{
//MessageBox.Show(oResult.ErrMsg);
MessageBox.Show("Not Saved" + oResult.ErrMsg + "");
}
ClearFormData();
LoadAllCompanyBranch();
}
}
private void ImportData()
{
string m_sMasterImportFileName = DateTime.Now.ToString("dd-MMM-yyyy") + "_" + currentBranch.CompBrn_Name;
openFileDialog1.FileName = m_sMasterImportFileName;
openFileDialog1.InitialDirectory = @"H:\";
openFileDialog1.Filter = "Master File (*.mstrexp)|*.mstrexp";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
m_sMasterImportFileName = openFileDialog1.FileName;
if (File.Exists(m_sMasterImportFileName))
{
IFormatter formatter = new BinaryFormatter();
using (Stream stream = new FileStream(m_sMasterImportFileName, FileMode.Open, FileAccess.Read, FileShare.None))
{
byte[] baKey = { 51, 208, 75, 59, 223, 134, 241, 155, 170, 229, 177, 160, 246, 71, 77, 141, 66, 7, 223, 103, 97, 80, 235, 82, 94, 107, 226, 190, 76, 94, 31, 43 };
byte[] baIV = { 142, 96, 41, 14, 206, 132, 173, 19, 12, 50, 124, 121, 42, 27, 35, 9 };
Rijndael rijndael = Rijndael.Create();
CryptoStream cryptoStream = new CryptoStream(stream, rijndael.CreateDecryptor(baKey, baIV), CryptoStreamMode.Read);
//
{
CResult oResult;
StringBuilder oErrBuilder = new StringBuilder();
try{
// UOM
ArrayList oListUOM = (ArrayList)formatter.Deserialize(cryptoStream);
// Item Type
ArrayList oListItemType = (ArrayList)formatter.Deserialize(cryptoStream);
// Item Group
ArrayList oListItemGroup = (ArrayList)formatter.Deserialize(cryptoStream);
// Item
ArrayList oListItem = (ArrayList)formatter.Deserialize(cryptoStream);
// Reorder Level
ArrayList oListReorderLevel = (ArrayList)formatter.Deserialize(cryptoStream);
// Currency
List <CCurrency> oListCurrency = (List <CCurrency>)formatter.Deserialize(cryptoStream);
// Price Master
ArrayList oListPriceMaster = (ArrayList)formatter.Deserialize(cryptoStream);
// Customer
ArrayList oListCustomer = (ArrayList)formatter.Deserialize(cryptoStream);
// Supplier
ArrayList oListSupplier = (ArrayList)formatter.Deserialize(cryptoStream);
// Company
List <CCompany> oListCompany = (List <CCompany>)formatter.Deserialize(cryptoStream);
// Company Branch
List <CCompanyBranch> oListCompanyBranch = (List <CCompanyBranch>)formatter.Deserialize(cryptoStream);
// Company Vs CompanyBranch
ArrayList oListCVB = (ArrayList)formatter.Deserialize(cryptoStream);
// Inventory Location
ArrayList oListLocation = (ArrayList)formatter.Deserialize(cryptoStream);
// CompanyBranch Vs Location
ArrayList oListBVL = (ArrayList)formatter.Deserialize(cryptoStream);
// Employee
ArrayList oListEmployee = (ArrayList)formatter.Deserialize(cryptoStream);
// User
ArrayList oListUser = (ArrayList)formatter.Deserialize(cryptoStream);
//Import UOM
oResult = new CResult();
CUOMBO oUOMBO = new CUOMBO();
foreach (CUOM oUOM in oListUOM)
{
oResult = oUOMBO.Import(oUOM);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("UOM : " + oResult.ErrMsg + "/n");
}
}
//Import Itemtyps
oResult = new CResult();
CItemBO oItemBO = new CItemBO();
foreach (CItemType oItemType in oListItemType)
{
oResult = oItemBO.Import(oItemType);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Item Type : " + oResult.ErrMsg + "\n");
}
}
//Item Group
oResult = new CResult();
foreach (CItemGroup oItemGroup in oListItemGroup)
{
oResult = oItemBO.Import(oItemGroup);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Item Type : " + oResult.ErrMsg + "/n");
}
}
// Import Item with images
oResult = new CResult();
foreach (CItem oItem in oListItem)
{
oResult = oItemBO.Import(oItem);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Item : " + oResult.ErrMsg + "/n");
}
}
// Reorder Level
oResult = new CResult();
CReorderLevelBO oReorderLevelBO = new CReorderLevelBO();
foreach (CReorderLevel oReorderLevel in oListReorderLevel)
{
oResult = oReorderLevelBO.Import(oReorderLevel);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("ReorderLevel : " + oResult.ErrMsg + "/n");
}
}
// IMPORT CURRENCY
oResult = new CResult();
CCurrencyBO oCurrencyBO = new CCurrencyBO();
foreach (CCurrency oCurrency in oListCurrency)
{
oResult = oCurrencyBO.Import(oCurrency);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Currency : " + oResult.ErrMsg + "/n");
}
}
// Import Pricemaster
oResult = new CResult();
CPriceMasterBO oPriceMasterBO = new CPriceMasterBO();
foreach (CPriceMaster oPriceMaster in oListPriceMaster)
{
oResult = oPriceMasterBO.Import(oPriceMaster);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Price : " + oResult.ErrMsg + "/n");
}
}
// Import Customer
oResult = new CResult();
CCustomerBO oCustomerBO = new CCustomerBO();
foreach (CCustomer oCustomer in oListCustomer)
{
oResult = oCustomerBO.Import(oCustomer);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Customer : " + oResult.ErrMsg + "/n");
}
}
// Import supplier
oResult = new CResult();
CSupplierBO oSupplierBO = new CSupplierBO();
foreach (CSupplier oSupplier in oListSupplier)
{
oResult = oSupplierBO.Import(oSupplier);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Supplier : " + oResult.ErrMsg + "/n");
}
}
// Import company
oResult = new CResult();
CCompanyBO oCompanyBO = new CCompanyBO();
foreach (CCompany oCompany in oListCompany)
{
oResult = oCompanyBO.Import(oCompany);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Company : " + oResult.ErrMsg + "/n");
}
}
// Import company branch
oResult = new CResult();
CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
foreach (CCompanyBranch oCompanyBranch in oListCompanyBranch)
{
oResult = oCompanyBranchBO.Import(oCompanyBranch);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Company Branch: " + oResult.ErrMsg + "/n");
}
}
//Company Vs CompanyBranch
oResult = new CResult();
CCVBBO oCVBBO = new CCVBBO();
foreach (CCVB oCVB in oListCVB)
{
oResult = oCVBBO.Import(oCVB);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Company Vs CompanyBranch : " + oResult.ErrMsg + "/n");
}
}
// Import Location
oResult = new CResult();
CLocBO oLocBO = new CLocBO();
foreach (CLocation oLocation in oListLocation)
{
oResult = oLocBO.Import(oLocation);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Inventory location: " + oResult.ErrMsg + "/n");
}
}
// Import CompanyBranch Vs Location
oResult = new CResult();
foreach (CCVB oCVB in oListBVL)
{
oResult = oCVBBO.ImportBVL(oCVB);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("CompanyBranch Vs Location : " + oResult.ErrMsg + "/n");
}
}
// Import Employee
oResult = new CResult();
CEmployeeBO oEmployeeBO = new CEmployeeBO();
foreach (CEmployee oEmployee in oListEmployee)
{
oResult = oEmployeeBO.Import(oEmployee);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("Employee : " + oResult.ErrMsg + "/n");
}
}
// Import User
oResult = new CResult();
CUserBO oUserBO = new CUserBO();
foreach (CUser oUser in oListUser)
{
oResult = oUserBO.Import(oUser);
if (!oResult.IsSuccess)
{
oErrBuilder.Append("User : "******"/n");
}
}
if (oErrBuilder.Length != 0)
{
MessageBox.Show(oErrBuilder.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Successfully Imported. ", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//
cryptoStream.Close();
}
}
}
}
}
private void ExportData()
{
string m_sMasterExportFileName = DateTime.Now.ToString("dd-MMM-yyyy") + "_" + currentBranch.CompBrn_Name;
saveFileDialog1.FileName = m_sMasterExportFileName;
saveFileDialog1.InitialDirectory = @"H:\";
saveFileDialog1.Filter = "Master File (*.mstrexp)|*.mstrexp";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
m_sMasterExportFileName = saveFileDialog1.FileName;
IFormatter formatter = new BinaryFormatter();
using (Stream stream = new FileStream(m_sMasterExportFileName, FileMode.Create, FileAccess.Write, FileShare.None))
{
byte[] baKey = { 51, 208, 75, 59, 223, 134, 241, 155, 170, 229, 177, 160, 246, 71, 77, 141, 66, 7, 223, 103, 97, 80, 235, 82, 94, 107, 226, 190, 76, 94, 31, 43 };
byte[] baIV = { 142, 96, 41, 14, 206, 132, 173, 19, 12, 50, 124, 121, 42, 27, 35, 9 };
Rijndael rijndael = Rijndael.Create();
CryptoStream cryptoStream = new CryptoStream(stream, rijndael.CreateEncryptor(baKey, baIV), CryptoStreamMode.Write);
//
{
CResult oResult;
// UOM
oResult = new CResult();
CUOMBO oUOMBO = new CUOMBO();
oResult = oUOMBO.ReadAll();
if (oResult.IsSuccess)
{
ArrayList oListUOM = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListUOM);
}
// Item Type
oResult = new CResult();
CItemBO oItemBO = new CItemBO();
oResult = oItemBO.ReadAll(new CItemType());
if (oResult.IsSuccess)
{
ArrayList oListItemType = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListItemType);
}
// Item Group
oResult = new CResult();
oItemBO = new CItemBO();
oResult = oItemBO.ReadAll(new CItemGroup());
if (oResult.IsSuccess)
{
ArrayList oListItemGroup = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListItemGroup);
}
// Item
oResult = new CResult();
oItemBO = new CItemBO();
oResult = oItemBO.ReadAll();
if (oResult.IsSuccess)
{
ArrayList oListItem = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListItem);
}
// Reorder Level
oResult = new CResult();
CReorderLevelBO oReorderLevelBO = new CReorderLevelBO();
oResult = oReorderLevelBO.ReadAllReorderLevelData(new CReorderLevel());
if (oResult.IsSuccess)
{
ArrayList oListReorderLevel = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListReorderLevel);
}
// Currency
oResult = new CResult();
CCurrencyBO oCurrencyBO = new CCurrencyBO();
oResult = oCurrencyBO.ReadAll();
if (oResult.IsSuccess)
{
List <CCurrency> oListCurrency = (List <CCurrency>)oResult.Data;
formatter.Serialize(cryptoStream, oListCurrency);
}
// Price Master
oResult = new CResult();
CPriceMasterBO oPriceMasterBO = new CPriceMasterBO();
oResult = oPriceMasterBO.ReadAll();
if (oResult.IsSuccess)
{
ArrayList oListPriceMaster = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListPriceMaster);
}
// Customer
oResult = new CResult();
CCustomerBO oCustomerBO = new CCustomerBO();
oResult = oCustomerBO.ReadAll(new CCustomer());
if (oResult.IsSuccess)
{
ArrayList oListCustomer = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListCustomer);
}
// Supplier
oResult = new CResult();
CSupplierBO oSupplierBO = new CSupplierBO();
oResult = oSupplierBO.ReadAll(new CSupplier());
if (oResult.IsSuccess)
{
ArrayList oListSupplier = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListSupplier);
}
// Company
oResult = new CResult();
CCompanyBO oCompanyBO = new CCompanyBO();
oResult = oCompanyBO.ReadAll();
if (oResult.IsSuccess)
{
List <CCompany> oListCompany = (List <CCompany>)oResult.Data;
formatter.Serialize(cryptoStream, oListCompany);
}
// Company Branch
oResult = new CResult();
CCompanyBranchBO oCompanyBranchBO = new CCompanyBranchBO();
oResult = oCompanyBranchBO.ReadAll();
if (oResult.IsSuccess)
{
List <CCompanyBranch> oListCompanyBranch = (List <CCompanyBranch>)oResult.Data;
formatter.Serialize(cryptoStream, oListCompanyBranch);
}
// Company Vs CompanyBranch
oResult = new CResult();
CCVBBO oCVBBO = new CCVBBO();
oResult = oCVBBO.ReadAllCVB(new CCVB());
if (oResult.IsSuccess)
{
ArrayList oListCVB = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListCVB);
}
// Inventory Location
oResult = new CResult();
CLocBO oLocBO = new CLocBO();
oResult = oLocBO.ReadAll();
if (oResult.IsSuccess)
{
ArrayList oListLocation = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListLocation);
}
// CompanyBranch Vs Location
oResult = new CResult();
oCVBBO = new CCVBBO();
oResult = oCVBBO.ReadAllBVL(new CCVB());
if (oResult.IsSuccess)
{
ArrayList oListCVB = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListCVB);
}
// Employee
oResult = new CResult();
CEmployeeBO oEmployeeBO = new CEmployeeBO();
oResult = oEmployeeBO.ReadAllEmployee(new CEmployee());
if (oResult.IsSuccess)
{
ArrayList oListEmployee = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListEmployee);
}
// User
oResult = new CResult();
CUserBO oUserBO = new CUserBO();
oResult = oUserBO.ReadAllUserData(new CUser());
if (oResult.IsSuccess)
{
ArrayList oListUser = (ArrayList)oResult.Data;
formatter.Serialize(cryptoStream, oListUser);
}
}
//
cryptoStream.Close();
}
}
this.Close();
}
