public DataTable dgvGetOldData() { MilkTransaction objMilkTransaction = new MilkTransaction(); _fromDate = DtpFrom.Value; _toDate = DtpTo.Value; objMilkTransaction.FromDate = Convert.ToDateTime(_fromDate.ToString("yyyy/MM/dd")); objMilkTransaction.ToDate = Convert.ToDateTime(_toDate.ToString("yyyy/MM/dd")); DataTable dt = objMilkTransaction.GetActiveRecord(objMilkTransaction); //if (dt != null && dt.Rows.Count > 0) //{ // foreach (DataRow row in dt.Rows) // { // GetTotal(row["Fat"].ToString(), row["Animal"].ToString(), row["Quantity"].ToString()); // row["NewRate"] = _newRate.ToString("0.00"); // row["NewAmount"] = _newAmt.ToString("0.00"); // row["NewMemberRate"] = _memberRate.ToString("0.00"); // } //} return(dt); }
public int dgvUpdateOldData() { int updateFlag = 0; MilkTransaction objMilkTransaction = new MilkTransaction(); _fromDate = DtpFrom.Value; _toDate = DtpTo.Value; int FillUpId = 0; objMilkTransaction.FromDate = Convert.ToDateTime(_fromDate.ToString("yyyy/MM/dd")); objMilkTransaction.ToDate = Convert.ToDateTime(_toDate.ToString("yyyy/MM/dd")); DataTable dt = objMilkTransaction.GetActiveRecord(objMilkTransaction); if (dt != null && dt.Rows.Count > 0) { //foreach (DataRow row in dt.Rows) //{ // //GetTotal(row["Fat"].ToString(), row["Animal"].ToString(), row["Quantity"].ToString()); // //_date = row["Date"].ToString(); // //row["NewRate"] = _newRate.ToString(); // //row["NewAmount"] = _newAmt.ToString(); // //row["NewMemberRate"] = _memberRate.ToString(); // //objMilkTransaction.Date = DateTime.Parse(_date); // //objMilkTransaction.Shift = row["Shift"].ToString(); // objMilkTransaction.FillUpId = int.Parse(row["SrNo."].ToString()); // //[Sr No.] // objMilkTransaction.MemberCode = row["MemberCode"].ToString(); // //objMilkTransaction.Amount = Convert.ToDecimal(row["NewAmount"].ToString()); // updateFlag = objMilkTransaction.UpdateMilkTransaction(objMilkTransaction); // //objMilkTransaction.Rate = Convert.ToDecimal(row["NewRate"].ToString()); // //objMilkTransaction.MemberRate = Convert.ToDecimal(row["NewMemberRate"].ToString()); //} genericDbHandler.SqlBulkUpdate(dt); return(1); } return(updateFlag); }