protected void btnSearch_Click(object sender, EventArgs e)
{
string SearchText = "1=1";
if (txtVoucherNo.Text.Trim() != "")
{
SearchText = SearchText + " and VoucherCode like '%" + txtVoucherNo.Text.Trim().Replace("'", "`") + "%'";
}
if (txtNarration.Text.Trim() != "")
{
SearchText = SearchText + " and NarrationMaster like '%" + txtNarration.Text.Trim().Replace("'", "`") + "%'";
}
if (txtVoucherDate.Text.Trim() != "")
{
SearchText = SearchText + " and VoucherDate ='" + CommonObjects.ConvertMMDDYYYY(txtVoucherDate.Text.Trim()) + "'";
}
if (ddlStatus.SelectedValue.ToString() != "-1")
{
SearchText = SearchText + " and AutoPost='" + ddlStatus.SelectedValue + "'";
}
if (ddlVoucherType.SelectedValue.ToString() != "0")
{
SearchText = SearchText + " and BookType='" + ddlVoucherType.SelectedValue + "'";
}
DataTable dtSearch = objPaymentVoucherBR.GetAllMasterRecords(SearchText);
GridView.DataSource = dtSearch;
GridView.DataBind();
}
public int InsertMasterRecord(ArrayList inputArrayList)
{
objGeneralVoucherDAL.VoucherDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[0].ToString());
objGeneralVoucherDAL.BookType = inputArrayList[1].ToString();
objGeneralVoucherDAL.NarrationMaster = inputArrayList[2].ToString();
return(objGeneralVoucherDAL.InsertMasterRecord(objGeneralVoucherDAL));
}
public void UpdateMasterRecord(ArrayList inputArrayList)
{
objPostDatedChequeDAL.ID = Convert.ToInt32(inputArrayList[0]);
objPostDatedChequeDAL.Dealer = Convert.ToInt32(inputArrayList[1]);
objPostDatedChequeDAL.SubmitDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[2].ToString());
objPostDatedChequeDAL.Comments = inputArrayList[3].ToString();
objPostDatedChequeDAL.UpdateMasterRecord(objPostDatedChequeDAL);
}
public void UpdateMasterRecord(ArrayList inputArrayList)
{
objGeneralVoucherDAL.VoucherId = Convert.ToInt32(inputArrayList[0]);
objGeneralVoucherDAL.VoucherDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[1].ToString());
objGeneralVoucherDAL.BookType = inputArrayList[2].ToString();
objGeneralVoucherDAL.NarrationMaster = inputArrayList[3].ToString();
objGeneralVoucherDAL.UpdateMasterRecord(objGeneralVoucherDAL);
}
public int InsertMasterRecord(ArrayList inputArrayList)
{
objGoodsReceiptVoucherDAL.ShipmentId = Convert.ToInt32(inputArrayList[0]);
objGoodsReceiptVoucherDAL.VoucherDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[1].ToString());
objGoodsReceiptVoucherDAL.Remarks = inputArrayList[2].ToString();
objGoodsReceiptVoucherDAL.WarehouseId = Convert.ToInt32(inputArrayList[3].ToString());
return(objGoodsReceiptVoucherDAL.InsertMasterRecord(objGoodsReceiptVoucherDAL));
}
public void InsertDetailRecord(ArrayList inputArrayList)
{
objPostDatedChequeDAL.PostDatedChequeId = Convert.ToInt32(inputArrayList[0]);
objPostDatedChequeDAL.ChequeDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[1].ToString());
objPostDatedChequeDAL.BankName = inputArrayList[2].ToString();
objPostDatedChequeDAL.BranchName = inputArrayList[3].ToString();
objPostDatedChequeDAL.ChequeNo = inputArrayList[4].ToString();
objPostDatedChequeDAL.Amount = Convert.ToDecimal(inputArrayList[5]);
objPostDatedChequeDAL.InsertDetailRecord(objPostDatedChequeDAL);
}
public void UpdateAccontPaid(ArrayList inputArrayList)
{
objPostDatedChequeReceivedDAL.PostDatedChequeId = Convert.ToInt32(inputArrayList[0]);
objPostDatedChequeReceivedDAL.PaidDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[1].ToString());
objPostDatedChequeReceivedDAL.PaidBankId = Convert.ToInt32(inputArrayList[2]);
objPostDatedChequeReceivedDAL.DepositSlipNo = inputArrayList[3].ToString();
objPostDatedChequeReceivedDAL.Narration = inputArrayList[4].ToString();
objPostDatedChequeReceivedDAL.UpdateAccontPaid(objPostDatedChequeReceivedDAL);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string SearchText = "1=1";
if (hfDealerNameAutoCompleted.Value != "0")
{
SearchText = SearchText + " and a.DealerId like '%" + hfDealerNameAutoCompleted.Value.Replace("'", "`") + "%'";
}
if (txtSubmitDate.Text.Trim() != "")
{
SearchText = SearchText + " and a.SubmitDate ='" + CommonObjects.ConvertMMDDYYYY(txtSubmitDate.Text.Trim()) + "'";
}
if (txtChequeDate.Text.Trim() != "")
{
SearchText = SearchText + " and b.ChequeDate ='" + CommonObjects.ConvertMMDDYYYY(txtChequeDate.Text.Trim()) + "'";
}
if (txtChequeNo.Text.Trim() != "")
{
SearchText = SearchText + " and b.ChequeNo like '%" + txtChequeNo.Text.Trim().Replace("'", "`") + "%'";
}
if (txtBankName.Text.Trim() != "")
{
SearchText = SearchText + " and b.BankName like '%" + txtBankName.Text.Trim().Replace("'", "`") + "%'";
}
if (txtBranchName.Text.Trim() != "")
{
SearchText = SearchText + " and b.BranchName like '%" + txtBranchName.Text.Trim().Replace("'", "`") + "%'";
}
if (ddlPaidStatus.SelectedValue.ToString() != "-1")
{
SearchText = SearchText + " and b.PaidStatus='" + ddlPaidStatus.SelectedValue + "'";
}
if (txtAmount.Text.Trim() != "")
{
SearchText = SearchText + " and b.Amount " + ddlAmount.SelectedItem.Text + " " + txtAmount.Text.Trim() + "";
}
hfSearchText.Value = SearchText.Trim();
Session["SearchText"] = SearchText.Trim();
GetGridData();
DataTable dtSearch = objPostDatedChequeReceivedBR.GetAllRecords(SearchText);
GridView.DataSource = dtSearch;
GridView.DataBind();
}
public int InsertMasterRecord(ArrayList inputArrayList)
{
objCreditNotesDAL.CreditDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[0].ToString());
objCreditNotesDAL.VendorId = Convert.ToInt32(inputArrayList[1]);
objCreditNotesDAL.Remarks = inputArrayList[2].ToString();
objCreditNotesDAL.InsurerId = Convert.ToInt32(inputArrayList[3]);
objCreditNotesDAL.CoverNoteNo = inputArrayList[4].ToString();
objCreditNotesDAL.Weeks = inputArrayList[5].ToString();
return(objCreditNotesDAL.InsertMasterRecord(objCreditNotesDAL));
}
public void UpdateMasterRecord(ArrayList inputArrayList)
{
objCreditNotesDAL.CNID = Convert.ToInt32(inputArrayList[0]);
objCreditNotesDAL.CreditDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[1].ToString());
objCreditNotesDAL.VendorId = Convert.ToInt32(inputArrayList[2]);
objCreditNotesDAL.Remarks = inputArrayList[3].ToString();
objCreditNotesDAL.InsurerId = Convert.ToInt32(inputArrayList[4]);
objCreditNotesDAL.CoverNoteNo = inputArrayList[5].ToString();
objCreditNotesDAL.Weeks = inputArrayList[6].ToString();
objCreditNotesDAL.UpdateMasterRecord(objCreditNotesDAL);
}
public void InsertMasterRecord(ArrayList inputArrayList)
{
objLetterCreditDAL.LCID = Convert.ToInt32(inputArrayList[0]);
objLetterCreditDAL.LCDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[1].ToString());
objLetterCreditDAL.LCExpiry = CommonObjects.ConvertMMDDYYYY(inputArrayList[2].ToString());
objLetterCreditDAL.ShipmentDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[3].ToString());
objLetterCreditDAL.VendorId = Convert.ToInt32(inputArrayList[4]);
objLetterCreditDAL.BankId = Convert.ToInt32(inputArrayList[5]);
objLetterCreditDAL.SupplierBank = Convert.ToInt32(inputArrayList[6]);
objLetterCreditDAL.InsurerId = Convert.ToInt32(inputArrayList[7]);
objLetterCreditDAL.CoverNoteNo = inputArrayList[8].ToString();
objLetterCreditDAL.Remarks = inputArrayList[9].ToString();
objLetterCreditDAL.LCNumber = inputArrayList[10].ToString();
objLetterCreditDAL.InsertMasterRecord(objLetterCreditDAL);
}
public void InsertRecord(ArrayList inputArrayList)
{
objUserMasterDAL.LoginID = inputArrayList[0].ToString();
objUserMasterDAL.Pwd = inputArrayList[1].ToString();
objUserMasterDAL.FullName = inputArrayList[2].ToString();
objUserMasterDAL.Phone = inputArrayList[3].ToString();
objUserMasterDAL.Mobile = inputArrayList[4].ToString();
objUserMasterDAL.Email = inputArrayList[5].ToString();
objUserMasterDAL.Address = inputArrayList[6].ToString();
objUserMasterDAL.Admin = Convert.ToInt16(inputArrayList[7]);
objUserMasterDAL.RoleID = Convert.ToInt32(inputArrayList[8].ToString());
objUserMasterDAL.Active = Convert.ToInt16(inputArrayList[9]);
objUserMasterDAL.Qualification = inputArrayList[10].ToString();
objUserMasterDAL.References = inputArrayList[11].ToString();
objUserMasterDAL.EmergencyNo = inputArrayList[12].ToString();
objUserMasterDAL.AppointmentDate = CommonObjects.ConvertMMDDYYYY(inputArrayList[13].ToString());
objUserMasterDAL.Others = inputArrayList[14].ToString();
objUserMasterDAL.BranchId = Convert.ToInt32(inputArrayList[15].ToString());
objUserMasterDAL.LocationId = inputArrayList[16].ToString();
objUserMasterDAL.InsertRecord(objUserMasterDAL);
}