private void btnUpdateBillImport_Click(object sender, EventArgs e)
{
try
{
if (txtIDBillImport.Text == "")
{
XtraMessageBox.Show("You have to choose at least one invoice to update", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PostInvoice_DTO invoice = new PostInvoice_DTO();
invoice.TransID = Convert.ToInt32(dtgvInfoListOfBillImport.CurrentRow.Cells["TransID"].Value);
invoice.VendorID = Convert.ToInt32(txtVendorId.Text);
invoice.CreateDate = Convert.ToDateTime(dtpkDateTimeImport.Text.ToString());
if (PostInvoice_BUS.UpdatePostInvoice(invoice))
{
LoadPostInvoice();
uctVendor.uctVendorInfo.LoadVendorList();
XtraMessageBox.Show("Update Post Invoice Successfully", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearDisplay();
return;
}
}catch
{
XtraMessageBox.Show("Update Post Invoice Failed!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
private void btnDeleteBillImport_Click(object sender, EventArgs e)
{
try
{
if (txtIDBillImport.Text == "")
{
XtraMessageBox.Show("You have to choose at least one invoice to delete", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PostInvoice_DTO invoice = new PostInvoice_DTO();
invoice.TransID = Convert.ToInt32(dtgvInfoListOfBillImport.CurrentRow.Cells["TransID"].Value);
if (PostInvoice_BUS.DeletePostInvoice(invoice))
{
LoadPostInvoice();
uctVendor.uctVendorInfo.LoadVendorList();
XtraMessageBox.Show("Delete Post Invoice Successfully", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearDisplay();
return;
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public static bool UpdatePostInvoice(PostInvoice_DTO invoice)
{
SqlConnection con = DataProvider.OpenConnection();
try
{
cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_UpdatePostInvoice]", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@TransID", invoice.TransID);
cmd.Parameters.Add(p);
p = new SqlParameter("@CreateDate", invoice.CreateDate);
cmd.Parameters.Add(p);
p = new SqlParameter("@VendorID", invoice.VendorID);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(con);
return(true);
}
catch
{
DataProvider.CloseConnection(con);
return(false);
}
}
private void btnAddImportBill_Click(object sender, EventArgs e)
{
try
{
if (txtIDBillImport.Text == "" || txtVendorId.Text == "" || cmbIDAgency.Text == "")
{
XtraMessageBox.Show("Missing Information!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PostInvoice_DTO postInvoice = new PostInvoice_DTO();
postInvoice.TransID = Convert.ToInt32(txtIDBillImport.Text);
postInvoice.VendorID = Convert.ToInt32(txtVendorId.Text.ToString());
postInvoice.CreateDate = Convert.ToDateTime(dtpkDateTimeImport.Text.ToString());
postInvoice.VendorName = cmbIDAgency.Text.ToString();
postInvoice.TotalPrice = 0;
if (PostInvoice_BUS.InsertPostInvoice(postInvoice))
{
XtraMessageBox.Show("Insert Post Invoice Successfully!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbIDBillImportDetail.Text = txtIDBillImport.Text;
ClearDisplay();
uctVendor.uctVendorInfo.LoadVendorList();
LoadPostInvoice();
return;
}
}
catch
{
XtraMessageBox.Show("Insert Post Invoice Failed!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public static List <PostInvoice_DTO> PostInvoiceLoad()
{
SqlConnection con = DataProvider.OpenConnection();
try
{
//con.ChangeDatabase("JEWELRYSTOREMGMT");
cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_getPostInvoice]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
da = new SqlDataAdapter();
da.SelectCommand = cmd;
dt = new DataTable();
da.Fill(dt);
}
catch
{
return(null);
}
if (dt.Rows.Count == 0)
{
return(null);
}
List <PostInvoice_DTO> PostInvoiceList = new List <PostInvoice_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
PostInvoice_DTO postInvoice = new PostInvoice_DTO();
postInvoice.TransID = Convert.ToInt32(dt.Rows[i]["TransID"].ToString());
postInvoice.VendorID = Convert.ToInt32(dt.Rows[i]["VendorID"].ToString());
postInvoice.VendorName = dt.Rows[i]["VendorName"].ToString();
postInvoice.Address = dt.Rows[i]["Address"].ToString();
postInvoice.PhoneNo = dt.Rows[i]["PhoneNo"].ToString();
postInvoice.CreateDate = Convert.ToDateTime(dt.Rows[i]["TransDate"].ToString());
postInvoice.TotalPrice = Convert.ToDouble(dt.Rows[i]["TotalPrice"].ToString());
PostInvoiceList.Add(postInvoice);
}
DataProvider.CloseConnection(con);
return(PostInvoiceList);
}
public static bool DeletePostInvoice(PostInvoice_DTO invoice)
{
SqlConnection con = DataProvider.OpenConnection();
try
{
cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_DeletePostInvoice]", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@TransID", invoice.TransID);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(con);
return(true);
}
catch (Exception ex)
{
DataProvider.CloseConnection(con);
MessageBox.Show(ex.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public static bool DeletePostInvoice(PostInvoice_DTO invoice)
{
return(PostInvoice_DAL.DeletePostInvoice(invoice));
}
public static bool UpdatePostInvoice(PostInvoice_DTO invoice)
{
return(PostInvoice_DAL.UpdatePostInvoice(invoice));
}
public static bool InsertPostInvoice(PostInvoice_DTO invoice)
{
return(PostInvoice_DAL.InsertPostInvoice(invoice));
}
