private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string Action = this.GridViewMr.Columns[e.ColumnIndex].HeaderText;
if (Action == "Edit")
{
frmEntryMRNote frm = new frmEntryMRNote();
MRId = Convert.ToInt32(GridViewMr.Rows[e.RowIndex].Cells[0].Value);
frm.MRId = MRId;
frm.FormClosed += frm_FormClosed;
frm.ShowInTaskbar = false;
frm.Show();
}
if (Action == "Delete")
{
try
{
MRId = Convert.ToInt32(GridViewMr.Rows[e.RowIndex].Cells[0].Value);
var messageBoxResult = MessageBox.Show("Are you sure want to delete this record?", "Delete", MessageBoxButtons.YesNo);
if (messageBoxResult == DialogResult.Yes)
{
var result = MRNoteBusinessLogic.Delete(MRId);
MessageBox.Show("MR Note deleted successfully.");
FillGridData();
}
}
catch (Exception)
{
MessageBox.Show("MR Note already used some where else can't deleted successfully.");
}
}
}
void frmEntryMRNote_Load(object sender, EventArgs e)
{
if (MRId > 0)
{
var tblMRNoteDTO = MRNoteBusinessLogic.Get(MRId);
txtMRno.Text = Convert.ToString(tblMRNoteDTO.MrNo);
txtbillno.Text = Convert.ToString(tblMRNoteDTO.BillNo);
dpDate.Text = Convert.ToString(tblMRNoteDTO.MRDate);
txtRecievefrom.Text = tblMRNoteDTO.RecievedFrom;
txtfrom.Text = tblMRNoteDTO.LocationFrom;
txtto.Text = tblMRNoteDTO.LocationTo;
dpbilldate.Text = tblMRNoteDTO.BillDate;
txtBillAmount.Text = Convert.ToString(tblMRNoteDTO.BillAmount);
txtNoofPackage.Text = tblMRNoteDTO.NoofPackages;
txtWeight.Text = tblMRNoteDTO.Weight;
txtRecievedAmount.Text = Convert.ToString(tblMRNoteDTO.AmountRecieved);
cmbPaymentType.Text = tblMRNoteDTO.WayOfRecieve;
txtFright.Text = Convert.ToString(tblMRNoteDTO.Fright);
txtstch.Text = Convert.ToString(tblMRNoteDTO.StCharges);
txtHamali.Text = Convert.ToString(tblMRNoteDTO.Hamali);
txtOther1.Text = Convert.ToString(tblMRNoteDTO.Other1);
txtOther2.Text = Convert.ToString(tblMRNoteDTO.Other2);
txtOther3.Text = Convert.ToString(tblMRNoteDTO.Other3);
txtOther4.Text = Convert.ToString(tblMRNoteDTO.Other4);
txtTotal.Text = Convert.ToString(tblMRNoteDTO.TotalAmount);
GenerateCode();
}
else
{
GenerateCode();
cmbPaymentType.SelectedIndex = 0;
}
}
private void txtbillno_Leave(object sender, EventArgs e)
{
if (txtbillno.Text.Trim() == "")
{
return;
}
var result = MRNoteBusinessLogic.GetMRNoteBillDetail(Convert.ToInt32(txtbillno.Text));
if (result == null)
{
MessageBox.Show("No bill found.");
}
else if (result != null && result.PendingAmount == 0)
{
MessageBox.Show("Bill already paid.");
// return Json(new { Success = false, Message = "Bill already paid." });
}
else if (result != null)
{
dpbilldate.Text = result.BillDateString;
txtBillAmount.Text = Convert.ToString(result.GrandTotal);
txtRecievedAmount.Text = Convert.ToString(result.PendingAmount);
CommonClass.LeaveEvents(sender, e);
return;
}
txtbillno.Focus();
dpbilldate.Text = "";
txtBillAmount.Text = "";
}
/// <summary>
/// Check validation
/// </summary>
private void CheckValidation(tblMRNoteDTO tblMRNoteDTO)
{
var resultCheckDuplicateMRNo = MRNoteBusinessLogic.CheckDuplicateMRNo(tblMRNoteDTO.MRId, tblMRNoteDTO.MrNo ?? 0);
if (resultCheckDuplicateMRNo)
{
ModelState.AddModelError("MrNo", "MrNo already exists.");
}
}
public JsonResult DeleteMRNote(int id)
{
var result = MRNoteBusinessLogic.Delete(id);
if (result)
{
return(Json(new { Success = true, Message = "Delete Successfully." }));
}
return(Json(new { Success = false, Message = "Error in MRNote." }));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsFormValidate())
{
tblMRNoteDTO dto = new tblMRNoteDTO();
if (MRId > 0)
{
dto.MRId = MRId;
}
dto.MrNo = Convert.ToInt32(txtMRno.Text);
dto.BillId = Convert.ToInt32(txtbillno.Text);
dto.MRDate = Convert.ToDateTime(dpDate.Text);
dto.RecievedFrom = txtRecievefrom.Text;
dto.LocationFrom = txtfrom.Text;
dto.LocationTo = txtto.Text;
dto.BillNo = Convert.ToInt32(txtbillno.Text);
dto.BillDate = dpbilldate.Text;
dto.BillAmount = Convert.ToDouble(txtBillAmount.Text);
dto.NoofPackages = txtNoofPackage.Text;
dto.Weight = txtWeight.Text;
dto.AmountRecieved = txtRecievedAmount.Text.Trim() == "" ? 0 : Convert.ToDouble(txtRecievedAmount.Text);
dto.WayOfRecieve = cmbPaymentType.SelectedText;
dto.Fright = txtFright.Text.Trim() == "" ? 0 : Convert.ToDouble(txtFright.Text);
dto.StCharges = txtstch.Text.Trim() == "" ? 0 : Convert.ToDouble(txtstch.Text);
dto.Hamali = txtHamali.Text.Trim() == "" ? 0 : Convert.ToDouble(txtHamali.Text);
dto.Other1 = txtOther1.Text.Trim() == "" ? 0 : Convert.ToDouble(txtOther1.Text);
dto.Other2 = txtOther2.Text.Trim() == "" ? 0 : Convert.ToDouble(txtOther2.Text);
dto.Other3 = txtOther3.Text.Trim() == "" ? 0 : Convert.ToDouble(txtOther3.Text);
dto.Other4 = txtOther4.Text.Trim() == "" ? 0 : Convert.ToDouble(txtOther4.Text);
dto.TotalAmount = txtTotal.Text.Trim() == "" ? 0 : Convert.ToDouble(txtTotal.Text);
dto.CreationDate = DateTime.Now;
var result = MRNoteBusinessLogic.Save(dto);
if (result > 0)
{
if (MRId > 0)
{
this.Close();
}
else
{
CleanData();
}
}
else
{
MessageBox.Show("Transaction Fail");
}
}
}
public ActionResult ListMRNotesAjax(int?billId)
{
var mrNoteList = new List <tblMRNoteDTO>();
if ((billId ?? 0) > 0)
{
var getBillMRNoteResult = MRNoteBusinessLogic.GetBillMRNote((billId ?? 0));
if (getBillMRNoteResult != null)
{
mrNoteList = getBillMRNoteResult;
}
}
return(View(new GridModel(mrNoteList)));
}
public JsonResult GetBillInfo(int billNo)
{
var result = MRNoteBusinessLogic.GetMRNoteBillDetail(billNo);
if (result == null)
{
return(Json(new { Success = false, Message = "No bill found." }));
}
else if (result != null && result.PendingAmount == 0)
{
return(Json(new { Success = false, Message = "Bill already paid." }));
}
else if (result != null)
{
return(Json(new { BillDetail = result, Success = true }));
}
return(Json(new { Success = false, Message = "Error in bill Details" }));
}
public ActionResult Save(int id)
{
tblMRNoteDTO tblMRNoteDTO;
if (id == 0)
{
tblMRNoteDTO = new tblMRNoteDTO();
tblMRNoteDTO.MrNo = MRNoteBusinessLogic.GetMRNo() + 1;
}
else
{
tblMRNoteDTO = MRNoteBusinessLogic.Get(id);
}
tblMRNoteDTO.PaymentType = new List <SelectListItem>();
tblMRNoteDTO.PaymentType.Add(new SelectListItem {
Value = "Cash", Text = "Cash"
});
tblMRNoteDTO.PaymentType.Add(new SelectListItem {
Value = "Cheque", Text = "Cheque"
});
return(View(tblMRNoteDTO));
}
public ActionResult Save(tblMRNoteDTO tblMRNoteDTO)
{
if (ModelState.IsValid)
{
CheckValidation(tblMRNoteDTO);
if (ModelState.IsValid)
{
var result = MRNoteBusinessLogic.Save(tblMRNoteDTO);
if (result > 0)
{
return(RedirectToAction("Index"));
}
}
}
tblMRNoteDTO.PaymentType = new List <SelectListItem>();
tblMRNoteDTO.PaymentType.Add(new SelectListItem {
Value = "Cash", Text = "Cash"
});
tblMRNoteDTO.PaymentType.Add(new SelectListItem {
Value = "Cheque", Text = "Cheque"
});
return(View(tblMRNoteDTO));
}
private void GenerateCode()
{
txtMRno.Text = Convert.ToString(MRNoteBusinessLogic.GetMRNo() + 1);
}
public ActionResult _AjaxGetMRNote()
{
var MRNoteList = MRNoteBusinessLogic.GetAll();
return(View(new GridModel(MRNoteList)));
}
private void FillGridData()
{
var mrlist = MRNoteBusinessLogic.GetAll();
GridViewMr.DataSource = mrlist;
}
