void oSearch_SelectedEvent(object sender, SearchEventArgs <CGRMaster> e) { FormControlMode(1); CGRMaster oMTMaster = e.t; FillForm(oMTMaster); }
private CGRMaster GetResultSetToGRMaster(DataRow dr) { CGRMaster oGRMaster = new CGRMaster(); oGRMaster.GRMstr_OID = dr["GRMstr_OID"].ToString(); oGRMaster.GRMstr_Branch = dr["GRMstr_Branch"].ToString(); oGRMaster.GRMstr_Code = dr["GRMstr_Code"].ToString(); oGRMaster.GRMstr_Date = DateTime.Parse(dr["GRMstr_Date"].ToString()).Date; oGRMaster.GRMstr_Type = int.Parse(dr["GRMstr_Type"].ToString()); oGRMaster.GRMstr_By = dr["GRMstr_By"].ToString(); oGRMaster.GRMstr_RefBy = dr["GRMstr_RefBy"].ToString(); oGRMaster.GRMstr_VendorID = dr["GRMstr_VendorID"].ToString(); oGRMaster.GRMstr_TotalAmt = float.Parse(dr["GRMstr_TotalAmt"].ToString()); oGRMaster.Creator = dr["GRMstr_Creator"].ToString(); oGRMaster.CreationDate = DateTime.Parse(dr["GRMstr_CreationDate"].ToString()).Date; oGRMaster.UpdateBy = dr["GRMstr_UpdateBy"].ToString(); oGRMaster.UpdateDate = DateTime.Parse(dr["GRMstr_UpdateDate"].ToString()).Date; oGRMaster.IsActive = dr["GRMstr_IsActive"].ToString(); oGRMaster.Remarks = dr["GRMstr_Remarks"].ToString(); return(oGRMaster); }
private void btnSave_Click(object sender, EventArgs e) { if (ValidationData()) { CResult oResult = new CResult(); CGRBO oGRBO = new CGRBO(); CGRMaster oMaster = GetToBSavedData(); if (oMaster != null) { if (!IsUpdateMode) { oResult = oGRBO.Create(oMaster); } else { oResult = oGRBO.Update(oMaster, oGRFinalQtyDic); } if (oResult.IsSuccess) { MessageBox.Show("Successfully Done. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearFormData(); GetGRNextCode(); } else { MessageBox.Show(oResult.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private CGRMaster LoadImportedData(CMTMaster oMTMaster) { CGRMaster oGRMaster = new CGRMaster(); oGRMaster.GRMstr_Branch = currentBranch.CompBrn_Branch; oGRMaster.GRMstr_By = currentUser.User_OID; oGRMaster.GRMstr_RefBy = oMTMaster.MTMstr_DOrder; oGRMaster.GRMstr_Type = 0; oGRMaster.Creator = currentUser.User_OID; oGRMaster.CreationDate = DateTime.Now.Date; foreach (CMTDetails oMTDetails in oMTMaster.MTMstr_DetailsList) { CGRDetails oGRDetails = new CGRDetails(); oGRDetails.GRDet_ItemOID = oMTDetails.MTDtls_ItemOID; oGRDetails.GRDet_QTY = oMTDetails.MTDtls_IssQty; oGRDetails.GRDet_UOM = oMTDetails.MTDtls_IssUOMOID; oGRDetails.GRDet_LocOID = oMTDetails.MTDtls_DestLocOID; oGRDetails.GRDet_InvType = oMTDetails.MTDtls_DesInvtyp; oGRMaster.GRMstr_DetailsList.Add(oGRDetails); } return(oGRMaster); }
private void FillForm(CGRMaster oGRMaster) { oGRExistingQtyDic.Clear(); txtSelectedGROID.Text = oGRMaster.GRMstr_OID; txtGRNo.Text = oGRMaster.GRMstr_Code; ddlType.SelectedValue = oGRMaster.GRMstr_Type; dtpGRDate.Value = oGRMaster.GRMstr_Date; txtRecievedBy.Text = oGRMaster.GRMstr_By; txtRemarks.Text = oGRMaster.Remarks; ddlSupplier.SelectedValue = oGRMaster.GRMstr_VendorID; txtRefNo.Text = oGRMaster.GRMstr_RefBy; dgItemList.Rows.Clear(); foreach (CGRDetails oGRDetails in oGRMaster.GRMstr_DetailsList) { dgItemList.Rows.Add(); DataGridViewRow odgRow = dgItemList.Rows[dgItemList.Rows.Count - 2]; odgRow.Cells["colItemName"].Value = oGRDetails.GRDet_ItemOID.Trim(); odgRow.Cells["colIssueqty"].Value = oGRDetails.GRDet_QTY.ToString(); odgRow.Cells["colIssueUOM"].Value = oGRDetails.GRDet_UOM.Trim(); odgRow.Cells["colSourceLoc"].Value = oGRDetails.GRDet_LocOID.Trim(); odgRow.Cells["colSrcInvType"].Value = Enum.GetName(typeof(EInvType), oGRDetails.GRDet_InvType); odgRow.Cells["colPrice"].Value = oGRDetails.GRDet_Price.ToString("F2").Trim(); if (oGRDetails.GRDet_Currency.Trim() != "") { odgRow.Cells["colCurrency"].Value = oGRDetails.GRDet_Currency.Trim(); } odgRow.Cells["colAmount"].Value = oGRDetails.GRDet_Amount.ToString("F2").Trim(); //odgRow.Cells["NowQty"].Value = oGRDetails.GRdet_InvQ.ToString(); if (IsUpdateMode) { oGRExistingQtyDic.Add(oGRDetails.GRDet_ItemOID.Trim(), oGRDetails); // odgRow.Cells["colInvtQty"].Value = oGRDetails.GRDet_QTY.ToString("F2"); } } CalculateTotal(); }
//public CResult ReadByBranchAndDate(string BranchCode, DateTime FromDate, DateTime ToDate) //{ // List<CGRDetails> oItemList = new List<CGRDetails>(); // oResult = new CResult(); // conn = oConnManager.GetConnection(out s_DBError); // if (conn != null) // { // try // { // DataSet ds = new DataSet(); // SqlCommand cmd = new SqlCommand(); // cmd.Connection = conn; // cmd.CommandText = "sp_GRDetail_ReadByBrnIdAndDate"; // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Clear(); // cmd.Parameters.AddWithValue("@BranchID", BranchCode); // cmd.Parameters.AddWithValue("@SOMstr_DateFrom", FromDate); // cmd.Parameters.AddWithValue("@SOMstr_DateTo", ToDate); // SqlDataAdapter da = new SqlDataAdapter(cmd); // da.Fill(ds); // DataTable dtItem = ds.Tables[0]; // // oItemList.Add(""); // foreach (DataRow dr in dtItem.Rows) // { // CGRDetails oGRDetails = new CGRDetails(); // oGRDetails.GRDet_ItemOID = dr["GRDet_ItemOID"].ToString(); // oGRDetails.GRDet_QTY = float.Parse(dr["GRDet_QTY"].ToString()); // oGRDetails.GRDet_BranchOID = dr["GRDet_Branch"].ToString(); // oGRDetails.GRDet_Price = float.Parse(dr["GRDet_Price"].ToString()); // oGRDetails.GRDet_Amount = float.Parse(dr["GRDet_Amount"].ToString()); // oGRDetails.GRDet_ItemName = dr["GRDet_ItemName"].ToString(); // oItemList.Add(oGRDetails); // } // oResult.IsSuccess = true; // oResult.Data = oItemList; // } // catch (SqlException e) // { // oResult.IsSuccess = false; // oResult.ErrMsg = e.Message; // } // finally // { // oConnManager.Close(); // } // } // else // { // oResult.IsSuccess = false; // oResult.ErrMsg = s_DBError; // } // return oResult; //} //public CResult ReduceByItemOID(List<CSODetails> oListSODetails) //{ // oResult = new CResult(); // conn = oConnManager.GetConnection(out s_DBError); // if (conn != null) // { // SqlCommand cmd = new SqlCommand(); // cmd.Connection = conn; // cmd.Transaction = oConnManager.BeginTransaction(); // try // { // foreach (CSODetails oSODetails in oListSODetails) // { // cmd.CommandText = "sp_GRDetails_ReduceByItemOID"; // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Clear(); // cmd.Parameters.AddWithValue("@ItemOID", oSODetails.SODet_ItemOID); // cmd.Parameters.AddWithValue("@ItemQTY", oSODetails.SODet_QTY); // cmd.Parameters.AddWithValue("@BranchOID", oSODetails.SODet_BranchOID); // cmd.ExecuteNonQuery(); // } // oConnManager.Commit(); // oResult.IsSuccess = true; // } // catch (SqlException e) // { // string sRollbackError = oConnManager.Rollback(); // oResult.IsSuccess = false; // oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; // } // finally // { // oConnManager.Close(); // } // } // else // { // oResult.IsSuccess = false; // oResult.ErrMsg = s_DBError; // } // return oResult; //} public CResult ExportAndUpdate(CGRMaster oMaster, string url) { CInventory oInventory = new CInventory(); CResult oResult = new CResult(); DataTable dt = new DataTable(); List <CInventory> oInvtList = new List <CInventory>(); List <CGRDetails> exportExcelList = new List <CGRDetails>(); oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Parameters.Clear(); cmd.Transaction = oConnManager.BeginTransaction(); try { foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList) { oInventory = new CInventory(); oInventory.Invt_Branch = oDetails.GRDet_Branch; oInventory.Invt_BranchOID = oDetails.GRDet_BranchOID; oInventory.Invt_InvType = oDetails.GRDet_InvType; oInventory.Invt_ItemOID = oDetails.GRDet_ItemOID; oInventory.Invt_LocOID = oDetails.GRDet_LocOID; oInventory.Invt_QTY = oDetails.GRDet_QTY; oInvtList.Add(oInventory); exportExcelList.Add(oDetails); } CsvExport <CGRDetails> csv = new CsvExport <CGRDetails>(exportExcelList); csv.Export(); csv.ExportToFile(url); // InventoryDT = ConvertToDataTable<CGRDetails>(exportExcelList); CInventoryBO oInventoryBO = new CInventoryBO(); oResult = oInventoryBO.InvtDec(oInvtList); if (oResult.IsSuccess) { oConnManager.Commit(); oResult.IsSuccess = true; } else { oResult.ErrMsg = oConnManager.Rollback(); oResult.IsSuccess = false; } } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Update(CGRMaster oMaster, Dictionary <string, CGRDetails> oGRFinalQtyDic) { List <CInventory> oInvtList = new List <CInventory>(); oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Parameters.Clear(); cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_GRMaster_Update"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@GRMstr_OID", oMaster.GRMstr_OID); cmd.Parameters.AddWithValue("@GRMstr_Branch", oMaster.GRMstr_Branch); cmd.Parameters.AddWithValue("@GRMstr_Code", oMaster.GRMstr_Code); cmd.Parameters.AddWithValue("@GRMstr_Date", oMaster.GRMstr_Date); cmd.Parameters.AddWithValue("@GRMstr_Type", oMaster.GRMstr_Type); cmd.Parameters.AddWithValue("@GRMstr_By", oMaster.GRMstr_By); cmd.Parameters.AddWithValue("@GRMstr_RefBy", oMaster.GRMstr_RefBy); cmd.Parameters.AddWithValue("@GRMstr_VendorID", oMaster.GRMstr_VendorID); cmd.Parameters.AddWithValue("@GRMstr_TotalAmt", oMaster.GRMstr_TotalAmt); cmd.Parameters.AddWithValue("@Creator", oMaster.Creator); cmd.Parameters.AddWithValue("@CreationDate", oMaster.CreationDate); cmd.Parameters.AddWithValue("@UpdateBy", oMaster.UpdateBy); cmd.Parameters.AddWithValue("@UpdateDate", oMaster.UpdateDate); cmd.Parameters.AddWithValue("@IsActive", (oMaster.IsActive == "Y") ? 1 : 0); cmd.Parameters.AddWithValue("@Remarks", oMaster.Remarks); cmd.ExecuteNonQuery(); cmd.CommandText = "Delete from t_GRDet where GRDet_MStrOID=@GRMstr_OID"; cmd.CommandType = CommandType.Text; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@GRMstr_OID", oMaster.GRMstr_OID); cmd.ExecuteNonQuery(); foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList) { cmd.CommandText = "sp_GRDetails_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@GRDet_Branch", oDetails.GRDet_Branch); cmd.Parameters.AddWithValue("@GRDet_OID", oDetails.GRDet_OID); cmd.Parameters.AddWithValue("@GRDet_MStrOID", oMaster.GRMstr_OID); cmd.Parameters.AddWithValue("@GRDet_ItemOID", oDetails.GRDet_ItemOID); cmd.Parameters.AddWithValue("@GRDet_QTY", oDetails.GRDet_QTY); cmd.Parameters.AddWithValue("@GRDet_UOM", oDetails.GRDet_UOM); cmd.Parameters.AddWithValue("@GRDet_BranchOID", oDetails.GRDet_BranchOID); cmd.Parameters.AddWithValue("@GRDet_LocOID", oDetails.GRDet_LocOID); cmd.Parameters.AddWithValue("@GRDet_InvType", oDetails.GRDet_InvType); cmd.Parameters.AddWithValue("@GRDet_Price", oDetails.GRDet_Price); cmd.Parameters.AddWithValue("@GRDet_Currency", oDetails.GRDet_Currency); cmd.Parameters.AddWithValue("@GRDet_Amount", oDetails.GRDet_Amount); cmd.ExecuteNonQuery(); } // update inventory foreach (CGRDetails oGRDetails in oGRFinalQtyDic.Values) { // populate inv list CInventory oInventory = new CInventory(); oInventory.Invt_Branch = oGRDetails.GRDet_Branch; oInventory.Invt_BranchOID = oGRDetails.GRDet_BranchOID; oInventory.Invt_InvType = oGRDetails.GRDet_InvType; oInventory.Invt_ItemOID = oGRDetails.GRDet_ItemOID; oInventory.Invt_LocOID = oGRDetails.GRDet_LocOID; oInventory.Invt_QTY = oGRDetails.GRDet_QTY; oInvtList.Add(oInventory); } //Update inv CInventoryBO oInventoryBO = new CInventoryBO(); oResult = oInventoryBO.InvtInc(oInvtList); if (oResult.IsSuccess) { oConnManager.Commit(); oResult.IsSuccess = true; } else { oResult.ErrMsg = oConnManager.Rollback(); oResult.IsSuccess = false; } } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CGRMaster oMaster) { List <CInventory> oInvtList = new List <CInventory>(); oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Parameters.Clear(); cmd.Transaction = oConnManager.BeginTransaction(); try { // cmd.CommandText = "sp_GRMaster_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@GRMstr_OID", SqlDbType.Char, 24); cmd.Parameters["@GRMstr_OID"].Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@GRMstr_Branch", oMaster.GRMstr_Branch); cmd.Parameters.AddWithValue("@GRMstr_Code", oMaster.GRMstr_Code); cmd.Parameters.AddWithValue("@GRMstr_Date", oMaster.GRMstr_Date); cmd.Parameters.AddWithValue("@GRMstr_Type", oMaster.GRMstr_Type); cmd.Parameters.AddWithValue("@GRMstr_By", oMaster.GRMstr_By); cmd.Parameters.AddWithValue("@GRMstr_RefBy", oMaster.GRMstr_RefBy); cmd.Parameters.AddWithValue("@GRMstr_VendorID", oMaster.GRMstr_VendorID); cmd.Parameters.AddWithValue("@GRMstr_TotalAmt", oMaster.GRMstr_TotalAmt); cmd.Parameters.AddWithValue("@Creator", oMaster.Creator); cmd.Parameters.AddWithValue("@CreationDate", oMaster.CreationDate); cmd.Parameters.AddWithValue("@UpdateBy", oMaster.UpdateBy); cmd.Parameters.AddWithValue("@UpdateDate", oMaster.UpdateDate); cmd.Parameters.AddWithValue("@IsActive", (oMaster.IsActive == "Y") ? 1 : 0); cmd.Parameters.AddWithValue("@Remarks", oMaster.Remarks); cmd.Parameters.AddWithValue("@IsImported", oMaster.GRMstr_IsImported); cmd.ExecuteNonQuery(); string stGRMStr_OID = cmd.Parameters["@GRMstr_OID"].Value.ToString(); if (stGRMStr_OID.Trim() == "") { oResult.ErrMsg = "This delivered data is already exists."; oResult.IsSuccess = false; return(oResult); } foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList) { cmd.CommandText = "sp_GRDetails_Insert"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@GRDet_Branch", oDetails.GRDet_Branch); cmd.Parameters.AddWithValue("@GRDet_OID", oDetails.GRDet_OID); cmd.Parameters.AddWithValue("@GRDet_MStrOID", stGRMStr_OID); cmd.Parameters.AddWithValue("@GRDet_ItemOID", oDetails.GRDet_ItemOID); cmd.Parameters.AddWithValue("@GRDet_QTY", oDetails.GRDet_QTY); cmd.Parameters.AddWithValue("@GRDet_UOM", oDetails.GRDet_UOM); cmd.Parameters.AddWithValue("@GRDet_BranchOID", oDetails.GRDet_BranchOID); cmd.Parameters.AddWithValue("@GRDet_LocOID", oDetails.GRDet_LocOID); cmd.Parameters.AddWithValue("@GRDet_InvType", oDetails.GRDet_InvType); cmd.Parameters.AddWithValue("@GRDet_Price", oDetails.GRDet_Price); cmd.Parameters.AddWithValue("@GRDet_Currency", oDetails.GRDet_Currency); cmd.Parameters.AddWithValue("@GRDet_Amount", oDetails.GRDet_Amount); cmd.ExecuteNonQuery(); // populate inv list CInventory oInventory = new CInventory(); oInventory.Invt_Branch = oDetails.GRDet_Branch; oInventory.Invt_BranchOID = oDetails.GRDet_BranchOID; oInventory.Invt_InvType = oDetails.GRDet_InvType; oInventory.Invt_ItemOID = oDetails.GRDet_ItemOID; oInventory.Invt_LocOID = oDetails.GRDet_LocOID; oInventory.Invt_QTY = oDetails.GRDet_QTY; oInvtList.Add(oInventory); } //Update inv CInventoryBO oInventoryBO = new CInventoryBO(); oResult = oInventoryBO.InvtInc(oInvtList); if (oResult.IsSuccess) { oConnManager.Commit(); oResult.IsSuccess = true; } else { oResult.ErrMsg = oConnManager.Rollback(); oResult.IsSuccess = false; } } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult ReadByIDDate(DateTime dtFrom, DateTime dtTo, string sID, string stCond) { List <CGRDetails> oGRDetailsList = new List <CGRDetails>(); List <CGRMaster> oGRMasterList = new List <CGRMaster>(); CResult oResult = new CResult(); oResult.IsSuccess = false; conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); SqlDataAdapter da; DataSet ds; cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_GRMaster_ReadByIDDate"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); if (sID == null) { cmd.Parameters.AddWithValue("@frmDate", dtFrom); cmd.Parameters.AddWithValue("@toDate", dtTo); cmd.Parameters.AddWithValue("@OID", DBNull.Value); cmd.Parameters.AddWithValue("@Cond", int.Parse(stCond)); } else { cmd.Parameters.AddWithValue("@frmDate", dtFrom); cmd.Parameters.AddWithValue("@toDate", dtTo); cmd.Parameters.AddWithValue("@OID", sID); cmd.Parameters.AddWithValue("@Cond", int.Parse(stCond)); } da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds); if (ds.Tables.Count > 0) { DataTable dtMaster = ds.Tables[0] as DataTable; DataTable dtDetails = ds.Tables[1] as DataTable; foreach (DataRow dr in dtDetails.Rows) { oGRDetailsList.Add(GetResultSetToGRDetails(dr)); } foreach (DataRow dr in dtMaster.Rows) { CGRMaster oGRMaster = new CGRMaster(); oGRMaster = GetResultSetToGRMaster(dr); foreach (CGRDetails oGRDetails in oGRDetailsList) { if (oGRDetails.GRDet_MStrOID == oGRMaster.GRMstr_OID) { oGRMaster.GRMstr_DetailsList.Add(oGRDetails); } } oGRMasterList.Add(oGRMaster); } } oResult.IsSuccess = true; oResult.Data = oGRMasterList; oConnManager.Commit(); } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
private void btnImport_Click(object sender, EventArgs e) { try { progressBarImport.Value = 0; Cursor = Cursors.WaitCursor; string selectGRFromHomeMaster = "select *from t_GRMstr where GRMatr_IsImported=0"; SqlConnection oConnectionForHomeDB = new CConManager().GetConnectionForRemote(); DataTable dtHome = new DataTable(); SqlCommand oCommandForHome = new SqlCommand(selectGRFromHomeMaster, oConnectionForHomeDB); oCommandForHome.CommandType = CommandType.Text; SqlDataAdapter oSqlAdapter = new SqlDataAdapter(oCommandForHome); oSqlAdapter.Fill(dtHome); List <CGRMaster> oGRMasterList = new List <CGRMaster>(); progressBarImport.Value = 70; if (dtHome.Rows.Count > 0) { progressBarImport.Value = 70; foreach (DataRow dr in dtHome.Rows) { CGRMaster oGRMaster = new CGRMaster(); oGRMaster.GRMstr_OID = ""; oGRMaster.GRMstr_Branch = currentBranch.CompBrn_Code; oGRMaster.GRMstr_Code = GetGRmstrCode(); oGRMaster.GRMstr_Type = int.Parse(dr["GRMstr_Type"].ToString()); oGRMaster.GRMstr_Date = DateTime.Parse(dr["GRMstr_Date"].ToString()); oGRMaster.GRMstr_By = dr["GRMstr_By"].ToString(); oGRMaster.Remarks = dr["GRMstr_Remarks"].ToString(); oGRMaster.GRMstr_RefBy = dr["GRMstr_RefBy"].ToString(); oGRMaster.Creator = dr["GRMstr_Creator"].ToString(); oGRMaster.CreationDate = DateTime.Parse(dr["GRMstr_CreationDate"].ToString()); oGRMaster.UpdateBy = dr["GRMstr_UpdateBy"].ToString(); oGRMaster.UpdateDate = DateTime.Parse(dr["GRMstr_UpdateDate"].ToString()); oGRMaster.IsActive = "Y"; oGRMaster.GRMstr_IsImported = 1; string selectGRForHomeDetail = "select *from t_GRDet where GRDet_MStrOID='" + dr["GRMstr_OID"].ToString() + "'"; SqlConnection oConnectionForHomeDBDetail = new CConManager().GetConnectionForRemote(); DataTable dtHomedetail = new DataTable(); SqlCommand oCommand = new SqlCommand(selectGRForHomeDetail, oConnectionForHomeDBDetail); oCommand.CommandType = CommandType.Text; SqlDataAdapter oDataAdapter = new SqlDataAdapter(oCommand); oDataAdapter.Fill(dtHomedetail); //List<CGRDetails> oGRDetailList = new List<CGRDetails>(); if (dtHomedetail.Rows.Count > 0) { foreach (DataRow drDetail in dtHomedetail.Rows) { CGRDetails oGRDetails = new CGRDetails(); oGRDetails.GRDet_Branch = currentBranch.CompBrn_Code; oGRDetails.GRDet_ItemOID = drDetail["GRDet_ItemOID"].ToString(); oGRDetails.GRDet_QTY = float.Parse(drDetail["GRDet_QTY"].ToString()); oGRDetails.GRDet_UOM = drDetail["GRDet_UOM"].ToString(); oGRDetails.GRDet_BranchOID = currentBranch.CompBrn_OId; oGRDetails.GRDet_LocOID = drDetail["GRDet_LocOID"].ToString(); oGRDetails.GRDet_InvType = int.Parse(drDetail["GRDet_InvType"].ToString()); oGRDetails.GRDet_Price = float.Parse(drDetail["GRDet_Price"].ToString()); oGRDetails.GRDet_Currency = drDetail["GRDet_Currency"].ToString(); oGRDetails.GRDet_Amount = float.Parse(drDetail["GRDet_Amount"].ToString()); //oGRDetailList.Add(oGRDetails); oGRMaster.GRMstr_DetailsList.Add(oGRDetails); } } //oGRMaster.GRMstr_DetailsList = oGRDetailList; oGRMasterList.Add(oGRMaster); } if (oGRMasterList.Count > 0) { foreach (CGRMaster oGRMaster in oGRMasterList) { progressBarImport.Value = 50; CResult oResult = new CResult(); CGRBO oGRBO = new CGRBO(); if (oGRMaster != null) { oResult = oGRBO.Create(oGRMaster); } if (oResult.IsSuccess) { progressBarImport.Value = 100; this.Cursor = Cursors.Default; oResult = oGRBO.UpdateHomeGRTable(); } progressBarImport.Value = 100; MessageBox.Show("Goods are successfully Imported", "ETLPOS", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else if (dtHome.Rows.Count <= 0) { DialogResult oDR = MessageBox.Show("You Have No Goods For Import", "ETLPOS", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (oDR.ToString() == "OK") { this.Cursor = Cursors.Default; progressBarImport.Value = 0; } } } catch { MessageBox.Show("You Have No Goods For Import", "ETLPOS", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private CGRMaster GetToBSavedDataExportBranch() { oGRFinalQtyDic.Clear(); CGRMaster oGRMaster = new CGRMaster(); oGRMaster.GRMstr_OID = txtSelectedGROID.Text.Trim(); oGRMaster.GRMstr_Branch = currentBranch.CompBrn_Code;//cmbBranch.SelectedItem.ToString(); oGRMaster.GRMstr_Code = txtGRNo.Text.Trim(); oGRMaster.GRMstr_Type = Convert.ToInt32(Enum.Parse(typeof(EGRType), ddlType.SelectedItem.ToString())); oGRMaster.GRMstr_Date = dtpGRDate.Value.Date; oGRMaster.GRMstr_By = txtRecievedBy.Text.Trim(); oGRMaster.Remarks = txtRemarks.Text.Trim(); if (currentBranch.CompBrn_OId == "CompBrnXBRN01 0000000001") { oGRMaster.GRMstr_IsImported = 0; } else if (currentBranch.CompBrn_OId != "CompBrnXBRN01 0000000001") { oGRMaster.GRMstr_IsImported = 1; } // oGRMaster.GRMstr_VendorID = ddlSupplier.SelectedValue.ToString(); oGRMaster.GRMstr_RefBy = txtRefNo.Text.Trim(); oGRMaster.Creator = currentUser.User_OID; oGRMaster.CreationDate = DateTime.Now.Date; oGRMaster.UpdateBy = currentUser.User_OID; oGRMaster.UpdateDate = DateTime.Now.Date; oGRMaster.IsActive = "Y"; oGRMaster.Remarks = ""; for (int i = 0; i < dgItemList.Rows.Count - 1; i++) { if (ValidateListItem(dgItemList.Rows[i])) { CGRDetails oGRDetails = new CGRDetails(); CCompanyBranch oCompanyBranch = (CCompanyBranch)cmbBranch.SelectedItem; oGRDetails.GR_Date = DateTime.Now.Date; oGRDetails.GRDet_Branch = oCompanyBranch.CompBrn_Code; oGRDetails.GRDet_ItemOID = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colItemName"]).Value.ToString(); if (dgItemList.Rows[i].Cells["colIssueqty"].Value != null) { oGRDetails.GRDet_QTY = float.Parse(((DataGridViewTextBoxCell)dgItemList.Rows[i].Cells["colIssueqty"]).Value.ToString()); } if (dgItemList.Rows[i].Cells["colIssueUOM"].Value != null) { oGRDetails.GRDet_UOM = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colIssueUOM"]).Value.ToString(); } oGRDetails.GRDet_BranchOID = currentBranch.CompBrn_OId; if (dgItemList.Rows[i].Cells["colSourceLoc"].Value != null) { oGRDetails.GRDet_LocOID = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colSourceLoc"]).Value.ToString(); } if (dgItemList.Rows[i].Cells["colSrcInvType"].Value != null) { oGRDetails.GRDet_InvType = Convert.ToInt32(Enum.Parse(typeof(EInvType), ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colSrcInvType"]).Value.ToString())); } if (dgItemList.Rows[i].Cells["colPrice"].Value != null) { oGRDetails.GRDet_Price = float.Parse(((DataGridViewTextBoxCell)dgItemList.Rows[i].Cells["colPrice"]).Value.ToString()); } if (dgItemList.Rows[i].Cells["colCurrency"].Value != null) { oGRDetails.GRDet_Currency = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colCurrency"]).Value.ToString(); } if (dgItemList.Rows[i].Cells["colAmount"].Value != null) { oGRDetails.GRDet_Amount = float.Parse(((DataGridViewTextBoxCell)dgItemList.Rows[i].Cells["colAmount"]).Value.ToString()); } oGRMaster.GRMstr_DetailsList.Add(oGRDetails); CGRDetails oInvGRDetails = new CGRDetails(); oInvGRDetails.GRDet_Branch = oGRDetails.GRDet_Branch; oInvGRDetails.GRDet_BranchOID = oGRDetails.GRDet_BranchOID; oInvGRDetails.GRDet_ItemOID = oGRDetails.GRDet_ItemOID; oInvGRDetails.GRDet_LocOID = oGRDetails.GRDet_LocOID; oInvGRDetails.GRDet_InvType = oGRDetails.GRDet_InvType; if (dgItemList.Rows[i].Cells["colInvtQty"].Value != null) { oInvGRDetails.GRDet_QTY = float.Parse(((DataGridViewTextBoxCell)dgItemList.Rows[i].Cells["colInvtQty"]).Value.ToString()); } else { oInvGRDetails.GRDet_QTY = 0.00f; } oGRFinalQtyDic.Add(oInvGRDetails.GRDet_ItemOID, oInvGRDetails); } else { return(null); } } foreach (string obj in oGRExistingQtyDic.Keys) { if (!oGRFinalQtyDic.ContainsKey(obj)) { CGRDetails objDetls = new CGRDetails(); objDetls.GRDet_Branch = oGRExistingQtyDic[obj].GRDet_Branch; objDetls.GRDet_BranchOID = oGRExistingQtyDic[obj].GRDet_BranchOID; objDetls.GRDet_InvType = oGRExistingQtyDic[obj].GRDet_InvType; objDetls.GRDet_ItemOID = oGRExistingQtyDic[obj].GRDet_ItemOID; objDetls.GRDet_LocOID = oGRExistingQtyDic[obj].GRDet_LocOID; objDetls.GRDet_QTY = oGRExistingQtyDic[obj].GRDet_QTY * -1; oGRFinalQtyDic.Add(obj, objDetls); } } return(oGRMaster); }
private void btnImport_Click(object sender, EventArgs e) { if (ValidationData()) { CResult oResulto = new CResult(); CGRBO oGRBOo = new CGRBO(); CGRMaster oMastero = GetToBSavedDataExportBranch(); if (oMastero != null) { oResulto = oGRBOo.CreateExportInBranch(oMastero); //if (oResulto.IsSuccess) //{ // MessageBox.Show("Successfully Done. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); // ClearFormData(); // GetGRNextCode(); //} //else //{ // MessageBox.Show(oResulto.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); //} } } #region import //if (ValidationData()) //{ SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.Title = "Save an CSV File"; saveFileDialog1.FileName = "InventoryExport.csv"; saveFileDialog1.ShowDialog(); string url = ""; if (saveFileDialog1.FileName != "") { url = saveFileDialog1.FileName; } else { url = "InventoryExport.csv"; } // Data2PDF(); CResult oResult = new CResult(); CGRBO oGRBO = new CGRBO(); CGRMaster oMaster = GetToBSavedData(); if (oMaster != null) { if (!IsUpdateMode) { oResult = oGRBO.ExportAndUpdate(oMaster, url); // SaveExcelFile(dt); } else { oResult = oGRBO.Update(oMaster, oGRFinalQtyDic); } if (oResult.IsSuccess) { MessageBox.Show("Successfully Done. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearFormData(); GetGRNextCode(); } else { MessageBox.Show(oResult.ErrMsg, "Inventory empty", MessageBoxButtons.OK, MessageBoxIcon.Error); } } // } #endregion }