private CPurchase GetResultSetToParty(DataRow dr) { CPurchase oPurchase = new CPurchase(); oPurchase.Purchase_OID = dr[0].ToString(); oPurchase.Purchase_Branch = dr[1].ToString(); oPurchase.Purchase_PartyOID = dr[2].ToString(); oPurchase.Purchase_PartyName = dr[16].ToString(); oPurchase.Purchase_GroupID = dr[3].ToString(); oPurchase.Purchase_GroupName = dr[17].ToString(); oPurchase.Purchase_Description = dr[4].ToString(); oPurchase.Purchase_Quantity = float.Parse(dr[5].ToString()); oPurchase.Purchase_Amount = float.Parse(dr[6].ToString()); oPurchase.Purchase_CurrencyName = dr[18].ToString(); oPurchase.Purchase_CurrencyOID = dr[7].ToString(); oPurchase.Purchase_CurrencyRate = float.Parse(dr[8].ToString()); oPurchase.Purchase_Invoice = dr[9].ToString(); oPurchase.Purchase_Date = DateTime.Parse(dr[10].ToString()); if ((bool)dr[11] == true) { oPurchase.Purchase_Status = 1; } else if ((bool)dr[11] == false) { oPurchase.Purchase_Status = 0; } oPurchase.Purchase_Creator = dr[12].ToString(); oPurchase.Purchase_CreationDate = DateTime.Parse(dr[13].ToString()); oPurchase.Purchase_UpdateBy = dr[14].ToString(); oPurchase.Purchase_UpdateDate = DateTime.Parse(dr[15].ToString()); return(oPurchase); }
private CPurchase GetFormData(CPurchase oPurchase) { if (txtOId.Text != "") { oPurchase.Purchase_OID = txtOId.Text.Trim(); } oPurchase.Purchase_Branch = currentBranch.CompBrn_Code; oPurchase.Purchase_PartyOID = ddlPartyName.SelectedValue.ToString(); oPurchase.Purchase_PartyName = ddlPartyName.SelectedText; oPurchase.Purchase_GroupID = ddlGroupName.SelectedValue.ToString(); oPurchase.Purchase_GroupName = ddlGroupName.SelectedText; oPurchase.Purchase_Description = txtDescription.Text.Trim(); oPurchase.Purchase_Quantity = float.Parse(txtPurchaseQuantity.Text.Trim()); oPurchase.Purchase_Amount = float.Parse(txtPurchaseAmount.Text.Trim()); oPurchase.Purchase_CurrencyOID = ddlCurrencyName.SelectedValue.ToString(); oPurchase.Purchase_CurrencyRate = float.Parse(txtPurchaseCurrencyRate.Text.Trim()); oPurchase.Purchase_Invoice = txtPurchaseInvoiceNo.Text.Trim(); oPurchase.Purchase_Date = dtpPurchaseDate.Value.Date; if (rbYes.Checked == true) { oPurchase.Purchase_Status = 1; } else if (rbYes.Checked == false) { oPurchase.Purchase_Status = 0; } oPurchase.Purchase_Creator = currentUser.User_OID; oPurchase.CreationDate = DateTime.Now.Date; oPurchase.Purchase_UpdateBy = currentUser.User_OID; oPurchase.UpdateDate = DateTime.Now.Date; return(oPurchase); }
private CPurchase GetFormData() { CPurchase oPurchase = new CPurchase(); oPurchase.Purchase_OID = txtOId.Text.Trim(); return(oPurchase); }
private void lvPurchasetList_DoubleClick(object sender, EventArgs e) { if (lvPurchasetList.SelectedItems.Count > 0) { CPurchase oPurchase = lvPurchasetList.FocusedItem.Tag as CPurchase; txtOId.Text = oPurchase.Purchase_OID; ddlPartyName.SelectedText = oPurchase.Purchase_PartyName; ddlPartyName.SelectedValue = oPurchase.Purchase_PartyOID; ddlGroupName.SelectedText = oPurchase.Purchase_GroupName; ddlGroupName.SelectedValue = oPurchase.Purchase_GroupID; txtDescription.Text = oPurchase.Purchase_Description.Trim(); txtPurchaseQuantity.Text = oPurchase.Purchase_Quantity.ToString(); txtPurchaseAmount.Text = oPurchase.Purchase_Amount.ToString(); ddlCurrencyName.SelectedText = oPurchase.Purchase_CurrencyName; ddlCurrencyName.SelectedValue = oPurchase.Purchase_CurrencyOID; txtPurchaseCurrencyRate.Text = oPurchase.Purchase_CurrencyRate.ToString(); txtPurchaseInvoiceNo.Text = oPurchase.Purchase_Invoice; dtpPurchaseDate.Value = oPurchase.Purchase_Date.Date; if (oPurchase.Purchase_Status == 1) { rbYes.Select(); } else if (oPurchase.Purchase_Status != 1) { rbNo.Select(); } } }
public CResult Create(CPurchase oPurchase) { 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_Purchase_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Purchase_Branch", oPurchase.Purchase_Branch); cmd.Parameters.AddWithValue("@Purchase_PartyOID", oPurchase.Purchase_PartyOID); cmd.Parameters.AddWithValue("@Purchase_GroupID", oPurchase.Purchase_GroupID); cmd.Parameters.AddWithValue("@Purchase_Description", oPurchase.Purchase_Description); cmd.Parameters.AddWithValue("@Purchase_Quantity", oPurchase.Purchase_Quantity); cmd.Parameters.AddWithValue("@Purchase_Amount", oPurchase.Purchase_Amount); cmd.Parameters.AddWithValue("@Purchase_CurrencyOID", oPurchase.Purchase_CurrencyOID); cmd.Parameters.AddWithValue("@Purchase_CurrencyRate", oPurchase.Purchase_CurrencyRate); cmd.Parameters.AddWithValue("@Purchase_Invoice", oPurchase.Purchase_Invoice); cmd.Parameters.AddWithValue("@Purchase_Date", oPurchase.Purchase_Date); cmd.Parameters.AddWithValue("@Purchase_Status", oPurchase.Purchase_Status); cmd.Parameters.AddWithValue("@Purchase_Creator", oPurchase.Purchase_Creator); cmd.Parameters.AddWithValue("@Purchase_CreationDate", oPurchase.Purchase_CreationDate); cmd.Parameters.AddWithValue("@Purchase_UpdateBy", oPurchase.Purchase_UpdateBy); cmd.Parameters.AddWithValue("@Purchase_UpdateDate", oPurchase.Purchase_UpdateDate); 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 Delete(CPurchase oPurchase) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_Purchase_Delete"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Purchase_OID", oPurchase.Purchase_OID); cmd.Parameters.Add("@IsSuccess", SqlDbType.Char, 1); cmd.Parameters["@IsSuccess"].Direction = ParameterDirection.ReturnValue; cmd.ExecuteNonQuery(); string st = cmd.Parameters["@IsSuccess"].Value.ToString(); oConnManager.Commit(); oResult.Data = st; 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); }
private void btnUpdate_Click(object sender, EventArgs e) { CPurchase oPayment = lvPurchasetList.FocusedItem.Tag as CPurchase; CPurchaseBO oPartyBO = new CPurchaseBO(); CResult oResult = new CResult(); if (ValidateData()) { oResult = oPartyBO.Update(GetFormData(oPayment)); if (oResult.IsSuccess) { MessageBox.Show("Update successfully"); FillPurchaseList(); } else { MessageBox.Show("Not Updated" + oResult.ErrMsg + ""); } ClearControl(groupBox1); FillPurchaseList(); } }
private void btnSave_Click(object sender, EventArgs e) { CPurchase oPurchase = new CPurchase(); CPurchaseBO oPurchaseBO = new CPurchaseBO(); CResult oResult = new CResult(); if (ValidateData()) { oResult = oPurchaseBO.Create(GetFormData(oPurchase)); if (oResult.IsSuccess) { MessageBox.Show(" Saved successfully "); FillPurchaseList(); } else { MessageBox.Show(" Not Saved " + oResult.ErrMsg + ""); } ClearControl(groupBox1); } }
private void btnDelete_Click(object sender, EventArgs e) { if (txtOId.Text != string.Empty) { if ((MessageBox.Show("Do u really want to delete this item. ", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)) == DialogResult.Yes) { CPurchase oPurchase = GetFormData(); CPurchaseBO oPurchaseBO = new CPurchaseBO(); CResult oresult = new CResult(); oresult = oPurchaseBO.Delete(oPurchase); if (oresult.IsSuccess == true) { //if (oresult.Data.ToString() == "0") //{ // MessageBox.Show("Deletion Not Possible", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); // FillPaymentList(); // ClearControl(groupBox1); //} //else //{ MessageBox.Show("Deleted Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); FillPurchaseList(); ClearControl(groupBox1); //} } else { MessageBox.Show("Error" + oresult.ErrMsg + ""); } } } }