protected void Clear(object sender, EventArgs e) { txtRoomNo.Text = ""; btnSave.Text = "Save"; ddlGuestName.SelectedIndex = 0; DivServiceDesk.Visible = false; divCaptionServiceDesk.Visible = false; divTotalCheckOutPrice.Visible = false; GrdGuestList.DataSource = null; GrdGuestList.DataBind(); GrdServiceDesk.DataSource = null; GrdServiceDesk.DataBind(); lbltaxableamt.Text = ""; lbltaxAmt1.Text = ""; lbltaxAmt2.Text = ""; lbltaxAmt3.Text = ""; lblTaxName1.Text = ""; lblTaxName2.Text = ""; lblTaxName3.Text = ""; lblTaxRate1.Text = ""; lblTaxRate2.Text = ""; lblTaxRate3.Text = ""; lblGrandTotal.Text = ""; lblDisocuntAmt.Text = ""; lblDiscountPer.Text = ""; }
private void ServiceDeskDetail() { try { Decimal Amount = 0; Decimal ItemPrice = 0; Decimal TotalPrice = 0; int i = 0; DataTable dt = new DataTable(); objML_Visitors.Name = ddlGuestName.SelectedValue != "" ? ddlGuestName.SelectedValue : null; objML_Visitors.RoomNo = txtRoomNo.Text != "" ? txtRoomNo.Text : null; dt = objBL_Visitors.BL_Select_Service_Desk_Detail(objML_Visitors); if (dt.Rows.Count > 0) { GrdServiceDesk.DataSource = dt; GrdServiceDesk.DataBind(); for (i = 0; i <= dt.Rows.Count - 1; i++) { Amount = Convert.ToDecimal(dt.Rows[i]["ItemPrice"]); ItemPrice = ItemPrice + Amount; } DivServiceDesk.Visible = true; divCaptionServiceDesk.Visible = true; } else { DivServiceDesk.Visible = false; divCaptionServiceDesk.Visible = false; divTotalCheckOutPrice.Visible = false; } // taxable AMount and Service Desk Amount TotalPrice = Convert.ToDecimal(lbltaxableamt.Text); TotalPrice = TotalPrice + ItemPrice; lblServiceDeskAmt.Text = Convert.ToString(ItemPrice); lblTotalAmount.Text = Convert.ToString(TotalPrice); // End // Grand Total After Discount decimal GrandTotal = TotalPrice - Convert.ToDecimal(lblDisocuntAmt.Text); lblGrandTotal.Text = Convert.ToString(GrandTotal); // ENd DivGuestDetail.Visible = true; divTotalCheckOutPrice.Visible = true; } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('" + ex.Message.ToString() + "')", true); } }
protected void Serach(object sender, EventArgs e) { try { con.Open(); SqlTransaction trans = con.BeginTransaction(IsolationLevel.ReadCommitted); DataTable dt = new DataTable(); string qry = ""; string GuestName = ""; if (ddlGuestName.SelectedValue == "Choose a Guest Name...") { GuestName = ""; } else { GuestName = ddlGuestName.SelectedValue; } qry = " select ROW_NUMBER() OVER(ORDER BY SPCN_Service_Desk_Master.ServiceID ASC) AS RowNo,SPCN_Service_Desk_Master.*,spcn_check_in.GuestName,SPCN_Hotel_Item_Master.ItemName from SPCN_Service_Desk_Master left join spcn_check_in on spcn_check_in.VisitorID=SPCN_Service_Desk_Master.GuestName inner join SPCN_Hotel_Item_Master on SPCN_Hotel_Item_Master.ItemID=SPCN_Service_Desk_Master.ItemID where 2=2 and (SPCN_Service_Desk_Master.GuestName='" + ddlGuestName.SelectedValue + "' or isnull('" + GuestName + "','')='') and (SPCN_Service_Desk_Master.ModifyDate>=convert(datetime,'" + txtfromdate.Text + "',103)) and (SPCN_Service_Desk_Master.ModifyDate>=convert(datetime,'" + txtfromdate.Text + "',103)) "; SqlCommand cmd = new SqlCommand(); dt = clsDBFuncationality.GetDataTable(qry); //cmd = new SqlCommand(qry, con); //cmd.Transaction = trans; //cmd.Clone(); //SqlDataReader dr = cmd.ExecuteReader(); //while (dr.Read()) //{ // dt.Load(dr); //} if (dt.Rows.Count > 0) { GrdServiceDesk.DataSource = dt; GrdServiceDesk.DataBind(); lblMsg.Text = ""; } else { lblMsg.Text = "No Records Found"; GrdServiceDesk.DataSource = ""; GrdServiceDesk.DataBind(); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('" + ex.Message.ToString() + "')", true); } }
protected void PrintAllPages(object sender, EventArgs e) { GrdServiceDesk.AllowPaging = false; GrdServiceDesk.DataBind(); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GrdServiceDesk.RenderControl(hw); string gridHTML = sw.ToString().Replace("\"", "'") .Replace(System.Environment.NewLine, ""); StringBuilder sb = new StringBuilder(); sb.Append("<script type = 'text/javascript'>"); sb.Append("window.onload = new function(){"); sb.Append("var printWin = window.open('', '', 'left=0"); sb.Append(",top=0,width=1000,height=600,status=0');"); sb.Append("printWin.document.write(\""); sb.Append(gridHTML); sb.Append("\");"); sb.Append("printWin.document.close();"); sb.Append("printWin.focus();"); sb.Append("printWin.print();"); sb.Append("printWin.close();};"); sb.Append("</script>"); ClientScript.RegisterStartupScript(this.GetType(), "GridPrint", sb.ToString()); GrdServiceDesk.AllowPaging = true; GrdServiceDesk.DataBind(); }