public bool Sale_Detail_Insert(Sale_Detail_Info p_Sale_Detail_Info, decimal p_Sale_Header_Id)
{
try
{
SqlParameter[] spParameter = new SqlParameter[5];
int i = 0;
spParameter[i] = new SqlParameter("@Sale_Header_Id", SqlDbType.Int);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_Sale_Header_Id;
i++;
spParameter[i] = new SqlParameter("@Product_Id", SqlDbType.Int);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_Sale_Detail_Info.Product_Id;
i++;
spParameter[i] = new SqlParameter("@Status", SqlDbType.Int);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_Sale_Detail_Info.Status;
i++;
spParameter[i] = new SqlParameter("@Count", SqlDbType.Int);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_Sale_Detail_Info.Count;
i++;
spParameter[i] = new SqlParameter("@Color_Id", SqlDbType.Int);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_Sale_Detail_Info.Color_Id;
SqlHelper.ExecuteNonQuery(CommonData.ConnectionString, CommandType.StoredProcedure, "proc_Sale_Detail_Insert", spParameter);
return(true);
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
return(false);
}
}
Sale_Header_Info Get_Sale_Header(ref List <Sale_Detail_Info> p_Sale_Detail_Info)
{
try
{
Sale_Header_Info _Sale_Header_Info = new Sale_Header_Info();
_Sale_Header_Info.UserName = CommonData.c_Urser_Info.User_Name;
_Sale_Header_Info.Customer_Id = Insert_Customer();
_Sale_Header_Info.BranchId = 0;
_Sale_Header_Info.Sale_Date = ConvertData.ConvertString2Date(dpSaleDate.Text);
_Sale_Header_Info.SalesType = Convert.ToInt16(ThuChi_Type.Ban_Buon);
_Sale_Header_Info.Total_Amount = Convert.ToDecimal(txtPayPrice.Text);
_Sale_Header_Info.Debt_Amount = 0;
_Sale_Header_Info.CreatedDate = DateTime.Now;
_Sale_Header_Info.Comment = txtNote.Text;
_Sale_Header_Info.SoHoaDon = txtSaleHeader.Text;
if (txtShipPrice.Text != "")
{
_Sale_Header_Info.Ship_Price = Convert.ToDecimal(txtShipPrice.Text);
}
else
{
_Sale_Header_Info.Ship_Price = 0;
}
if (txtDiscount.Text != "")
{
_Sale_Header_Info.Discount = Convert.ToDecimal(txtDiscount.Text);
}
else
{
_Sale_Header_Info.Discount = 0;
}
if (txtPerDiscount.Text.Contains("%"))
{
_Sale_Header_Info.Per_Discont = Convert.ToDecimal(txtPerDiscount.Text.Remove(txtPerDiscount.Text.Length - 1, 1));
_Sale_Header_Info.Per_Discount_Price = 0;
}
else
{
_Sale_Header_Info.Per_Discont = 0;
if (txtPerDiscount.Text != "" && txtPerDiscount.Text != "0")
{
_Sale_Header_Info.Per_Discount_Price = Convert.ToDecimal(txtPerDiscount.Text);
}
else
{
_Sale_Header_Info.Per_Discount_Price = 0;
}
}
_Sale_Header_Info.Pay_Type = Convert.ToInt16(cboPayType.SelectedValue);
p_Sale_Detail_Info = new List <Sale_Detail_Info>();
foreach (Product_Info item in c_list_Product_Buy)
{
Sale_Detail_Info _Sale_Detail_Info = new Sale_Detail_Info();
_Sale_Detail_Info.Product_Id = item.Product_Id;
_Sale_Detail_Info.Status = Convert.ToInt16(Status_Type.DaBan);
_Sale_Detail_Info.Count = Convert.ToInt16(item.Count_Sale_By_Header);
_Sale_Detail_Info.Color_Id = Convert.ToInt16(item.Color_Id);
p_Sale_Detail_Info.Add(_Sale_Detail_Info);
}
return(_Sale_Header_Info);
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
return(null);
}
}
