private void SaveCommit()
{
using (SSLsEntities db = new SSLsEntities())
{
PriceSchedule ps = new PriceSchedule();
int currentYear = DateTime.Now.Year;
int currentMonth = DateTime.Now.Month;
var pro = db.PriceSchedule.Where(w => w.CreateDate.Year == currentYear && w.CreateDate.Month == currentMonth).Count() + 1;
string proCodeGen = SingletonThisBudgetYear.Instance().ThisYear.CodeYear + DateTime.Now.ToString("MM") + Library.GenerateCodeFormCount(pro, 3);
ps.Code = proCodeGen;
ps.Enable = true;
ps.Name = textBoxProName.Text;
ps.Description = textBoxRemark.Text;
ps.CreateDate = DateTime.Now;
ps.CreateBy = SingletonAuthen.Instance().Id;
ps.UpdateDate = DateTime.Now;
ps.UpdateBy = SingletonAuthen.Instance().Id;
ps.FKCampaign = MyConstant.CampaignType.FullyAmountAndDiscount;
// dd/MM/yyyy
string[] date = dateTimePickerStart.Text.Split('/');
ps.StartDate = Library.ConvertDateTime(date[0], date[1], date[2]);
//ps.StartDate = DateTime.Parse(dateTimePickerStart.Text);
date = dateTimePickerEnd.Text.Split('/');
ps.EndDate = Library.ConvertDateTime(date[0], date[1], date[2]);
//ps.EndDate = DateTime.Parse(dateTimePickerEnd.Text);
ps.Limited = 0;
ps.Notice = textBoxProNotice.Text;
ps.FullPrice = decimal.Parse(textBoxProAmount.Text);
ps.FullQty = 0;
ps.Discount = decimal.Parse(textBoxProDiscount.Text);
ps.IsStop = false;
List <SellingPrice> details = new List <SellingPrice>();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
details.Add(new SellingPrice()
{
CreateBy = SingletonAuthen.Instance().Id,
CreateDate = DateTime.Now,
Description = dataGridView1.Rows[i].Cells[colRemark].Value.ToString(),
Enable = true,
FKProduct = int.Parse(dataGridView1.Rows[i].Cells[colId].Value.ToString()),
GetCurrentPrice = decimal.Parse(dataGridView1.Rows[i].Cells[colCurrentPrice].Value.ToString()),
Name = textBoxProName.Text,
SpecialPrice = 0,
UpdateDate = DateTime.Now,
UpdateBy = SingletonAuthen.Instance().Id
});
if (i >= dataGridView1.Rows.Count - 2)
{
break;
}
}
ps.SellingPrice = details;
db.PriceSchedule.Add(ps);
db.SaveChanges();
}
// reset all
ResetForm();
}
/// <summary>
/// ตกลง ต่อเวลา
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
using (SSLsEntities db = new SSLsEntities())
{
priceSchedule = db.PriceSchedule.SingleOrDefault(w => w.Id == priceSchedule.Id);
priceSchedule.StartDate = dateTimePickerStart.Value;
priceSchedule.EndDate = dateTimePickerEnd.Value;
priceSchedule.UpdateDate = DateTime.Now;
priceSchedule.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
db.Entry(priceSchedule).State = EntityState.Modified;
db.SaveChanges();
this.searchEditPromotionForm.Reload();
this.Dispose();
}
}
public SearchEditLongTimeDialog(SearchEditPromotionForm searchEditPromotionForm, PriceSchedule priceSchedule)
{
InitializeComponent();
this.searchEditPromotionForm = searchEditPromotionForm;
this.priceSchedule = priceSchedule;
}
private void SaveCommit()
{
var thisBudget = SingletonThisBudgetYear.Instance().ThisYear;
using (SSLsEntities db = new SSLsEntities())
{
int currentYear = DateTime.Now.Year;
int currentMonth = DateTime.Now.Month;
var pro = db.PriceSchedule.Where(w => w.CreateDate.Year == currentYear && w.CreateDate.Month == currentMonth).Count() + 1;
string code = thisBudget.CodeYear + DateTime.Now.ToString("MM") + Library.GenerateCodeFormCount(pro, 3);
PriceSchedule header = new PriceSchedule();
header.Code = code;
header.Enable = true;
header.Name = textBoxProName.Text;
header.Description = textBoxRemark.Text;
header.CreateDate = DateTime.Now;
header.CreateBy = SingletonAuthen.Instance().Id;
header.UpdateBy = SingletonAuthen.Instance().Id;
header.UpdateDate = DateTime.Now;
header.FKCampaign = MyConstant.CampaignType.FullyQtyAndGift;
header.StartDate = dateTimePickerStart.Value;
header.EndDate = dateTimePickerEnd.Value;
header.Limited = 0;
header.Notice = textBoxProNotice.Text;
header.FullPrice = 0;
header.FullQty = 0;
header.Discount = 0;
header.IsStop = false;
header.StopReason = null;
/// ต้อง Row เท่ากัน
if (dataGridView1.Rows.Count == dataGridView2.Rows.Count)
{
SellingPrice selling;
SellingPriceDetails details;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
selling = new SellingPrice();
selling.CreateDate = DateTime.Now;
selling.CreateBy = SingletonAuthen.Instance().Id;
selling.Enable = true;
selling.Name = header.Name;
selling.Description = null;
selling.UpdateDate = DateTime.Now;
selling.UpdateBy = SingletonAuthen.Instance().Id;
selling.FKProduct = int.Parse(dataGridView1.Rows[i].Cells[col1Id].Value.ToString());
selling.GetCurrentPrice = decimal.Parse(dataGridView1.Rows[i].Cells[col1Price].Value.ToString());
selling.SpecialPrice = 0;
selling.FullyQty = decimal.Parse(dataGridView1.Rows[i].Cells[col1Qty].Value.ToString());
/// ส่วนของแถม
details = new SellingPriceDetails();
details.Enable = true;
details.Name = header.Name;
details.CreateDate = DateTime.Now;
details.CreateBy = SingletonAuthen.Instance().Id;
details.UpdateDate = DateTime.Now;
details.UpdateBy = SingletonAuthen.Instance().Id;
details.FKProduct = int.Parse(dataGridView2.Rows[i].Cells[col2Id].Value.ToString());
details.GiftQty = decimal.Parse(dataGridView2.Rows[i].Cells[col2Qty].Value.ToString());
details.GetCurrentPrice = decimal.Parse(dataGridView2.Rows[i].Cells[col2Price].Value.ToString());
details.SpecialPrice = 0;
selling.SellingPriceDetails.Add(details);
header.SellingPrice.Add(selling);
if (i >= dataGridView1.Rows.Count - 2)
{
break;
}
}
}
else
{
MessageBox.Show("พบข้อผิดพลาดกรุณาตรวจสอบดูอีกครั้ง");
}
db.PriceSchedule.Add(header);
db.SaveChanges();
// reset all
ResetForm();
}
}