private void GetItemCode()
{
string strItemCode = string.Empty;
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
oresult = oitembo.ReadAllByCond(ddlGroupNAme.SelectedValue.ToString());
ArrayList oitemlist = (ArrayList)oresult.Data;
int maxitemrow = oitemlist.Count;
if (maxitemrow == 0)
{
strItemCode = ((CItemGroup)ddlGroupNAme.SelectedItem).Catg_Code.ToString() + "00001";
}
else
{
CItem oitem2 = (CItem)oitemlist[maxitemrow - 1];
strItemCode = ((CItemGroup)ddlGroupNAme.SelectedItem).Catg_Code.Substring(0, 4);
string strCode = "" + Convert.ToString(Convert.ToInt32(oitem2.Item_Code.Substring(4)) + 1);
for (int j = 5; j > (strCode.Length); j--)
{
strItemCode += "0";
}
strItemCode += strCode;
}
txtItemCode.Text = strItemCode;
}
private void btnExport_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Title = "Save an CSV File";
saveFileDialog1.FileName = "ItemExport.csv";
saveFileDialog1.Filter = "Text files (*.csv)|*.csv|All files (*.*)|*.*";
saveFileDialog1.ShowDialog();
string url = "";
if (saveFileDialog1.FileName != "")
{
url = saveFileDialog1.FileName;
}
else
{
url = "ItemExport.csv";
}
CItemBO item = new CItemBO();
DataTable dt = item.ReadAllItemWithGroup();
string sb = dt.ToCSV();
File.WriteAllText(url, sb, Encoding.Default);
MessageBox.Show("File export sucessfully done");
//csv.Export();
//csv.ExportToFile(url);
}
private void LoadItem()
{
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
oresult = oitembo.ReadAll();
if (oresult.IsSuccess)
{
//ddlItemType.Items.Add(new ListItem("Select one Item","NA"));
ArrayList oItemList = oresult.Data as ArrayList;
cmbItemName.DataSource = oItemList;
cmbItemName.DisplayMember = "Item_ItemName";
cmbItemName.ValueMember = "Item_OId";
cmbItemName.SelectedIndex = -1;
//foreach (CItemType oitemtype1 in oresult.Data as ArrayList)
//{
// ddlItemType.Items.Add(new ListItem(oitemtype1.TypeName, oitemtype.TypeID.ToString()));
//}
}
else
{
cmbItemName.Text = "ERROR in loading";
}
}
private void BindItemListView()
{
lvItemName.Items.Clear();
CItemBO oItemBO = new CItemBO();
CResult oResult = new CResult();
List <CItemSales> oItemList = new List <CItemSales>();
oResult = oItemBO.ReadAllForStickerByBranch(dtpFromDate.Value.Date, dtpToDate.Value.Date, currentBranch.CompBrn_Branch);
if (oResult.IsSuccess)
{
oItemList = (List <CItemSales>)oResult.Data;
if (oItemList != null)
{
int i = 0;
foreach (CItemSales oItemSales in oItemList)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = (i + 1).ToString("00");
lvi.SubItems.Add(oItemSales.Item_Code);
lvi.SubItems.Add(oItemSales.Item_ItemName);
lvi.SubItems.Add(oItemSales.TotalItem.ToString());
lvi.SubItems.Add(oItemSales.Item_Price.ToString());
lvi.Tag = oItemSales;
lvItemName.Items.Add(lvi);
i++;
}
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
CItemGroup oItemGroup = Getformdata();
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
if (validatedata())
{
if ((MessageBox.Show("Do u really want to delete this item. ", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)) == DialogResult.Yes)
{
oresult = oitembo.Delete(oItemGroup);
}
if (oresult.IsSuccess == true)
{
if (oresult.Data.ToString() == "0")
{
MessageBox.Show("Deletion Not Possible", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadGroupType();
Clearformdata();
}
else
{
MessageBox.Show("Deleted Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadGroupType();
Clearformdata();
}
}
else
{
MessageBox.Show("Error" + oresult.ErrMsg + "");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
CItemGroup oItemGroup = Getformdata();
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
if (validatedata())
{
if (txtGroupid.Text.Trim() != string.Empty)
{
if (DialogResult.OK == MessageBox.Show("Are you wanted to upadte " + txtCode.Text + " ?", "Confirmation!", MessageBoxButtons.OKCancel))
{
oresult = oitembo.Update(oItemGroup);
}
}
else
{
oresult = oitembo.Create(oItemGroup);
}
if (oresult.IsSuccess)
{
LoadGroupType();
Clearformdata();
}
else
{
MessageBox.Show("Not Saved" + oresult.ErrMsg + "");
// MessageBox.Show(oresult.ErrMsg, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void populatetreenode()
{
LoadUOMType();
LoadItemType();
LoadGroupType();
treeView1.Nodes.Clear();
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
oresult = oitembo.ReadAll();
foreach (CItemGroup oitemGroup in ddlGroupNAme.DataSource as ArrayList)
{
System.Windows.Forms.TreeNode root = new System.Windows.Forms.TreeNode(oitemGroup.Catg_Code);
this.treeView1.Nodes.Add(root);
if (oresult.IsSuccess)
{
foreach (CItem oitem1 in oresult.Data as ArrayList)
{
System.Windows.Forms.TreeNode childnode = new System.Windows.Forms.TreeNode(oitem1.Item_ItemName);
if (oitemGroup.Catg_OID == oitem1.Item_GroupID)
{
root.Nodes.Add(childnode);
}
}
}
}
}
private void LoadItemData()
{
CResult oResult = new CResult();
CItemBO oItemBO = new CItemBO();
oResult = oItemBO.ReadAll();
if (oResult.IsSuccess)
{
arrItemList = oResult.Data as ArrayList;
}
else
{
MessageBox.Show("Loading error...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void BindItemName()
{
CItemBO oItemBO = new CItemBO();
CResult oResult = new CResult();
oResult = oItemBO.ReadAllFGForSalesByBranch(currentBranch.CompBrn_OId);
if (oResult.IsSuccess)
{
oItemList = (List <CItemSales>)oResult.Data;
foreach (CItemSales objItem in oItemList)
{
cmbItemName.Items.Add(objItem);
}
cmbItemName.DisplayMember = "Item_ItemName";
}
}
private void LoadSizeName()
{
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
oresult = oitembo.ReadAllItemSize();
if (oresult.IsSuccess)
{
LLSIZEType.DataSource = oresult.Data;
LLSIZEType.DisplayMember = "Size_Name";
LLSIZEType.ValueMember = "Size_OID";
}
else
{
MessageBox.Show(oresult.ErrMsg);
}
}
private void LoadItemSize()
{
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
oresult = oitembo.ReadAllItemSize();
if (oresult.IsSuccess)
{
cmbItemSize.DataSource = oresult.Data;
cmbItemSize.DisplayMember = "Size_Name";
//cmbItemSize.ValueMember = "Size_OID";
cmbItemSize.SelectedIndex = -1;
}
else
{
ddlUOM.Text = "ERROR in loading";
}
}
private void LoadItemType()
{
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
CItemType oitemtype = new CItemType();
oresult = oitembo.ReadAll(oitemtype);
if (oresult.IsSuccess)
{
ArrayList oItemList = oresult.Data as ArrayList;
ddlItemType.DataSource = oItemList;
ddlItemType.DisplayMember = "ITyp_Code";
ddlItemType.ValueMember = "ITyp_OID";
ddlItemType.SelectedIndex = 0;
}
else
{
ddlItemType.Text = "ERROR in loading";
}
}
private void LoadItemCategoryData()
{
CResult oResult = new CResult();
CItemBO oItemBO = new CItemBO();
CItemGroup oItemGroup = new CItemGroup();
oResult = oItemBO.ReadAll(oItemGroup);
if (oResult.IsSuccess)
{
ddlCategory.DataSource = oResult.Data as ArrayList;
ddlCategory.DisplayMember = "Catg_Name";
ddlCategory.ValueMember = "Catg_OID";
ddlCategory.SelectedIndex = 0;
}
else
{
MessageBox.Show("Loading error...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadReportItem()
{
CResult oResult = new CResult();
CItemBO oItemBO = new CItemBO();
oResult = oItemBO.ReadAll();
if (oResult.IsSuccess)
{
cmbItemName.DataSource = oResult.Data as ArrayList; // List<CItem>;
cmbItemName.DisplayMember = "Item_ItemName";
cmbItemName.ValueMember = "Item_OId";
cmbItemName.SelectedValue = cmbItemName.SelectedIndex.ToString();
cmbItemName.SelectedIndex = 0;
}
else
{
MessageBox.Show("Loading error...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Getmaxdata()
{
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
oresult = oitembo.ReadAll();
ArrayList oitemlist = (ArrayList)oresult.Data;
// GenerateCode(oitemlist);
int maxitemrow = oitemlist.Count;
if (maxitemrow == 0)
{
txthiddenitemid.Text = "0";
}
else
{
CItem oitem2 = (CItem)oitemlist[maxitemrow - 1];
txthiddenitemid.Text = oitem2.Item_OID;
}
}
private void LoadItem(string stCatOID)
{
CItemBO oItembo = new CItemBO();
CResult oResult = new CResult();
oResult = oItembo.ReadAllByCond(stCatOID);
if (oResult.IsSuccess)
{
arItemList = (ArrayList)oResult.Data;
if (arItemList.Count > 0)
{
ddl_ItemName.DataSource = arItemList;
ddl_ItemName.DisplayMember = "Item_ItemName";
ddl_ItemName.ValueMember = "Item_OID";
ddl_ItemName.SelectedIndex = 0;
}
}
else
{
MessageBox.Show(oResult.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadItemType()
{
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
CItemType oitemtype = new CItemType();
oresult = oitembo.ReadAll(oitemtype);
if (oresult.IsSuccess)
{
try
{
LLItemType.DataSource = oresult.Data;
LLItemType.DisplayMember = "ITyp_Code";
LLItemType.ValueMember = "ITyp_OID";
}
catch (Exception ex) { }
}
else
{
MessageBox.Show(oresult.ErrMsg);
}
}
private void LoadGroupType()
{
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
CItemGroup oitemGroup = new CItemGroup();
oresult = oitembo.ReadAll(oitemGroup);
if (oresult.IsSuccess)
{
ArrayList arCategoryList = (ArrayList)oresult.Data;
if (arCategoryList.Count > 0)
{
LLGroupType.DataSource = arCategoryList;
LLGroupType.DisplayMember = "Catg_Code";
LLGroupType.ValueMember = "Catg_OID";
}
}
else
{
MessageBox.Show(oresult.ErrMsg);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
int groupselecteditem = ddlGroupNAme.SelectedIndex;
if (IsValidFormData())
{
if (txtItemCode.Text == "")
{
GetItemCode();
}
CItem oitem = Getformdata();
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
if (txthiddenitemid.Text == "")
{
Getmaxdata();
oitem = Getformdata();
oresult = oitembo.Create(oitem);
}
else
{
oitem = Getformdata();
oresult = oitembo.Update(oitem);
}
if (oresult.IsSuccess)
{
MessageBox.Show("Meassage Saved successfully");
Clearformdata();
populatetreenode();
ddlGroupNAme.SelectedIndex = groupselecteditem;
}
else
{
MessageBox.Show(oresult.ErrMsg);
}
}
}
private void LoadItemByItemCode(string oItemCode)
{
CResult oResult = new CResult();
CItemBO oItemBO = new CItemBO();
oResult = oItemBO.ReadAllByItemCode(oItemCode);
CItem oItem = new CItem();
if (oResult.IsSuccess)
{
oItem = oResult.Data as CItem;
if (oItem != null)
{
dgItemList.Rows.Add();
((DataGridViewComboBoxCell)dgItemList.Rows[dgItemList.Rows.Count - 2].Cells["colItemName"]).Value = oItem.Item_OID;
txtItemCode.Clear();
}
}
else
{
MessageBox.Show("Insert Item Price First and then Set Item Price", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadGroupType()
{
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
CItemGroup oitemGroup = new CItemGroup();
oresult = oitembo.ReadAll(oitemGroup);
if (oresult.IsSuccess)
{
try
{
ddlGroupNAme.DataSource = oresult.Data;
ddlGroupNAme.DisplayMember = "Catg_Name";
ddlGroupNAme.ValueMember = "Catg_OID";
// ddlGroupNAme.SelectedIndex = 0;
}
catch (Exception ex) { }
}
else
{
ddlGroupNAme.Text = "ERROR in loading";
}
}
private void LoadItemList(string stCatOID)
{
lvItemList.Items.Clear();
CItemBO oItembo = new CItemBO();
CResult oResult = new CResult();
List <CItemSales> oItemList = new List <CItemSales>();
if (rdbtnCatg.Checked)
{
oResult = oItembo.ReadAllFByCatg(currentBranch.CompBrn_OId, stCatOID);
}
else
{
oResult = oItembo.ReadAllFByCatgAndDate(currentBranch.CompBrn_OId, stCatOID, dtp_From.Value.Date, dtp_To.Value.Date);
}
if (oResult.IsSuccess)
{
oItemList = (List <CItemSales>)oResult.Data;
int i = 1;
foreach (CItemSales oItem in oItemList)
{
ListViewItem listViewItem = new ListViewItem();
listViewItem.Text = "" + i++;
listViewItem.SubItems.Add(oItem.Item_Code);
listViewItem.SubItems.Add(oItem.Item_ItemName);
listViewItem.SubItems.Add(oItem.Item_ExistQTY.ToString());
listViewItem.SubItems.Add(oItem.Item_PPrice.ToString());
listViewItem.SubItems.Add(oItem.Item_Price.ToString());
listViewItem.Tag = oItem;
lvItemList.Items.Add(listViewItem);
}
}
else
{
MessageBox.Show(oResult.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadItemList()
{
CResult oResult = new CResult();
this.oItemTemp = new Dictionary <string, CItemSales>();
CItemBO oItemBO = new CItemBO();
List <CItemSales> oItemList = new List <CItemSales>();
oResult = oItemBO.ReadAllFGForSalesByBranch(currentBranch.CompBrn_OId);
if (oResult.IsSuccess)
{
oItemList = (List <CItemSales>)oResult.Data;
foreach (CItemSales objItem in oItemList)
{
this.oItemTemp.Add(objItem.Item_OID, objItem);
}
}
else
{
MessageBox.Show(oResult.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
CItem oitem = Getformdata();
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
if ((txtItemName.Text != ""))
{
if ((MessageBox.Show("Do u really want to delete this item. ", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)) == DialogResult.Yes)
{
oitem = Getformdata();
oresult = oitembo.Delete(oitem);
Clearformdata();
populatetreenode();
}
}
if (oresult.IsSuccess)
{
if (oresult.Data.ToString() == "0")
{
MessageBox.Show("Deletion Not Possible", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clearformdata();
populatetreenode();
}
else
{
MessageBox.Show("Deleted successfully");
Clearformdata();
populatetreenode();
}
}
else
{
MessageBox.Show("Not Success" + oresult.ErrMsg + "");
}
}
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();
}
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 LoadBarCodeItem()
{
CResult oResult = new CResult();
CItemBO oItemBO = new CItemBO();
List <CItemSales> oSalesList = new List <CItemSales>();
if (txtbarcode.Text.Trim() != "")
{
oResult = oItemBO.ReadAllFGForSalesByBranchAndItem(currentBranch.CompBrn_OId, txtbarcode.Text.Trim());
}
else if (txtItemName.Text.Trim() != "")
{
oResult = oItemBO.ReadAllFGForSalesByBranchAndName(currentBranch.CompBrn_OId, txtItemName.Text.Trim());
}
if (oResult.IsSuccess)
{
oSalesList = (List <CItemSales>)oResult.Data;
if (oSalesList.Count > 0)
{
CItemSales oItem = (CItemSales)oSalesList[0];
if (oItem != null)
{
if (oItem.Item_Price == 0)
{
MessageBox.Show("Please set the item Seles Price!!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
//this.Close();
return;
}
if (oItem.Item_ExistQTY == 0)
{
MessageBox.Show("Sales Item Quantity is Empty!!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
foreach (DataGridViewRow dgvr2 in this.dgvSaleItemList.Rows)
{
if (dgvr2.Index != this.dgvSaleItemList.Rows.Count - 1)
{
if (dgvr2.Cells["chItemOId"].Value.ToString() == oItem.Item_OID)
{
dgvr2.Cells["chQty"].Value = Convert.ToString(Convert.ToInt32(dgvr2.Cells["chQty"].Value) + 1);
this.CalculateTotal();
txtbarcode.Text = "";
return;
}
}
}
this.dgvSaleItemList.Rows.Add();
DataGridViewRow dgvr = this.dgvSaleItemList.Rows[this.dgvSaleItemList.Rows.Count - 2];
dgvr.Cells["chSLNum"].Value = (this.dgvSaleItemList.Rows.Count - 1).ToString();
dgvr.Cells["chItemOId"].Value = oItem.Item_OID;
dgvr.Cells["chItemName"].Value = oItem.Item_ItemName;
dgvr.Cells["chRate"].Value = oItem.Item_Price;
dgvr.Cells["chVatPercent"].Value = oItem.Item_VatPercent;
dgvr.Cells["chUOMOID"].Value = oItem.Item_UOMOID;
dgvr.Cells["chValue"].Value = "0";
dgvr.Cells["chCurrencyOID"].Value = oItem.Item_CurrencyOID;
dgvr.Cells["chVatValue"].Value = "0";
dgvr.Cells["chQty"].Value = "1";
dgvr.Cells["cPPrice"].Value = oItem.Item_PPrice;
dgvr.Tag = oItem;
this.CalculateTotal();
this.lastSelection = LastSelected.ItemList;
dgvr.Selected = true;
this.txtDiscountperc.BackColor = Color.White;
this.txtCustomerPaid.BackColor = Color.White;
IsAddedMode = false;
}
txtbarcode.Text = "";
}
}
}
private void treeView1_AfterSelect_1(object sender, TreeViewEventArgs e)
{
if (e.Node.Level == 1)
{
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
oresult = oitembo.ReadAll();
foreach (CItem oitem1 in oresult.Data as ArrayList)
{
if (oitem1.Item_ItemName == e.Node.Text)
{
txthiddenitemid.Text = oitem1.Item_OID;
txtItemName.Text = oitem1.Item_ItemName;
txtItemCode.Text = oitem1.Item_Code;
txtpprice.Text = oitem1.Item_Pprice.ToString();
txtRemarks.Text = oitem1.Remarks;
txtRQTY.Text = oitem1.Item_RQTY.ToString();
txtSprice.Text = oitem1.Item_Sprice.ToString();
if (oitem1.IsActive == "Y")
{
chkIsActive.Checked = true;
}
else
{
chkIsActive.Checked = false;
}
nupdnItemPriority.Value = oitem1.Item_Priority;
if (oitem1.ItemImage != null)
{
pbImage.Image = Image.FromStream(Helper.GetMemoryStream(oitem1.ItemImage));
}
else
{
pbImage.Image = null;
}
this.ItemImage = oitem1.ItemImage;
int i = 0;
foreach (CItemGroup oitemGroup in ddlGroupNAme.Items)
{
if (oitem1.Item_GroupID == oitemGroup.Catg_OID)
{
ddlGroupNAme.SelectedIndex = i;
break;
}
i++;
}
i = 0;
foreach (CItemType oitemType in ddlItemType.Items)
{
if (oitem1.Item_TypeID == oitemType.ITyp_OID)
{
ddlItemType.SelectedIndex = i;
break;
}
i++;
}
i = 0;
foreach (CUOM oCUOM2 in ddlUOM.Items)
{
if (oitem1.Item_UOMID == oCUOM2.UOM_OID)
{
ddlUOM.SelectedIndex = i;;
break;
}
i++;
}
FormControlMode(1);
break;
}
}
}
}
