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 + "");
}
}
}
}
