public static bool DeletePostInvoiceDetails(PostInvoiceDetails_DTO invoice)
{
SqlConnection con = DataProvider.OpenConnection();
try
{
cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_deletePostInvoice_Details]", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@TransDetailsID", invoice.TransDetailsID);
cmd.Parameters.Add(p);
p = new SqlParameter("@ProductID", invoice.ProductID);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(con);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Notification", MessageBoxButtons.OK, MessageBoxIcon.Error);
DataProvider.CloseConnection(con);
return(false);
}
}
private void btnDeleteProductImportDetail_Click(object sender, EventArgs e)
{
try
{
if (cmbIDProductDetailStore.Text == "" || txtQuantity.Text == "" || txtWeight.Text == "" || txtTransPrice.Text == "")
{
XtraMessageBox.Show("You have to choose at least 1 field to delete", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PostInvoiceDetails_DTO invoiceDetails = new PostInvoiceDetails_DTO();
invoiceDetails.TransDetailsID = txtTransDetailsID.Text;
invoiceDetails.ProductID = txtProductID.Text;
if (PostInvoiceDetails_BUS.DeletePostInvoiceDetails(invoiceDetails))
{
LoadPostInvoice();
LoadPostInvoiceDetails();
XtraMessageBox.Show("Delete details sucessfully!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearDisplay1();
return;
}
}catch
{
XtraMessageBox.Show("Xóa chi tiết hóa đơn thất bại ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
private void btnAddProductImportDetail_Click(object sender, EventArgs e)
{
try
{
if (cmbIDProductDetailStore.Text == "" || txtQuantity.Text == "" || txtWeight.Text == "" || txtTransPrice.Text == "")
{
XtraMessageBox.Show("You have to fullfill all fields!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PostInvoiceDetails_DTO invoiceDetails = new PostInvoiceDetails_DTO();
invoiceDetails.TransID = cmbIDBillImportDetail.Text;
invoiceDetails.ProductName = cmbIDProductDetailStore.Text;
invoiceDetails.ProductCategoryName = cmbProductCategory.Text;
invoiceDetails.UnitName = cmbUnit.Text;
invoiceDetails.TransQuantity = Convert.ToInt32(txtQuantity.Text.ToString());
invoiceDetails.Weight = txtWeight.Text;
invoiceDetails.TransPrice = txtTransPrice.Text;
if (PostInvoiceDetails_BUS.InsertPostInvoiceDetails(invoiceDetails))
{
LoadPostInvoice();
LoadPostInvoiceDetails();
XtraMessageBox.Show("Insert details sucessfully!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
//uctSanPhamCH.uctSPCH.LoadSanPhamCH1();
ClearDisplay1();
return;
}
}catch
{
XtraMessageBox.Show("Sản phẩm đã tồn tại trong Hóa đơn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public static List <PostInvoiceDetails_DTO> LoadPostInvoiceDetails(int transId)
{
SqlConnection con = DataProvider.OpenConnection();
try
{
cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_getPostInvoice_Details]", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@TransID", transId);
cmd.Parameters.Add(p);
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 <PostInvoiceDetails_DTO> postInvoiceDetailsList = new List <PostInvoiceDetails_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
PostInvoiceDetails_DTO postInvoiceDetails = new PostInvoiceDetails_DTO();
postInvoiceDetails.TransDetailsID = dt.Rows[i]["TransDetailsID"].ToString();
postInvoiceDetails.ProductID = dt.Rows[i]["ProductID"].ToString();
postInvoiceDetails.ProductName = dt.Rows[i]["ProductName"].ToString();
postInvoiceDetails.ProductCategoryName = dt.Rows[i]["ProductCategoryName"].ToString();
postInvoiceDetails.TransQuantity = Convert.ToInt32(dt.Rows[i]["TransQuantity"].ToString());
postInvoiceDetails.UnitName = dt.Rows[i]["UnitName"].ToString();
postInvoiceDetails.TransPrice = dt.Rows[i]["TransPrice"].ToString();
postInvoiceDetails.Weight = dt.Rows[i]["Weight"].ToString();
postInvoiceDetailsList.Add(postInvoiceDetails);
}
DataProvider.CloseConnection(con);
return(postInvoiceDetailsList);
}
private void btnUpdateProductImportDetail_Click(object sender, EventArgs e)
{
try
{
if (cmbIDProductDetailStore.Text == "" || txtQuantity.Text == "" || txtWeight.Text == "" || txtTransPrice.Text == "")
{
XtraMessageBox.Show("You have to choose at least 1 field to update", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PostInvoiceDetails_DTO invoiceDetails = new PostInvoiceDetails_DTO();
invoiceDetails.TransID = cmbIDBillImportDetail.Text;
invoiceDetails.TransDetailsID = txtTransDetailsID.Text;
invoiceDetails.ProductID = txtProductID.Text;
invoiceDetails.ProductName = cmbIDProductDetailStore.Text;
invoiceDetails.ProductCategoryName = cmbProductCategory.Text;
invoiceDetails.UnitName = cmbUnit.Text;
invoiceDetails.TransQuantity = Convert.ToInt32(txtQuantity.Text.ToString());
invoiceDetails.Weight = txtWeight.Text;
invoiceDetails.TransPrice = txtTransPrice.Text;
if (PostInvoiceDetails_BUS.UpdatePostInvoiceDetails(invoiceDetails))
{
LoadPostInvoice();
LoadPostInvoiceDetails();
XtraMessageBox.Show("Update details sucessfully!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearDisplay1();
return;
}
}catch
{
XtraMessageBox.Show("Chi tiết phiếu nhập hàng cập nhật thất bại !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public static bool InsertPostInvoiceDetails(PostInvoiceDetails_DTO invoice)
{
SqlConnection con = DataProvider.OpenConnection();
cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_insertPostInvoice_Details]", con);
try
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@TransID", invoice.TransID);
cmd.Parameters.Add(p);
p = new SqlParameter("@ProductName", invoice.ProductName);
cmd.Parameters.Add(p);
p = new SqlParameter("@ProductCategoryName", invoice.ProductCategoryName);
cmd.Parameters.Add(p);
p = new SqlParameter("@UnitName", invoice.UnitName);
cmd.Parameters.Add(p);
p = new SqlParameter("@TransQuantity", invoice.TransQuantity);
cmd.Parameters.Add(p);
p = new SqlParameter("@Weight", invoice.Weight);
cmd.Parameters.Add(p);
p = new SqlParameter("@TransPrice", invoice.TransPrice);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(con);
return(true);
}
catch
{
DataProvider.CloseConnection(con);
return(false);
}
}
public static bool DeletePostInvoiceDetails(PostInvoiceDetails_DTO invoice)
{
return(PostInvoiceDetails_DAL.DeletePostInvoiceDetails(invoice));
}
public static bool UpdatePostInvoiceDetails(PostInvoiceDetails_DTO invoice)
{
return(PostInvoiceDetails_DAL.UpdatePostInvoiceDetails(invoice));
}
public static bool InsertPostInvoiceDetails(PostInvoiceDetails_DTO invoice)
{
return(PostInvoiceDetails_DAL.InsertPostInvoiceDetails(invoice));
}
