public void ReceiptBookIdBind()
{
btnprint.Visible = true;
if (txtReceiptBookId.Text == "")
{
}
else
{
int ActualReceiptNo = Convert.ToInt32(txtReceiptBookId.Text.Trim());
//txtempcode.Text = ECode;
DataTable dt1 = ReciptBookDetails.getReceiptBookDetails(ECode, "1", "2", ActualReceiptNo).Tables[1];
gvshow.DataSource = dt1;
if (dt1.Rows.Count != 0)
{
gvshow.DataBind();
gvshow.Visible = true;
Button1.Visible = false;
gvshow.Visible = true;
}
else
{
MessageBox("No Data Found");
lblempname.Text = "";
lblempname.Visible = false;
txtReceiptBookId.Focus();
txtReceiptBookId.Text = "";
gvshow.DataSource = null;
gvshow.Visible = false;
}
}
}
protected void txtempcode_TextChanged(object sender, EventArgs e)
{
btnprint.Visible = true;
string ECode = txtempcode.Text.ToString().Split(':')[0].Trim();
DataTable dt = new DataTable();
dt = DCMaster.Get_Name(ECode, "Employee").Tables[0];
if (dt.Rows.Count != 0)
{
txtempcode.Text = ECode;
lblempname.Text = dt.Rows[0]["FirstName"] + " " + dt.Rows[0]["MiddleName"] + " " + dt.Rows[0]["LastName"];
DataTable dt1 = ReciptBookDetails.getReceiptBookDetails(ECode, "1", "2", ActualReceiptNo).Tables[1];
gvshow.DataSource = dt1;
gvshow.DataBind();
gvshow.Visible = true;
Button1.Visible = false;
}
else
{
lblempname.Text = "No such salesman code";
txtempcode.Focus();
txtempcode.Text = "";
gvshow.Visible = false;
}
}
public void EmpId()
{
// DataSet dsEmp = new DataSet();
ACId = ReciptBookDetails.IDV_CHETANA_Get_ReceiptBookDetails_MaxID(out ActualReceiptNo);
txtActualrec.Text = Convert.ToString(ACId);
}
public void Bind()
{
if (rdorecnumwise.Checked)
{
if (txtReceiptBook.Text.Trim() != "")
{
ActualReceiptNo = Convert.ToInt32(txtReceiptBook.Text.Trim());
DataTable dt = new DataTable();
dt = ReciptBookDetails.Idv_Chetana_Get_ReceiptBookDetails_Report(ActualReceiptNo).Tables[0];
if (dt.Rows.Count > 0)
{
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("Report/ReceiptBookDetails.rpt"));
rd.SetDataSource(dt);
ReceiptDetailsReport.ReportSource = rd;
}
else
{
ActualReceiptNo = Convert.ToInt32("0");
MessageBox("No Record Found");
txtReceiptBook.Focus();
// txtReceiptBook.Text = "";
}
}
else
{
MessageBox("Enter Receipt BookID");
}
}
else
{
if (txtFromDate.Text != "" && txtTo.Text != "")
{
//TODO: check whether to Date is bigger than from date or not
DataSet ds = new DataSet();
ds = OtherClass.Idv_Chetana_Report_ReceiptDatewise(Convert.ToDateTime(txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2]),
Convert.ToDateTime(txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]));
ReportDocument rd = new ReportDocument();
//DateTime t=Convert.ToDateTime(txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2]);
rd.Load(Server.MapPath("Report/ReceiptBookDatewise.rpt"));
rd.SetDataSource(ds.Tables[0]);
ReceiptDetailsReport.ReportSource = rd;
}
else
{
MessageBox("Enter proper From Date / To Date");
}
}
}
protected void gvshow_RowEditing(object sender, GridViewEditEventArgs e)
{
ReciptBookDetails update = new ReciptBookDetails();
Receiptsave.Visible = true;
pnlshow.Visible = false;
Panel1.Visible = true;
lblID.Text = ((Label)gvshow.Rows[e.NewEditIndex].FindControl("lblid")).Text;
txtmrcode.Text = ((Label)gvshow.Rows[e.NewEditIndex].FindControl("lblempid")).Text;
txtfrom.Text = ((Label)gvshow.Rows[e.NewEditIndex].FindControl("lblFromNo")).Text.Split('-')[0];
txtto.Text = ((Label)gvshow.Rows[e.NewEditIndex].FindControl("lblFromNo")).Text.Split('-')[1];
//update.Save();
}
public DataView BindGvBookDetail()
{
DataTable dt1 = ReciptBookDetails.getReceiptBookDetails(val, "1", "2", 0).Tables[1];
DataView dv = new DataView(dt1);
return(dv);
gvshow.DataSource = dt1;
gvshow.DataBind();
gvshow.Visible = true;
// Button1.Visible = false;
//DataTable dt = new DataTable();
//dt = Books.GetBookMaster();
//DataView dv = new DataView(dt);
}
protected void txtReciptNo_TextChanged(object sender, EventArgs e)
{
try
{
int receiptNo = Convert.ToInt32(txtReciptNo.Text.Trim());
DataTable dt = new DataTable();
dt = ReciptBookDetails.Idv_Chetana_Get_ReceiptView_AT_EntryTime(receiptNo).Tables[0];
if (dt.Rows.Count != 0)
{
// lblempname.Text = dt.Rows[0]["Name"].ToString() + "::Rec No:" + receiptNo;
lblshow.Text = dt.Rows[0]["Name"].ToString() + "::Rec No:" + receiptNo;
txtEMcode.Text = dt.Rows[0]["EmpCode"].ToString();
lblempname.Visible = true;
pnlCust.Visible = true;
}
else
{
message("ReceiptNo not allocated");
txtReciptNo.Focus();
lblempname.Text = "";
lblempname.Text = "Rec No:" + receiptNo;
lblempname.Visible = true;
txtReciptNo.Text = "";
txtEMcode.Text = "";
lblshow.Text = "";
}
string Auth = ReciptBookDetails.getReciptbook_valid(receiptNo);
txtcustomerid.Focus();
if (Auth != "enter")
{
MessageBox(Auth);
txtReciptNo.Text = "";
txtReciptNo.Focus();
}
else
{
}
}
catch (Exception ex)
{
}
}
protected void gvBouncedetails_RowEditing(object sender, GridViewEditEventArgs e)
{
ReciptBookDetails update = new ReciptBookDetails();
bool isEditable = Convert.ToBoolean(((Label)gvReceiptEdit.Rows[e.NewEditIndex].FindControl("lblEditable")).Text);
if (isEditable == false)
{
btnSave.Visible = false;
MessageBox("This Record is locked for Edit");
lblIsEditable.Visible = true;
}
else
{
btnSave.Visible = true;
}
Receiptsave.Visible = true;
pnlshow.Visible = false;
Panel1.Visible = true;
gvReceiptEdit.Visible = false;
pnlreceiptno.Visible = false;
lblrecid.Text = ((Label)gvReceiptEdit.Rows[e.NewEditIndex].FindControl("lblcust_id2")).Text;
txtmrcode.Text = ((Label)gvReceiptEdit.Rows[e.NewEditIndex].FindControl("lbl_emp2")).Text;
lblFromNo_Old.Text = ((Label)gvReceiptEdit.Rows[e.NewEditIndex].FindControl("lblCheque_Date2")).Text.Split('-')[0];
lblToNo_Old.Text = ((Label)gvReceiptEdit.Rows[e.NewEditIndex].FindControl("lblCheque_Date2")).Text.Split('-')[1];
txtfrom.Text = ((Label)gvReceiptEdit.Rows[e.NewEditIndex].FindControl("lblCheque_Date2")).Text.Split('-')[0];
txtto.Text = ((Label)gvReceiptEdit.Rows[e.NewEditIndex].FindControl("lblCheque_Date2")).Text.Split('-')[1];
lblmrName.Text = ((Label)gvReceiptEdit.Rows[e.NewEditIndex].FindControl("lbl_BounceAmount2")).Text;
txtActualrec.Text = ((Label)gvReceiptEdit.Rows[e.NewEditIndex].FindControl("lblActualReceiptEdit")).Text;
if (txtActualrec.Text == "")
{
txtActualrec.Enabled = true;
}
else
{
txtActualrec.Enabled = false;
}
}
public void Bind()
{
ReceiptBookId = txtReceiptBook.Text.Trim() + "," + txttoNo.Text.Trim();
DataTable dt = new DataTable();
dt = ReciptBookDetails.Idv_Chetana_Report_ReceiptBook(ReceiptBookId).Tables[0];
if (dt.Rows.Count != 0)
{
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("Report/ReceiptBook.rpt"));
rd.SetDataSource(dt);
ReceiptReport.ReportSource = rd;
}
else
{
MessageBox("No Record Found");
txtReceiptBook.Focus();
txtReceiptBook.Text = "";
}
}
protected void view_Click(object sender, EventArgs e)
{
if ((Convert.ToInt32(txtFrom.Text.Trim())) > (Convert.ToInt32(txtTo.Text.Trim())))
{
message("FromNo should be greater than ToNo");
txtFrom.Focus();
}
else
{
//pnlCust.Visible = false;
// PnlCustDiscDetails.Visible = false;
//UpanelGrd.Visible = true;
string ECode = txtEMcode.Text.ToString().Split(':')[0].Trim();
//txtempcode.Text = ECode;
int FromNo = Convert.ToInt32(txtFrom.Text);
int ToNo = Convert.ToInt32(txtTo.Text);
DataSet ds = new DataSet();
ds = ReciptBookDetails.Get_Multiplecanceldetails(ECode, FromNo, ToNo);
if (ds.Tables[0].Columns.Count > 1)
{
gvMultipleCancel.DataSource = ds;
gvMultipleCancel.DataBind();
btn_Save.Visible = true;
gvMultipleCancel.Visible = true;
}
else
{
message("Record not found between entered Receipt no.");
}
// Pnlmultiplecancel.Visible = true;
// gvMultipleCancel.Visible = true;
// btn_Save.Visible = true;
}
// message("Select Correct allocation Ranges Receipt No");
}
protected void btn_Save_Click1(object sender, EventArgs e)
{
if (Session["UserName"] != null)
{
string ECode = txtEMcode.Text.ToString().Split(':')[0].Trim();
//txtempcode.Text = ECode;
int FromNo = Convert.ToInt32(txtFrom.Text);
int ToNo = Convert.ToInt32(txtTo.Text);
DataSet ds = new DataSet();
ds = ReciptBookDetails.Get_Multiplecanceldetails(ECode, FromNo, ToNo);
if (ds.Tables[0].Columns.Count > 1 & redio.SelectedIndex == 0)
{
ReciptCancelBook reccan = new ReciptCancelBook();
reccan.AutoCancelRecNo = Convert.ToInt32("0");
reccan.EmpCode = txtEMcode.Text.Trim();
reccan.FromNo = Convert.ToInt32(txtFrom.Text.Trim());
reccan.ToNo = Convert.ToInt32(txtFrom.Text.Trim());
reccan.Resion = txtResion.Text.Trim();
reccan.CreatedBy = Session["UserName"].ToString();
reccan.Save();
message("Record Saved Successfully");
//pnlCust.Visible = true;
//PnlCustDiscDetails.Visible = true;
//UpanelGrd.Visible = false;
txtEMcode.Text = "";
txtFrom.Text = "";
txtTo.Text = "";
txtResion.Text = "";
gvMultipleCancel.DataSource = null;
gvMultipleCancel.DataBind();
multipal.Update();
//btn_Save.Visible = false;
}
else
{
if (gvMultipleCancel.Rows.Count > 0)
{
Label lblReceiptNo = null;
TextBox txtReasonGrd = null;
CheckBox chkSelect = null;
foreach (GridViewRow row in gvMultipleCancel.Rows)
{
lblReceiptNo = (Label)row.FindControl("lblFromNo");
txtReasonGrd = (TextBox)row.FindControl("remarktext");
chkSelect = (CheckBox)row.FindControl("check");
if (chkSelect.Checked == true)
{
if (lblReceiptNo.Text != "")
{
ReciptCancelBook reccan = new ReciptCancelBook();
reccan.AutoCancelRecNo = Convert.ToInt32("0");
reccan.EmpCode = txtEMcode.Text.Trim();
reccan.FromNo = Convert.ToInt32(lblReceiptNo.Text.Trim());
reccan.ToNo = Convert.ToInt32(lblReceiptNo.Text.Trim());
if (txtReasonGrd.Text != "")
{
reccan.Resion = txtReasonGrd.Text;
}
else
{
reccan.Resion = txtResion.Text.Trim();
}
reccan.CreatedBy = Session["UserName"].ToString();
reccan.Save();
message("Record Saved Successfully");
}
}
}
message("Receipt No not found");
txtEMcode.Text = "";
txtFrom.Text = "";
txtTo.Text = "";
lblshow.Text = "";
txtResion.Text = "";
gvMultipleCancel.DataSource = null;
gvMultipleCancel.DataBind();
multipal.Update();
//btn_Save.Visible = false;
}
}
message("Receipt not found between entered Receipt no.");
}
}
protected void gvshow_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Used")
{
string empid = txtempcode.Text.ToString();
if (redio.Items[1].Selected)
{
ActualReceiptNo = Convert.ToInt32(txtReceiptBookId.Text.Trim());
}
lnkarg = e.CommandArgument.ToString();
fromno = lnkarg.Split('-')[0].ToString();
Tono = lnkarg.Split('-')[1].ToString();
DataTable ds = new DataTable();
ds = (ReciptBookDetails.getReceiptBookDetails(empid, fromno, Tono, ActualReceiptNo).Tables[2]);
GridViewUsed.DataSource = ds;
GridViewUsed.DataBind();
pnlusedDetails.Visible = true;
PanelCancelDetalis.Visible = false;
gvshow.Visible = false;
Button1.Visible = true;
//upCounts.Visible = false;
btnSave.Visible = false;
btnview.Text = "Back";
upCounts.Update();
upDetails.Update();
}
else if (e.CommandName == "CancelReceipt")
{
if (redio.Items[1].Selected)
{
ActualReceiptNo = Convert.ToInt32(txtReceiptBookId.Text.Trim());
}
string empid = txtempcode.Text.ToString();
lnkarg = e.CommandArgument.ToString();
fromno = lnkarg.Split('-')[0].ToString();
Tono = lnkarg.Split('-')[1].ToString();
DataTable ds = new DataTable();
ds = (ReciptBookDetails.getReceiptBookDetails(empid, fromno, Tono, ActualReceiptNo).Tables[3]);
GridViewCancel.DataSource = ds;
GridViewCancel.DataBind();
pnlusedDetails.Visible = false;
PanelCancelDetalis.Visible = true;
gvshow.Visible = false;
btnSave.Visible = false;
Button1.Visible = true;
btnview.Text = "Back";
upCounts.Update();
upDetails.Update();
}
else if (e.CommandName == "Pending")
{
if (redio.Items[1].Selected)
{
ActualReceiptNo = Convert.ToInt32(txtReceiptBookId.Text.Trim());
}
string empid = txtempcode.Text.ToString();
lnkarg = e.CommandArgument.ToString();
fromno = lnkarg.Split('-')[0].ToString();
Tono = lnkarg.Split('-')[1].ToString();
DataTable ds = new DataTable();
ds = (ReciptBookDetails.getReceiptBookDetails(empid, fromno, Tono, ActualReceiptNo).Tables[4]);
GridViewCancel.DataSource = ds;
GridViewCancel.DataBind();
pnlusedDetails.Visible = false;
PanelCancelDetalis.Visible = true;
gvshow.Visible = false;
btnSave.Visible = false;
Button1.Visible = true;
btnview.Text = "Back";
upCounts.Update();
upDetails.Update();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (Session["UserName"] != null)
{
if (Convert.ToInt32(txtfrom.Text.Trim()) >= Convert.ToInt32(txtto.Text.Trim()))
{
message("FromNo should be smaller than ToNo");
}
else if (lblrecid.Text == "0")
{
try
{
if (lblrecid.Text == "0")
{
lblrecid.Text = "0";
}
receiptBookId = Convert.ToInt32(lblrecid.Text.Trim());
int FromNo = Convert.ToInt32(txtfrom.Text.Trim());
//
string ECode = txtmrcode.Text.ToString().Split(':')[0].Trim();
//txtempcode.Text = ECode;
//int FromNo = Convert.ToInt32(txtfrom.Text);
int ToNo = Convert.ToInt32(txtto.Text);
//DataSet ds = new DataSet();
// ds = ReciptBookDetails.Get_Multiplecanceldetails(ECode, FromNo, ToNo);
//
Auth = ReciptBookDetails.getReciptbook_valid1(FromNo, ToNo);
if (Auth)
{
MessageBox(" No. is Already Exist");
txtfrom.Text = "";
txtto.Text = "";
//txtmrcode.Text = "";
txtfrom.Focus();
}
else
{
}
}
catch (Exception ex)
{
}
ReciptBookDetails detl = new ReciptBookDetails();
if (lblID.Text != "")
{
detl.ReceiptBookID = Convert.ToInt32(lblID.Text.Trim());
gvshow.Visible = false;
}
else
{
if (lblrecid.Text == "0")
{
detl.ReceiptBookID = Convert.ToInt32("0");
}
else
{
int receiptBookId = Convert.ToInt32(lblrecid.Text.Trim());
detl.ReceiptBookID = receiptBookId;
//////Update Receipt /////////
///////END////////
}
}
detl.EmpCode = txtmrcode.Text.Trim();
detl.FromNo = Convert.ToInt32(txtfrom.Text.Trim());
detl.ToNo = Convert.ToInt32(txtto.Text.Trim());
detl.ActualReceiptNo = Convert.ToInt32(txtActualrec.Text.Trim());
detl.CreatedBy = Session["UserName"].ToString();
detl.FY = Convert.ToInt32(strFY);
//Auth = ReciptBookDetails.Idv_Chetana_Get_Validate_ActualReceiptNO(ActualReceiptNo);
//if (Auth)
//{
// MessageBox(" No. is Already Exist");
// txtActualrec.Text = "";
// txtActualrec.Text = "";
// }
//else
//{
//}
detl.IsActive = Convert.ToBoolean(true);
EmpId();
detl.Save(out IDNo);
//txtActualrec.Text = Convert.ToInt32(ACId);
lblId3.Text = Convert.ToString("Document NO :" + (IDNo));
message("Record Saved Successfully");
Receiptsave.Visible = true;
pnlshow.Visible = false;
gvshow.Visible = false;
txtmrcode.Text = "";
txtActualrec.Text = "";
lblmrName.Text = "";
txtfrom.Text = "";
txtto.Text = "";
Receiptsave.Visible = true;
if (lblrecid.Text == "0")
{
lblId3.Visible = true;
}
else
{
lblId3.Visible = true;
}
pnlshow.Visible = false;
Panel1.Visible = true;
}
else
{
receiptBookId = Convert.ToInt32(lblrecid.Text.Trim());
string SalesManId_Old = txtmrcode.Text.Trim();
int ReceiptBookID = receiptBookId;
string SalesManCode_New = txtmrcode.Text.Trim();
int FromNo_New = Convert.ToInt32(txtfrom.Text);
int ToNo_New = Convert.ToInt32(txtto.Text);
int ToNo_Old = Convert.ToInt32(lblFromNo_Old.Text);
int FromNo_Old = Convert.ToInt32(lblToNo_Old.Text);
int ActualReceiptNo = Convert.ToInt32(txtActualrec.Text);
DataSet dsEdit = new DataSet();
dsEdit = ReciptBookDetails.Idv_Chetana_Edit_Receipt_Book(SalesManId_Old, FromNo_Old,
ToNo_Old, SalesManCode_New, FromNo_New, ToNo_New, ReceiptBookID, ActualReceiptNo);
if (dsEdit.Tables[0].Rows.Count != 0)
{
lblEditRece1.Text = dsEdit.Tables[0].Rows[0]["FromNo"].ToString();
lblEditRece.Text = dsEdit.Tables[0].Rows[0]["ToNo"].ToString();
lblStatus.Text = dsEdit.Tables[0].Rows[0]["ReceiptStatus"].ToString();
lblStatus.Visible = true;
lblEditRece.Visible = true;
lblEditRece1.Visible = true;
}
//
// int receiptBookId = Convert.ToInt32(lblrecid.Text.Trim());
// ReceiptBookEdit recEdit = new ReceiptBookEdit();
// recEdit.CreatedBy = Session["UserName"].ToString();
// recEdit.Update();
// message("Record Updated Successfully");
Receiptsave.Visible = true;
pnlshow.Visible = false;
gvshow.Visible = false;
txtActualrec.Text = "";
txtmrcode.Text = "";
lblmrName.Text = "";
txtfrom.Text = "";
txtto.Text = "";
Receiptsave.Visible = true;
pnlshow.Visible = false;
Panel1.Visible = true;
}
}
}
catch (Exception ex)
{
}
}
