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 CGRDetails GetResultSetToGRDetails(DataRow dr) { CGRDetails oGRDetails = new CGRDetails(); oGRDetails.GRDet_OID = dr["GRDet_OID"].ToString(); oGRDetails.GRDet_MStrOID = dr["GRDet_MStrOID"].ToString(); oGRDetails.GRDet_ItemOID = dr["GRDet_ItemOID"].ToString(); oGRDetails.GRDet_QTY = float.Parse(dr["GRDet_QTY"].ToString()); oGRDetails.GRDet_UOM = dr["GRDet_UOM"].ToString(); oGRDetails.GRDet_BranchOID = dr["GRDet_BranchOID"].ToString(); oGRDetails.GRDet_LocOID = dr["GRDet_LocOID"].ToString(); oGRDetails.GRDet_InvType = int.Parse(dr["GRDet_InvType"].ToString()); oGRDetails.GRDet_Currency = dr["GRDet_Currency"].ToString(); oGRDetails.GRDet_Price = float.Parse(dr["GRDet_Price"].ToString()); oGRDetails.GRDet_Amount = float.Parse(dr["GRDet_Amount"].ToString()); return(oGRDetails); }
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); }