private void btnImport_Click(object sender, EventArgs e) { try { string ExcelFile = ""; string SelectedFileName = ""; OpenFileDialog ofd = new OpenFileDialog(); DialogResult result = ofd.ShowDialog(); // Show the dialog. if (result == DialogResult.OK) // Test result. { if (result == DialogResult.OK) // Test result. { ExcelFile = ofd.SafeFileName; SelectedFileName = ofd.FileName; } objDataAccess.Upload("Temp_Item", SelectedFileName); DataTable dtblImport = new DataTable(); dtblImport = objList.ListOfRecord("usp_Import_Item_List", null, "Import Item - LoadList"); if (ExcelFile.ToString() == "Item.xls") { for (int i = 0; i < dtblImport.Rows.Count; i++) { if (dtblImport.Rows[i]["ITEM"].ToString().Trim() != "" && dtblImport.Rows[i]["ITEM"].ToString() != null) { Int64 CAT_ID, UOM_ID, CLASS_ID, Godown_ID, Currency_ID; DataTable dtMaxCode = new DataTable(); dtMaxCode = objList.ListOfRecord("usp_Select_Max_Code_Item", null, "MAX ITEM - LoadList"); if (dtMaxCode.Rows[0][0].ToString() == null || dtMaxCode.Rows[0][0].ToString().Trim() == "") { CODE = "ITEM-00001"; } else { CODE = "ITEM-" + (Convert.ToInt16(dtMaxCode.Rows[0][0].ToString().Substring(5, 5).TrimStart('0')) + 1).ToString().PadLeft(5, '0'); } DataTable dtUOMId = new DataTable(); NameValueCollection ParaUOM = new NameValueCollection(); ParaUOM.Add("@i_UOM", dtblImport.Rows[i]["UOM"].ToString()); dtUOMId = objList.ListOfRecord("usp_Select_UOMID", ParaUOM, "Item Class - LoadList"); if (dtUOMId.Rows.Count > 0) { UOM_ID = Convert.ToInt64(dtUOMId.Rows[0][0].ToString()); } else { UOM_ID = 0; } DataTable dtCurrencyId = new DataTable(); NameValueCollection ParaCurrency = new NameValueCollection(); ParaCurrency.Add("@i_Currency", dtblImport.Rows[i]["CURRENCY"].ToString()); dtCurrencyId = objList.ListOfRecord("usp_Select_CurrencyID", ParaCurrency, "Item Class - LoadList"); if (dtCurrencyId.Rows.Count > 0) { Currency_ID = Convert.ToInt64(dtCurrencyId.Rows[0][0].ToString()); } else { Currency_ID = 0; } string Othername = ""; //if (dtblImport.Rows[i]["OTHER_NAME"].ToString().Trim() != "" || dtblImport.Rows[i]["OTHER_NAME"].ToString() != null) //{ // Othername = dtblImport.Rows[i]["OTHER_NAME"].ToString(); //} //else //{ // Othername = ""; //} string Description = ""; string PRODUCT_CODE = ""; string HSN_CODE = ""; decimal OPENINGSTOCK = 0; decimal REORDERLEVEL = 0; string LOCATION = ""; string RACKNO = ""; if (dtblImport.Rows[i]["DESCRIPTION"].ToString().Trim() != "" || dtblImport.Rows[i]["DESCRIPTION"].ToString() != null) { Description = dtblImport.Rows[i]["DESCRIPTION"].ToString(); } else { Description = ""; } decimal Price = 0; if (dtblImport.Rows[i]["Price"].ToString().Trim() != "") { Price = Convert.ToDecimal(dtblImport.Rows[i]["Price"].ToString()); } else { Price = 0; } if (dtblImport.Rows[i]["PRODUCT_CODE"].ToString().Trim() != "" || dtblImport.Rows[i]["PRODUCT_CODE"].ToString() != null) { PRODUCT_CODE = dtblImport.Rows[i]["PRODUCT_CODE"].ToString(); } else { PRODUCT_CODE = ""; } if (dtblImport.Rows[i]["HSN_CODE"].ToString().Trim() != "" || dtblImport.Rows[i]["HSN_CODE"].ToString() != null) { HSN_CODE = dtblImport.Rows[i]["HSN_CODE"].ToString(); } else { HSN_CODE = ""; } DataTable dtGodownId = new DataTable(); NameValueCollection ParaGD = new NameValueCollection(); ParaGD.Add("@i_GODOWN", dtblImport.Rows[i]["GODOWN"].ToString()); dtGodownId = objList.ListOfRecord("usp_Select_GODOWNID", ParaGD, "Item Class - LoadList"); //if (dtGodownId.Rows.Count > 0) //{ // Godown_ID = Convert.ToInt64(dtGodownId.Rows[0][0].ToString()); //} //else //{ Godown_ID = 1; //} if (dtblImport.Rows[i]["OPENING STOCK"].ToString().Trim() != "" || dtblImport.Rows[i]["OPENING STOCK"].ToString() != null) { if (dtblImport.Rows[i]["OPENING STOCK"].ToString() == "") { } else { OPENINGSTOCK = Convert.ToDecimal(dtblImport.Rows[i]["OPENING STOCK"].ToString()); } } else { OPENINGSTOCK = 0; } if (dtblImport.Rows[i]["REORDER LEVEL"].ToString().Trim() != "" || dtblImport.Rows[i]["REORDER LEVEL"].ToString() != null) { if (dtblImport.Rows[i]["REORDER LEVEL"].ToString() == "") { } else { REORDERLEVEL = Convert.ToDecimal(dtblImport.Rows[i]["REORDER LEVEL"].ToString()); } } else { REORDERLEVEL = 0; } if (dtblImport.Rows[i]["LOCATION"].ToString().Trim() != "" || dtblImport.Rows[i]["LOCATION"].ToString() != null) { LOCATION = dtblImport.Rows[i]["LOCATION"].ToString(); } else { LOCATION = ""; } if (dtblImport.Rows[i]["RACK NO"].ToString().Trim() != "" || dtblImport.Rows[i]["RACK NO"].ToString() != null) { RACKNO = dtblImport.Rows[i]["RACK NO"].ToString(); } else { RACKNO = ""; } objItemBL.Insert(CODE, dtblImport.Rows[i]["ITEM"].ToString(), Othername, Description, UOM_ID, Price, PRODUCT_CODE, HSN_CODE, "", 0, OPENINGSTOCK, Convert.ToDecimal(REORDERLEVEL), LOCATION, RACKNO, Convert.ToInt32(Godown_ID), "", Currency_ID ); } } MessageBox.Show("Data Uploded Successfully..!!"); LoadList(); } else { MessageBox.Show("Select Proper Item.xls File."); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool SetSave() { bool ReturnValue = false; try { if (_Mode == (int)Common.Constant.Mode.Delete) { CommDelRec.DeleteRecord(_ItemID, "usp_Item_Delete", "frmItemEntry-SetSave"); if (CommDelRec.Exception == null) { if (CommDelRec.ErrorMessage != "") { lblErrorMessage.Text = CommDelRec.ErrorMessage; txtItemName.Focus(); ReturnValue = false; } else { ReturnValue = true; } } else { MessageBox.Show(CommDelRec.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); ReturnValue = false; } } else { if (txtprice.Text == "") { txtprice.Text = "0.00"; } if (DataValidator.IsValid(this.grpData)) { if (Convert.ToInt16(cmbgodown.SelectedValue) != 0) { if (_Mode == (int)Common.Constant.Mode.Insert) { string XMLString = string.Empty; long Cnt = 0; DataTable dtgodown = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_UserID", CurrentUser.UserID.ToString()); para.Add("@i_CompId", CurrentCompany.CompId.ToString()); dtgodown = CommList.ListOfRecord("usp_Godown_DDL", para, "Common - FillGodownCombo"); if (CommList.Exception != null) { MessageBox.Show(CommList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { XMLString = "<NewDataSet>"; for (int i = 0; i < dtgodown.Rows.Count; i++) { XMLString = XMLString + "<Table>"; XMLString = XMLString + "<GodownID>" + Convert.ToInt32(dtgodown.Rows[i]["GodownID"]) + "</GodownID>"; XMLString = XMLString + "</Table> "; Cnt = Cnt + 1; } XMLString = XMLString + "</NewDataSet>"; } //string newFileName = CurrentUser.DocumentPath + txtItemCode.Text.ToString().Replace('/', '-') + "-" + txtDocName.Text.ToString().Replace('/', '-'); string newFileName = txtDocName.Text.ToString().Replace('/', '-'); objItemBL.Insert(txtItemCode.Text, txtItemName.Text, txtOtherName.Text, txtSpecification.Text, Convert.ToInt64(cmbUOM.SelectedValue), Convert.ToDecimal(txtprice.Text), txtProductCode.Text, txtHSN.Text, XMLString, Cnt, Convert.ToDecimal(txtOpeningStock.Text), Convert.ToDecimal(txtReorderLevel.Text), txtLocation.Text, txtRackNo.Text, (int)cmbgodown.SelectedValue, newFileName, Convert.ToInt64(cmbCurrency.SelectedValue) ); } else if (_Mode == (int)Common.Constant.Mode.Modify) { string newFileName = txtDocName.Text.ToString().Replace('/', '-'); objItemBL.Update(_ItemID, _StockID, txtItemCode.Text, txtItemName.Text, txtOtherName.Text, txtSpecification.Text, Convert.ToInt64(cmbUOM.SelectedValue), Convert.ToDecimal(txtprice.Text), txtProductCode.Text, txtHSN.Text, Convert.ToDecimal(txtOpeningStock.Text), Convert.ToDecimal(txtReorderLevel.Text), txtLocation.Text, txtRackNo.Text, (int)cmbgodown.SelectedValue, newFileName, Convert.ToInt64(cmbCurrency.SelectedValue) ); } if (objItemBL.Exception == null) { if (objItemBL.ErrorMessage != "") { lblErrorMessage.Text = objItemBL.ErrorMessage; txtItemName.Focus(); ReturnValue = false; } else { //if (_Mode == (int)Common.Constant.Mode.Insert) //{ //string newFileName = CurrentUser.DocumentPath + txtItemCode.Text.ToString().Replace('/', '-') + "-" + txtDocName.Text.ToString().Replace('/', '-'); //objItemBL.InsertQuotationDocument(_ItemID, txtItemCode.Text.ToString().Replace('/', '-') + "-" + txtItemCode.Text.ToString().Replace('/', '-')); string newFileName = txtDocName.Text.ToString().Replace('/', '-'); if (objItemBL.Exception == null) { if (objItemBL.ErrorMessage == "") { //File.Copy(SelectedFileName, newFileName, true); } } //} ReturnValue = true; } } else { MessageBox.Show(objItemBL.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); ReturnValue = false; } } else { MessageBox.Show("Please select Godown First.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); cmbgodown.Focus(); } } } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Item Register", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } return(ReturnValue); }