private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateChildren())
{
return;
}
String CustomerPID = (String)customerTableAdapter.InsertQuery(
tbxPID.Text,
Convert.ToByte(cbxPrename.SelectedValue),
tbxfName.Text,
tbxlName.Text,
cbxCompany.SelectedValue == null ? new Int32?() : Convert.ToInt32(cbxCompany.SelectedValue),
tbxAddress.Text,
tbxStreed.Text,
tbxPhone.Text,
tbxMobile.Text,
cbxCityID.SelectedValue == null ? new Int32?() : Convert.ToInt32(cbxCityID.SelectedValue),
cbxDistrictID.SelectedValue == null ? new Int32?() : Convert.ToInt32(cbxDistrictID.SelectedValue),
cbxProvinceID.SelectedValue == null ? new Int32?() : Convert.ToInt32(cbxProvinceID.SelectedValue),
cbxPostCode.SelectedValue == null ? new Int32?() : Convert.ToInt32(cbxPostCode.SelectedValue));
if (CustomerPID != null)
{
UserLogTableAdapter logTableAdapter = new UserLogTableAdapter();
logTableAdapter.Insert(TypeUtil.Customer, CustomerPID, MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
DialogResult = DialogUtil.AddSuccess();
}
else
{
DialogResult = DialogUtil.AddError();
}
}
private void btnChange_Click(object sender, EventArgs e)
{
if (!tbxPassword.Text.Trim().Equals(tbxConfirmPassword.Text.Trim()))
{
MessageBox.Show("รหัสผ่านไม่ตรงกัน, กรุณาลองใหม่อีกครั้ง", "รหัสผ่านไม่ตรงกัน", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
if (tbxPassword.Text.Trim().Length < 6)
{
MessageBox.Show("รหัสผ่านสั้นเกินไป, กรุณาลองใหม่อีกครั้ง", "รหัสผ่านสั้นเกินไป", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
if (ValidateChildren())
{
usersBindingSource.EndEdit();
if (1 == usersTableAdapter.Update(farmManageDataSet.Users))
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.User, UserID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CHANGE_PASSWORD, DateTime.Now);
DialogResult = DialogUtil.SaveSuccess();
}
else
{
DialogResult = DialogUtil.SaveError();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
gxbDetail.Enabled = false;
btnSave.Enabled = false;
if (Validate())
{
usersBindingSource.EndEdit();
if (1 == usersTableAdapter.Update(farmManageDataSet.Users))
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.User, UserID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_MODIFY, DateTime.Now);
DialogResult = DialogUtil.SaveSuccess();
}
else
{
DialogResult = DialogUtil.SaveError();
}
}
else
{
gxbDetail.Enabled = true;
btnSave.Enabled = true;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (AddStockID == 0)
{
if (dgvAddList.Rows.Count == 0)
{
MessageBox.Show("ไม่มีรายการที่เพิ่มอย่างสมบูรณ์ กรุณาเพิ่มหรือป้อนข้อมูลให้ครบ");
return;
}
for (var i = 0; i < dgvAddList.Rows.Count - 1; i++)
{
if (dgvAddList.Rows[i].Cells[0].Value == null || Convert.ToDouble(dgvAddList.Rows[i].Cells[1].Value) == 0 || Convert.ToDouble(dgvAddList.Rows[i].Cells[2].Value) == 0)
{
MessageBox.Show("ข้อมูลไม่ครบ กรุณาลองใหม่อีกครั้ง");
return;
}
}
int StockAddID = (int)stockAddTableAdapter.InsertQuery(
Convert.ToInt32(cbxBy.SelectedValue),
dtpDate.Value,
Convert.ToDouble(tbxTotal.Text));
if (StockAddID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.StockAdd, AddStockID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
for (var i = 0; i < dgvAddList.Rows.Count; i++)
{
var stockAddListID = (int)stockAddListTableAdapter.InsertQuery(
StockAddID,
Convert.ToInt32(dgvAddList.Rows[i].Cells[0].Value),
Convert.ToDouble(dgvAddList.Rows[i].Cells[1].Value),
Convert.ToDouble(dgvAddList.Rows[i].Cells[2].Value),
Convert.ToDouble(dgvAddList.Rows[i].Cells[3].Value),
dgvAddList.Rows[i].Cells[4].Value == null ? string.Empty : dgvAddList.Rows[i].Cells[4].Value.ToString());
if (stockAddListID > 0)
{
log.Insert(TypeUtil.StockAddList, stockAddListID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
stockTableAdapter.UpdateAddUnit(Convert.ToDouble(dgvAddList.Rows[i].Cells[1].Value), Convert.ToInt32(dgvAddList.Rows[i].Cells[0].Value));
}
}
DialogResult = DialogUtil.AddSuccess();
}
else
{
DialogResult = DialogUtil.AddError();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateChildren())
{
return;
}
if (Option)
{
OptionByID = Convert.ToInt32(cbxBy.SelectedValue);
OptionStockID = Convert.ToInt32(cbxStock.SelectedValue);
OptionUnit = Convert.ToDouble(tbxUnit.Text);
OptionDate = this.dtpDate.Value;
this.DialogResult = System.Windows.Forms.DialogResult.Yes;
}
else
{
var Msg = new StringBuilder();
var CurrentUnit = this.stockTableAdapter.QueryCurrentUnit(Convert.ToInt32(cbxStock.SelectedValue));
if (CurrentUnit < Convert.ToDouble(tbxUnit.Text))
{
Msg.Append(String.Format("{0} จำนวนปัจจุบัน:{1} จำนวนที่ต้องการ:{2}\n", stockTableAdapter.GetDataByPK(Convert.ToInt32(cbxStock.SelectedValue))[0].Name, CurrentUnit, Convert.ToDouble(tbxUnit.Text)));
}
if (Msg.Length != 0)
{
MessageBox.Show(String.Format("พัสดุไม่พอ \n{0}\n กรุณาลองใหม่อีกครั้ง", Msg), "ข้อผิดผลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
int VaccineID = (int)this.vaccineTableAdapter.InsertQuery(
Convert.ToInt32(cbxBy.SelectedValue),
cbxCow.SelectedValue.ToString(),
Convert.ToInt32(cbxStock.SelectedValue),
Convert.ToDouble(tbxUnit.Text),
dtpDate.Value);
if (VaccineID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.Vaccine, VaccineID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
this.stockTableAdapter.UpdateRemoveUnit(Convert.ToDouble(tbxUnit.Text), Convert.ToInt32(cbxStock.SelectedValue));
this.DialogResult = DialogUtil.AddSuccess();
}
else
{
this.DialogResult = DialogUtil.AddError();
}
}
}
}
private void initalLogin()
{
pnlContent.Enabled = false;
btnLogin.Enabled = false;
var UsersTableAdapter = new UsersTableAdapter();
var users = UsersTableAdapter.GetDataByUserLogIn(cbxUsername.Text.Trim().ToLower(), tbxPassword.Text.Trim().ToLower());
if (users.Count == 0)
{
this.pnlContent.Enabled = true;
this.btnLogin.Enabled = true;
this.tbxPassword.Text = String.Empty;
MessageBox.Show("ชื่อผู้ใช้หรือรหัสผ่านไม่ถูกต้อง", "ชื่อผู้ใช้หรือรหัสผ่านไม่ถูกต้อง", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
var list = Properties.Settings.Default.fUsernameList;
var lists = list.Split('|');
if (lists.Length > 0 && list.Trim().Length != 0)
{
var result = string.Empty;
for (var i = 0; i < lists.Length; i++)
{
if (!cbxUsername.Text.Trim().Equals(lists[i]))
{
if (i == 0)
{
result += lists[i];
}
else
{
result += "|" + lists[i];
}
}
}
result = String.Format("{0}|{1}", cbxUsername.Text.Trim(), result);
Properties.Settings.Default.fUsernameList = result;
Properties.Settings.Default.Save();
}
else
{
Properties.Settings.Default.fUsernameList = cbxUsername.Text;
Properties.Settings.Default.Save();
}
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.User, users[0].UserID.ToString(), users[0].UserID, TypeUtil.EVENT_USER_LOGIN, DateTime.Now);
MainForm.User = users[0];
DialogResult = System.Windows.Forms.DialogResult.Yes;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (OrderOutID > 0)
{
this.Validate();
this.deadViewBindingSource.EndEdit();
this.fKCowOrderOut1BindingSource.EndEdit();
Int32 result = this.deadViewTableAdapter.Update(this.farmManageDataSet.DeadView);
if (result == 1)
{
this.DialogResult = DialogUtil.SaveSuccess();
}
else
{
this.DialogResult = DialogUtil.SaveError();
}
}
else
{
OrderOutID = (int)this.deadViewTableAdapter.InsertQuery(
(byte)2,
Convert.ToInt32(this.cbxBy.SelectedValue),
this.dtpDate.Value,
this.tbxDescription.Text);
if (OrderOutID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.OrderOut, OrderOutID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
foreach (DataGridViewRow row in this.dgvCowAdd.Rows)
{
Int32 tCorralID = Convert.ToInt32(row.Cells["colCorral"].Value);
String tCowNO = row.Cells["colCowNO"].Value.ToString();
int result = this.cowTableAdapter.UpdateCowOrderOut(OrderOutID, new Double?(), tCowNO);
if (result == 1)
{
log.Insert(TypeUtil.Cow, tCowNO, MainForm.User.UserID, TypeUtil.EVENT_DEAD, DateTime.Now);
this.corralTableAdapter.UpdateRemoveCurrent(1, tCorralID);
}
}
this.DialogResult = DialogUtil.AddSuccess();
}
else
{
this.DialogResult = DialogUtil.AddError();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
customerBindingSource.EndEdit();
customerTableAdapter.Update(farmManageDataSet.Customer);
orderInBindingSource.EndEdit();
orderInTableAdapter.Update(farmManageDataSet.OrderIn);
var userLogTableAdapter = new UserLogTableAdapter();
userLogTableAdapter.Insert(TypeUtil.OrderIn, OrderInID.ToString(), MainForm.User.UserID, 1, DateTime.Now);
DialogResult = DialogUtil.SaveSuccess();
}
private void btnSave_Click(object sender, EventArgs e)
{
Convert.ToByte(cbxOrderType.SelectedValue);
Convert.ToByte(cbxPaymentStatus.SelectedValue);
orderOutBindingSource.EndEdit();
orderOutTableAdapter.Update(farmManageDataSet.OrderOut);
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.OrderOut, OrderOutID.ToString(), MainForm.User.UserID, 1, DateTime.Now);
DialogResult = DialogUtil.SaveSuccess();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateChildren())
{
stockBindingSource.EndEdit();
int result = stockTableAdapter.Update(farmManageDataSet.Stock);
if (result == 1)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.Stock, StockID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_MODIFY, DateTime.Now);
}
DialogResult = DialogUtil.SaveSuccess();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (ValidateChildren())
{
tcMain.Enabled = false;
btnSave.Enabled = false;
customerBindingSource.EndEdit();
if (1 == customerTableAdapter.Update(farmManageDataSet.Customer))
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.Customer, CustomerPID, MainForm.User.UserID, TypeUtil.EVENT_MODIFY, DateTime.Now);
}
DialogResult = DialogUtil.SaveSuccess();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!this.ValidateChildren())
{
return;
}
if (CorralID > 0)
{
this.Validate();
this.corralBindingSource.EndEdit();
var ResultId = this.corralTableAdapter.Update(farmManageDataSet.Corral);
if (ResultId == 1)
{
UserLogTableAdapter logTableAdapter = new UserLogTableAdapter();
logTableAdapter.Insert(TypeUtil.Corral, CorralID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_MODIFY, DateTime.Now);
DialogUtil.SaveSuccess();
this.DialogResult = DialogResult.Yes;
}
else
{
DialogUtil.SaveError();
this.DialogResult = DialogResult.No;
}
}
else
{
CorralID = (int)this.corralTableAdapter.InsertQuery(tbxName.Text.Trim(), Convert.ToInt32(tbxMax.Text), Convert.ToInt32(tbxCurrent.Text), tbxDescription.Text.Trim());
if (CorralID > 0)
{
UserLogTableAdapter logTableAdapter = new UserLogTableAdapter();
logTableAdapter.Insert(TypeUtil.Corral, CorralID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_MODIFY, DateTime.Now);
DialogUtil.AddSuccess();
this.DialogResult = DialogResult.Yes;
}
else
{
DialogUtil.AddError();
this.DialogResult = DialogResult.No;
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!this.ValidateChildren())
{
return;
}
if (StockID != 0)
{
this.Validate();
this.stockBindingSource.EndEdit();
if (1 == stockTableAdapter.Update(farmManageDataSet.Stock))
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.Stock, StockID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
DialogResult = DialogUtil.SaveSuccess();
}
else
{
DialogResult = DialogUtil.SaveError();
}
}
else
{
StockID = (int)stockTableAdapter.InsertQuery(tbxSuppliesName.Text, Convert.ToDouble(tbxUnit.Text), Convert.ToByte(cbxSuppliesType.SelectedValue), tbxDescription.Text);
if (StockID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.Stock, StockID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
DialogResult = DialogUtil.AddSuccess();
}
else
{
DialogResult = DialogUtil.AddError();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!this.ValidateChildren())
{
return;
}
CompanyTableAdapter companyTableAdapter = new CompanyTableAdapter();
CompanyID = (int)companyTableAdapter.InsertQuery(this.tbxName.Text.Trim());
if (CompanyID > 0)
{
UserLogTableAdapter logTableAdapter = new UserLogTableAdapter();
logTableAdapter.Insert(TypeUtil.Gene, CompanyID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
this.DialogResult = DialogUtil.AddSuccess();
}
else
{
this.DialogResult = DialogUtil.AddError();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!this.ValidateChildren())
{
return;
}
if (GeneID != 0)
{
this.geneBindingSource.EndEdit();
if (1 == this.geneTableAdapter.Update(this.farmManageDataSet.Gene))
{
UserLogTableAdapter logTableAdapter = new UserLogTableAdapter();
logTableAdapter.Insert(TypeUtil.Gene, GeneID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_MODIFY, DateTime.Now);
this.DialogResult = DialogUtil.SaveSuccess();
}
else
{
this.DialogResult = DialogUtil.SaveError();
}
}
else
{
GeneID = (int)this.geneTableAdapter.InsertQuery(this.tbxName.Text.Trim(), this.tbxNatural.Text.Trim());
if (GeneID > 0)
{
UserLogTableAdapter logTableAdapter = new UserLogTableAdapter();
logTableAdapter.Insert(TypeUtil.Gene, GeneID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
this.DialogResult = DialogUtil.AddSuccess();
}
else
{
this.DialogResult = DialogUtil.AddError();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Int32 CorralID = ((cowBindingSource.Current as DataRowView).Row as FarmManageDataSet.CowRow).CorralID;
this.Validate();
this.cowBindingSource.EndEdit();
if (1 == this.cowTableAdapter.Update(this.farmManageDataSet.Cow))
{
if (CorralID != Convert.ToInt32(cbxCorral.SelectedValue))
{
corralTableAdapter.UpdateRemoveCurrent(1, CorralID);
corralTableAdapter.UpdateAddCurrent(1, Convert.ToInt32(cbxCorral.SelectedValue));
}
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.Cow, CowNO, MainForm.User.UserID, 1, DateTime.Now);
DialogResult = DialogUtil.SaveSuccess();
}
else
{
DialogResult = DialogUtil.SaveError();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (OrderInID > 0)
{
this.Validate();
this.bornViewBindingSource.EndEdit();
this.fKCowOrderIn1BindingSource.EndEdit();
Int32 result = this.bornViewTableAdapter.Update(this.farmManageDataSet.BornView);
if (result == 1)
{
this.DialogResult = DialogUtil.SaveSuccess();
}
else
{
this.DialogResult = DialogUtil.SaveError();
}
}
else
{
OrderInID = (int)this.bornViewTableAdapter.InsertQuery(
(byte?)2,
Convert.ToInt32(this.cbxBy.SelectedValue),
this.dtpDate.Value,
this.tbxDescription.Text);
if (OrderInID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.OrderIn, OrderInID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
foreach (DataGridViewRow row in this.dgvCowAdd.Rows)
{
Int32 tCorralID = Convert.ToInt32(row.Cells["colCorral"].Value);
Int32 tGeneID = Convert.ToInt32(row.Cells["colGene"].Value);
Byte tSexlID = Convert.ToByte(row.Cells["colSex"].Value);
String tDesc = row.Cells["colDescription"].Value.ToString();
String CowNO = String.Format("{0:000}-{1:000}", OrderInID, Convert.ToInt32(row.Cells["colID"].Value));
CowNO = (String)this.cowTableAdapter.InsertQuery(
CowNO,
tCorralID,
tGeneID,
tSexlID,
tDesc,
OrderInID,
0.0,
new Int32?(),
new Double?());
if (CowNO != null)
{
log.Insert(TypeUtil.Cow, CowNO, MainForm.User.UserID, TypeUtil.EVENT_BORN, DateTime.Now);
this.corralTableAdapter.UpdateAddCurrent(1, tCorralID);
}
}
this.DialogResult = DialogUtil.AddSuccess();
}
else
{
this.DialogResult = DialogUtil.AddError();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateChildren())
{
return;
}
var Stocks = new Dictionary <Int32, Double>();
foreach (DataGridViewRow row in dgvAdd.Rows)
{
var StockID = Convert.ToInt32(row.Cells["StockID"].Value);
var Unit = Convert.ToDouble(row.Cells["Unit"].Value);
if (Stocks.ContainsKey(StockID))
{
Stocks[StockID] += Unit;
}
else
{
Stocks.Add(StockID, Unit);
}
}
var Msg = new StringBuilder();
foreach (KeyValuePair <Int32, Double> Stock in Stocks)
{
var CurrentUnit = this.stockTableAdapter.QueryCurrentUnit(Stock.Key);
if (CurrentUnit < Stock.Value)
{
Msg.Append(String.Format("{0} จำนวนปัจจุบัน:{1} จำนวนที่ต้องการ:{2}\n", stockTableAdapter.GetDataByPK(Stock.Key)[0].Name, CurrentUnit, Stock.Value));
}
}
if (Msg.Length != 0)
{
MessageBox.Show(String.Format("พัสดุไม่พอ \n{0}\n กรุณาลองใหม่อีกครั้ง", Msg), "ข้อผิดผลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (DiseaseHistoryID == 0)
{
DiseaseHistoryID = (int)this.diseaseHistoryTableAdapter.InsertQuery(
Convert.ToInt32(this.cbxBy.SelectedValue),
CowNO,
this.dtpDate.Value,
this.tbxSymptom.Text,
this.tbxTreatment.Text);
if (DiseaseHistoryID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.DiseaseHistory, DiseaseHistoryID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
var StockRemoveID = 0;
var stockRemoveResult = 0;
if (dgvAdd.Rows.Count > 0)
{
var stockRemoveTableAdapter = new StockRemoveTableAdapter();
StockRemoveID = (int)stockRemoveTableAdapter.InsertQuery(
Convert.ToInt32(dgvAdd.Rows[0].Cells["ByID"].Value),
(DateTime)dgvAdd.Rows[0].Cells["Date"].Value,
2,
CowNO);
userLogTableAdapter.Insert(TypeUtil.StockRemove, StockRemoveID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
}
var stockRemoveListTableAdapter = new StockRemoveListTableAdapter();
foreach (DataGridViewRow row in dgvAdd.Rows)
{
int DiseaseMedicine = (int)diseaseMedicineTableAdapter.InsertQuery(
Convert.ToInt32(row.Cells["ByID"].Value),
DiseaseHistoryID,
Convert.ToInt32(row.Cells["StockID"].Value),
Convert.ToDouble(row.Cells["Unit"].Value),
(DateTime)row.Cells["Date"].Value);
if (DiseaseMedicine > 0)
{
log.Insert(TypeUtil.DiseaseMedicine, DiseaseMedicine.ToString(), MainForm.User.UserID, 0, DateTime.Now);
this.stockTableAdapter.UpdateRemoveUnit(Convert.ToDouble(row.Cells["Unit"].Value), Convert.ToInt32(row.Cells["StockID"].Value));
if (stockRemoveResult == 1)
{
stockRemoveListTableAdapter.Insert(StockRemoveID, Convert.ToInt32(row.Cells["StockID"].Value), Convert.ToDouble(row.Cells["Unit"].Value), null);
}
}
}
DialogResult = DialogUtil.AddSuccess();
}
else
{
DialogResult = DialogUtil.AddError();
}
}
else
{
var StockRemoveID = 0;
if (dgvAdd.Rows.Count > 0)
{
var stockRemoveTableAdapter = new StockRemoveTableAdapter();
StockRemoveID = (int)stockRemoveTableAdapter.InsertQuery(
Convert.ToInt32(dgvAdd.Rows[0].Cells["ByID"].Value),
(DateTime)dgvAdd.Rows[0].Cells["Date"].Value,
2,
CowNO);
userLogTableAdapter.Insert(TypeUtil.StockRemove, StockRemoveID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
}
var stockRemoveListTableAdapter = new StockRemoveListTableAdapter();
foreach (DataGridViewRow row in dgvAdd.Rows)
{
int DiseaseMedicine = (int)diseaseMedicineTableAdapter.InsertQuery(
Convert.ToInt32(row.Cells["ByID"].Value),
DiseaseHistoryID,
Convert.ToInt32(row.Cells["StockID"].Value),
Convert.ToDouble(row.Cells["Unit"].Value),
(DateTime)row.Cells["Date"].Value);
if (DiseaseMedicine < 0)
{
stockTableAdapter.UpdateRemoveUnit(Convert.ToDouble(row.Cells["Unit"].Value), Convert.ToInt32(row.Cells["StockID"].Value));
if (StockRemoveID > 0)
{
stockRemoveListTableAdapter.Insert(StockRemoveID, Convert.ToInt32(row.Cells["StockID"].Value), Convert.ToDouble(row.Cells["Unit"].Value), null);
}
}
}
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.DiseaseHistory, DiseaseHistoryID.ToString(), MainForm.User.UserID, 1, DateTime.Now);
DialogResult = DialogUtil.SaveSuccess();
}
}
private void SaveOrder()
{
var Vaccines = new Dictionary <Int32, Double>();
foreach (DataGridViewRow vRow in this.dgvVaccine.Rows)
{
var StockID = Convert.ToInt32(vRow.Cells["colVaccineStockID"].Value);
var Unit = Convert.ToDouble(vRow.Cells["colVaccineUnit"].Value);
if (Vaccines.ContainsKey(StockID))
{
Vaccines[StockID] += Unit;
}
else
{
Vaccines.Add(StockID, Unit);
}
}
var Msg = new StringBuilder();
foreach (KeyValuePair <Int32, Double> Vaccine in Vaccines)
{
Double?CurrentUnit = this.stockTableAdapter.QueryCurrentUnit(Vaccine.Key);
if (CurrentUnit.Value < Vaccine.Value)
{
Msg.Append(String.Format("{0} จำนวนปัจจุบัน:{1} จำนวนที่ต้องการ:{2}\n", stockTableAdapter.GetDataByPK(Vaccine.Key)[0].Name, CurrentUnit, Vaccine.Value));
}
}
if (Msg.Length != 0)
{
MessageBox.Show(String.Format("พัสดุไม่พอ \n{0}\n กรุณาลองใหม่อีกครั้ง", Msg), "ข้อผิดผลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (CustomerPID == null)
{
CustomerPID = (String)this.customerTableAdapter.InsertQuery(
this.tbxCustomerPID.Text,
this.Prename,
this.tbxfName.Text,
this.tbxlName.Text,
this.Company,
this.tbxAddress.Text,
this.tbxStreed.Text,
this.tbxPhone.Text,
this.tbxMobile.Text,
this.City,
this.District,
this.Province,
this.PostCode);
if (CustomerPID != null)
{
UserLogTableAdapter logTableAdapter = new UserLogTableAdapter();
logTableAdapter.Insert(TypeUtil.Customer, CustomerPID, MainForm.User.UserID, 0, DateTime.Now);
}
else
{
lblFinishHeader.Text = "ข้อผิดผลาด";
lblFinishDescription.Text = "พบข้อผิดผลาดในการบันทึกข้อมูลลูกค้า กรุณาลองใหม่อีกครั้ง";
Index = 3;
initialWizard();
return;
}
}
var PaymentStatus = Convert.ToByte(cbxPaymentStatus.SelectedValue);
var PaymentType = Convert.ToByte(cbxPaymentType.SelectedValue);
int OrderInID = (int)this.orderInTableAdapter.InsertQuery(
this.OrderBy,
this.CustomerPID,
this.OrderBy,
this.dtpOrderDate.Value,
null,
this.TransportType,
Convert.ToDouble(tbxTransportCost.Text),
this.tbxTransportNO.Text,
this.tbxTransportIssueBy.Text,
Convert.ToDouble(this.tbxUnit.Text),
Convert.ToDouble(this.tbxAmountPerUnit.Text),
Convert.ToDouble(this.tbxAmount.Text),
PaymentStatus,
PaymentStatus == 0 ? new Byte?() : PaymentType,
PaymentStatus == 0 ? new Int32?() : Convert.ToByte(this.cbxPaymentBy.SelectedValue),
PaymentStatus == 0 ? new DateTime?() : dtpPaymentDate.Value,
cbxBankNO.SelectedValue == null ? new Int32?() : Convert.ToInt32(cbxBankNO.SelectedValue));
var stockRemoveListTableAdapter = new StockRemoveListTableAdapter();
var stockRemoveTableAdapter = new StockRemoveTableAdapter();
var vaccineTableAdapter = new VaccineTableAdapter();
if (OrderInID > 0)
{
MessageBox.Show(OrderInID.ToString());
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.OrderIn, OrderInID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
var CowTableAdapter = new CowTableAdapter();
var CowCount = 0;
foreach (DataGridViewRow row in dgvCow.Rows)
{
String CowNO = String.Format("{0:000}-{1:000}", OrderInID, Convert.ToInt32(row.Cells["colCowID"].Value));
Double Amount = Convert.ToDouble(row.Cells["colCowAmount"].Value);
CowNO = (String)CowTableAdapter.InsertQuery(
CowNO,
Convert.ToInt32(row.Cells["colCowCorral"].Value),
Convert.ToInt32(row.Cells["colCowGene"].Value),
Convert.ToByte(row.Cells["colCowSex"].Value),
String.Empty,
OrderInID,
Amount,
new Int32?(),
new Double?());
if (CowNO != null)
{
log.Insert(TypeUtil.Cow, CowNO, MainForm.User.UserID, TypeUtil.EVENT_BUY, DateTime.Now);
this.corralTableAdapter.UpdateAddCurrent(1, Convert.ToInt32(row.Cells["colCowCorral"].Value));
foreach (DataGridViewRow vRow in this.dgvVaccine.Rows)
{
int VaccineID = (int)vaccineTableAdapter.InsertQuery((Int32)vRow.Cells["colVaccineByID"].Value, CowNO, (Int32)vRow.Cells["colVaccineStockID"].Value, (Double)vRow.Cells["colVaccineUnit"].Value, (DateTime)vRow.Cells["colVaccineDate"].Value);
if (VaccineID > 0)
{
log.Insert(TypeUtil.Vaccine, VaccineID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
this.stockTableAdapter.UpdateRemoveUnit((Double)vRow.Cells["colVaccineUnit"].Value, (Int32)vRow.Cells["colVaccineStockID"].Value);
}
}
CowCount++;
}
}
var StockRemoveID = 0;
if (Vaccines.Count > 0)
{
StockRemoveID = (int)stockRemoveTableAdapter.InsertQuery(
OrderBy,
this.dtpOrderDate.Value,
1,
OrderInID.ToString());//1 เบิกการฉีดวัคซีน
log.Insert(TypeUtil.StockRemove, StockRemoveID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
}
foreach (KeyValuePair <Int32, Double> Vaccine in Vaccines)
{
stockRemoveListTableAdapter.Insert(StockRemoveID, Vaccine.Key, Vaccine.Value, null);
}
lblFinishHeader.Text = "เสร็จสมบูรณ์";
lblFinishDescription.Text = "บันทึกการซื้อเสร็จสมบูรณ์";
}
else
{
lblFinishHeader.Text = "ข้อผิดผลาด";
lblFinishDescription.Text = "พบข้อผิดผลาดในการบันทึกข้อมูลการซื้อ";
Index = 4;
initialWizard();
return;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
btnSave.Enabled = false;
pnlContent.Enabled = false;
Cursor = System.Windows.Forms.Cursors.WaitCursor;
if (tbxUsername.Text.Length < 5)
{
btnSave.Enabled = true;
pnlContent.Enabled = true;
Cursor = System.Windows.Forms.Cursors.Default;
MessageBox.Show("ชื่อผู้ใช้ 5 อักษรขึ้นไป กรุณาลองใหม่อีกครั้ง", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbxUsername.Focus();
return;
}
int result = (int)usersTableAdapter.CheckUsername(tbxUsername.Text.Trim());
if (result == 0)
{
if (!tbxPassword.Text.Trim().Equals(tbxConfirmPassword.Text.Trim()))
{
btnSave.Enabled = true;
pnlContent.Enabled = true;
Cursor = System.Windows.Forms.Cursors.Default;
MessageBox.Show("รหัสผ่านไม่ตรงกัน, กรุณาลองใหม่อีกครั้ง", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
if (tbxPassword.Text.Trim().Length < 6)
{
btnSave.Enabled = true;
pnlContent.Enabled = true;
Cursor = System.Windows.Forms.Cursors.Default;
MessageBox.Show("รหัสผ่านสั้นเกินไป 6 ตัวอักษรขึ้นไป, กรุณาลองใหม่อีกครั้ง", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
int UserID = (int)usersTableAdapter.InsertQuery(tbxUsername.Text.Trim(),
tbxPassword.Text.Trim(),
Convert.ToByte(cbxPrename.SelectedValue),
tbxFirstname.Text.Trim(),
tbxLastname.Text.Trim(),
chkSuperUser.Checked,
chkEnable.Checked,
tbxEmail.Text.Trim(),
tbxTel.Text.Trim());
if (UserID > 0)
{
UserLogTableAdapter logTableAdapter = new UserLogTableAdapter();
logTableAdapter.Insert(TypeUtil.User, UserID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
DialogUtil.SaveSuccess();
DialogResult = System.Windows.Forms.DialogResult.Yes;
}
else
{
DialogUtil.SaveError();
DialogResult = System.Windows.Forms.DialogResult.No;
}
}
else
{
btnSave.Enabled = true;
pnlContent.Enabled = true;
Cursor = System.Windows.Forms.Cursors.Default;
MessageBox.Show("ไม่สามารถใช้ชื่อผู้ใช้นี้ กรุณาลองใหม่อีกครั้ง", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbxUsername.Focus();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.dgvAddList.Rows.Count == 0)
{
MessageBox.Show("ไม่มีรายการที่เพิ่มอย่างสมบูรณ์ กรุณาเพิ่มหรือป้อนข้อมูลให้ครบ");
return;
}
for (var i = 0; i < dgvAddList.Rows.Count; i++)
{
if (this.dgvAddList.Rows[i].Cells[0].Value == null || Convert.ToDouble(dgvAddList.Rows[i].Cells[1].Value) == 0)
{
MessageBox.Show("ข้อมูลไม่ครบ กรุณาลองใหม่อีกครั้ง", "ข้อผิดผลาก", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
var Stocks = new Dictionary <Int32, Double>();
foreach (DataGridViewRow vRow in this.dgvAddList.Rows)
{
var StockID = Convert.ToInt32(vRow.Cells[0].Value);
var Unit = Convert.ToDouble(vRow.Cells[1].Value);
if (Stocks.ContainsKey(StockID))
{
Stocks[StockID] += Unit;
}
else
{
Stocks.Add(StockID, Unit);
}
}
var Msg = new StringBuilder();
foreach (KeyValuePair <Int32, Double> Stock in Stocks)
{
Double?CurrentUnit = this.stockTableAdapter.QueryCurrentUnit(Stock.Key);
if (CurrentUnit.Value < Stock.Value)
{
Msg.Append(String.Format("{0} จำนวนปัจจุบัน:{1} จำนวนที่ต้องการ:{2}\n", stockTableAdapter.GetDataByPK(Stock.Key)[0].Name, CurrentUnit, Stock.Value));
}
}
if (Msg.Length != 0)
{
MessageBox.Show(String.Format("พัสดุไม่พอ \n{0}\n กรุณาลองใหม่อีกครั้ง", Msg), "ข้อผิดผลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
RemoveStockID = (int)this.stockRemoveTableAdapter.InsertQuery(
Convert.ToInt32(cbxBy.SelectedValue),
this.dtpDate.Value,
0,
"0");//0 เบิกตามปกติ
if (RemoveStockID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.StockRemove, RemoveStockID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
var StockRemoveID = stockRemoveTableAdapter.QueryMaxID();
foreach (DataGridViewRow row in this.dgvAddList.Rows)
{
var result = this.stockRemoveListTableAdapter.Insert(
StockRemoveID.Value,
Convert.ToInt32(row.Cells[0].Value),
Convert.ToDouble(row.Cells[1].Value),
row.Cells[2].Value == null ? string.Empty : row.Cells[2].Value.ToString());
if (result == 1)
{
this.stockTableAdapter.UpdateRemoveUnit(Convert.ToDouble(row.Cells[1].Value), Convert.ToInt32(row.Cells[0].Value));
}
}
this.DialogResult = DialogUtil.SaveSuccess();
}
else
{
this.DialogResult = DialogUtil.SaveError();
}
}
private void SaveOrder()
{
int result = 0;
if (CustomerPID == null)
{
CustomerPID = (String)customerTableAdapter.InsertQuery(
tbxCustomerPID.Text,
Prename,
tbxfName.Text,
tbxlName.Text,
Company,
tbxAddress.Text,
tbxStreed.Text,
tbxPhone.Text,
tbxMobile.Text,
City,
District,
Province,
PostCode);
if (CustomerPID != null)
{
result = 1;
UserLogTableAdapter logTableAdapter = new UserLogTableAdapter();
logTableAdapter.Insert(TypeUtil.Customer, CustomerPID, MainForm.User.UserID, 0, DateTime.Now);
}
else
{
lblFinishHeader.Text = "ข้อผิดผลาด";
lblFinishDescription.Text = "พบข้อผิดผลาดในการบันทึกข้อมูลลูกค้า กรุณาลองใหม่อีกครั้ง";
Index = 3;
initialWizard();
return;
}
}
var PaymentStatus = Convert.ToByte(cbxPaymentStatus.SelectedValue);
var PaymentType = Convert.ToByte(cbxPaymentType.SelectedValue);
int OrderOutID = (int)orderOutTableAdapter.InsertQuery(
this.OrderType,
this.CustomerPID,
this.OrderBy,
this.dtpOrderDate.Value,
this.tbxNote.Text,
this.TransportType,
Convert.ToDouble(this.tbxTransportCost.Text),
this.tbxTransportNO.Text,
this.tbxTransportIssueBy.Text,
Convert.ToDouble(this.tbxUnit.Text),
Convert.ToDouble(this.tbxAmountPerUnit.Text),
Convert.ToDouble(this.tbxAmount.Text),
PaymentStatus,
PaymentStatus == 0 ? new Byte?() : PaymentType,
PaymentStatus == 0 ? new Int32?() : Convert.ToByte(this.cbxPaymentBy.SelectedValue),
PaymentStatus == 0 ? new DateTime?() : this.dtpPaymentDate.Value);
if (OrderOutID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.OrderOut, OrderOutID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
var cowTableAdapter = new CowTableAdapter();
var OrderType = Convert.ToByte(cbxOrderType.SelectedValue);
foreach (DataGridViewRow row in dgvCow.Rows)
{
Double Amount = Convert.ToDouble(row.Cells["colCowOrderOutAmount"].Value);
result = cowTableAdapter.UpdateCowOrderOut(
OrderOutID,
Amount,
row.Cells["colCowNO"].Value.ToString());
if (result == 1)
{
log.Insert(TypeUtil.Cow, row.Cells["colCowNO"].Value.ToString(), MainForm.User.UserID, TypeUtil.EVENT_SELL, DateTime.Now);
corralTableAdapter.UpdateRemoveCurrent(1, Convert.ToInt32(row.Cells["colCowCorral"].Value));
lblFinishHeader.Text = "เสร็จสมบูรณ์";
lblFinishDescription.Text = "บันทึกการซื้อเสร็จสมบูรณ์";
}
else
{
lblFinishHeader.Text = "ข้อผิดผลาด";
lblFinishDescription.Text = "พบข้อผิดผลาดในการบันทึกข้อมูลการซื้อ";
}
}
}
else
{
lblFinishHeader.Text = "ข้อผิดผลาด";
lblFinishDescription.Text = "พบข้อผิดผลาดในการบันทึกข้อมูลการซื้อ";
Index = 4;
initialWizard();
return;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateChildren())
{
return;
}
foreach (DataGridViewRow row in this.dgvAdd.Rows)
{
if (row.Cells[0].Value == null || row.Cells[1].Value == null)
{
MessageBox.Show("ป้อนข้อมูลไม่ครบ", "ข้อผิดผลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
if (RecipesID == 0)
{
RecipesID = (int)this.recipesTableAdapter.InsertQuery(tbxName.Text, tbxDescription.Text);
if (RecipesID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.Recipes, RecipesID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
RecipesID = recipesTableAdapter.GetMaxID().Value;
foreach (DataGridViewRow row in this.dgvAdd.Rows)
{
Int32 StockID = Convert.ToInt32(row.Cells[0].Value);
Double Unit = Convert.ToDouble(row.Cells[1].Value);
this.recipesListTableAdapter.Insert(RecipesID, StockID, Unit);
}
this.DialogResult = DialogUtil.AddSuccess();
}
else
{
this.DialogResult = DialogUtil.AddError();
}
}
else
{
this.Validate();
this.recipesBindingSource.EndEdit();
this.fKrecipeslistrecipesBindingSource.EndEdit();
this.recipesTableAdapter.Update(farmManageDataSet.Recipes);
this.recipesListTableAdapter.Update(farmManageDataSet.RecipesList);
foreach (DataGridViewRow row in this.dgvAdd.Rows)
{
Int32 StockID = Convert.ToInt32(row.Cells[0].Value);
Double Unit = Convert.ToDouble(row.Cells[1].Value);
this.recipesListTableAdapter.Insert(RecipesID, StockID, Unit);
}
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.Recipes, RecipesID.ToString(), MainForm.User.UserID, 1, DateTime.Now);
//if (result == 1)
//{
// this.recipesListTableAdapter.Update(farmManageDataSet.RecipesList);
// foreach (DataGridViewRow row in this.dgvAdd.Rows)
// {
// Int32 StockID = Convert.ToInt32(row.Cells[0].Value);
// Double Unit = Convert.ToDouble(row.Cells[1].Value);
// this.recipesListTableAdapter.Insert(RecipesID, StockID, Unit);
// }
DialogUtil.SaveSuccess();
this.DialogResult = DialogResult.Yes;
//}
//else
//{
// DialogUtil.SaveError();
// this.DialogResult = DialogResult.No;
//}
}
}
private void btnCalculate_Click(object sender, EventArgs e)
{
if (Convert.ToDouble(tbxPercen.Text) == 0D)
{
MessageBox.Show("จำเป็นต้องเลือกอัตราคำนวน มากกว่า 0", "ข้อผิดผลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int ByID = Convert.ToInt32(cbxBy.SelectedValue);
RecipesID = Convert.ToInt32(cbxRecipse.SelectedValue);
if (RecipesID == 0)
{
MessageBox.Show("คุณยังไม่ได้เลือกสูตรอาหาร กรุณาเลือกสูตรอาหารก่อน", "ข้อผิดผลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var RecipesListRows = new RecipesListTableAdapter().GetDataByRecipesID(RecipesID);
var msg = new StringBuilder();
foreach (FarmManageDataSet.RecipesListRow row in RecipesListRows.Rows)
{
var unit = (row.Unit * Double.Parse(tbxPercen.Text)) / 100;
var StockRows = stockTableAdapter.GetDataByPK(row.StockID);
if (StockRows.Count == 0)
{
MessageBox.Show("ไม่พบพัสดุที่ต้องการจะหัก หรือพัสดุนั้นถูกลบออกจากระบบแล้วกรุนาตรวจสอบใหม่อีกครั้ง <br/>ID:" + row.StockID, "ข้อผิดผลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (unit > StockRows[0].Unit)
{
msg.Append(String.Format("พัสดุชื่อ {0} มีจำนวนไม่พอที่หัก จำนวนปัจจุบัน:{1} จำนวนที่ต้องการหัก:{2}<br>", StockRows[0].Name, StockRows[0].Unit, unit));
}
}
if (msg.Length != 0)
{
MessageBox.Show(msg.ToString(), "ข้อผิดผลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var RecipesHistoryID = (int)this.recipesHistoryTableAdapter.InsertQuery(
Convert.ToInt32(cbxBy.SelectedValue),
RecipesID,
dtpDate.Value,
Convert.ToInt32(tbxPercen.Text));
if (RecipesHistoryID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.RecipesHistory, RecipesHistoryID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
foreach (FarmManageDataSet.RecipesListRow row in RecipesListRows.Rows)
{
var Unit = (row.Unit * Double.Parse(tbxPercen.Text)) / 100;
int RecipesListHistoryID = (int)recipesListHistoryTableAdapter.InsertQuery(RecipesHistoryID, row.StockID, Unit);
if (RecipesListHistoryID > 0)
{
log.Insert(TypeUtil.RecipesListHistory, RecipesListHistoryID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
int StockRemoveID = (int)this.stockRemoveTableAdapter.InsertQuery(
ByID,
dtpDate.Value,
3,
RecipesHistoryID.ToString());
if (StockRemoveID > 0)
{
log.Insert(TypeUtil.StockRemove, StockRemoveID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
var StockRemoveListID = (int)new StockRemoveListTableAdapter().InsertQuery(StockRemoveID, row.StockID, Unit, null);
if (StockRemoveListID > 0)
{
this.stockTableAdapter.UpdateRemoveUnit(Unit, row.StockID);
log.Insert(TypeUtil.StockRemoveList, StockRemoveListID.ToString(), MainForm.User.UserID, TypeUtil.EVENT_CREATE, DateTime.Now);
}
}
}
}
DialogResult = DialogUtil.AddSuccess();
}
else
{
DialogResult = DialogUtil.AddError();
}
}
