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 (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();
        }
예제 #5
0
        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();
     }
 }
예제 #7
0
 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;
                }
            }
        }
예제 #9
0
        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;
            }


            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();
            }
        }
        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 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 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 (!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 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();
                }
            }
        }