public void ReportGrid(string RepCondition) { try { DataTable dt = db.Displaygrid("select id as # , ProjectName, Comapanyid , Customer , ProjectstartDate , ProjectEndDate from Project_master"); DS.Tables.Add(dt); if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0) { GrdReport.DataSource = DS.Tables[0]; GrdReport.DataBind(); } else { GrdReport.DataSource = null; GrdReport.DataBind(); } ddlcompany.DataSource = db.Displaygrid("select 0 as CompanyId,' --Select Company--' as CompanyName union select CompanyId, CompanyName from CompanyMaster where IsDeleted = 0"); ddlcompany.DataValueField = "CompanyId"; ddlcompany.DataTextField = "CompanyName"; ddlcompany.DataBind(); } catch (Exception ex) { throw new Exception(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { txtFromDate.Text = System.DateTime.Now.ToString("dd/MM/yyyy"); txtToDate.Text = System.DateTime.Now.ToString("dd/MM/yyyy"); GrdReport.DataSource = db.Displaygrid("select distinct(Enquirydetails.supplier) , (enquirymaster.id) as #, Enquirydetails.reamrk , enquirymaster.date , enquirymaster.enno from Enquirydetails inner join enquirymaster on enquirymaster.enno=Enquirydetails.enno order by enquirymaster.enno desc"); GrdReport.DataBind(); } }
//go Event #region [Go event] protected void btnGo_Click(object sender, EventArgs e) { try { EWA_StudentAttendance objEWA = new EWA_StudentAttendance(); BL_StudentAttendance objBAL = new BL_StudentAttendance(); objEWA.OrgId = Convert.ToInt32(Session["OrgId"]); objEWA.CourseId = ddlCourses.SelectedValue.Trim(); objEWA.ClassId = ddlClasses.SelectedValue.Trim(); objEWA.DivisionId = ddlDivision.SelectedValue.Trim(); objEWA.BranchId = ddlBranches.SelectedValue.Trim(); objEWA.SubjectId = ddlSelectSubject.SelectedValue.Trim(); objEWA.Date = txtSelectDate.Text; objEWA.Time = txtTime.Text; DataSet ds = new DataSet(); ds = objBAL.BL_StudentAttendanceData(objEWA); if (ds.Tables[0] == null) { //btnUpdate.Visible = false; //btnSave.Visible = true; BindGrid(); } else { } db.cnopen(); if (RadioButtonList1.SelectedValue == "Present") { grdAttendance.DataSource = db.Displaygrid("SELECT isnull(tblStudent.RollNo,0)RollNo, tblStudetnClassAttendanceMaster.AttendanceDate, tblStudetnClassAttendanceMaster.AttendanceTime, tblStudent.FirstName + ' ' + tblStudent.MiddleName + ' ' + tblStudent.LastName AS Studentname, tblClass.ClassName, tblCourse.CourseName, tblBranch.BranchName, tblOrganization.OrgName, tblSubject.SubjectName FROM tblStudetnClassAttendanceMaster INNER JOIN tblStudentClassAttendance ON tblStudetnClassAttendanceMaster.AttendanceId = tblStudentClassAttendance.AttendanceID INNER JOIN tblClass ON tblStudetnClassAttendanceMaster.ClassId = tblClass.ClassId INNER JOIN tblCourse ON tblStudetnClassAttendanceMaster.CourseId = tblCourse.CourseId INNER JOIN tblBranch ON tblClass.BranchId = tblBranch.BranchId AND tblCourse.CourseId = tblBranch.CourseId AND tblStudetnClassAttendanceMaster.BranchId = tblBranch.BranchId INNER JOIN tblOrganization ON tblCourse.OrgId = tblOrganization.OrganizationId AND tblStudetnClassAttendanceMaster.OrgId = tblOrganization.OrganizationId INNER JOIN tblSubject ON tblClass.ClassId = tblSubject.ClassId AND tblCourse.CourseId = tblSubject.CourseId AND tblBranch.BranchId = tblSubject.BranchId AND tblOrganization.OrganizationId = tblSubject.OrgId AND tblStudetnClassAttendanceMaster.SubjectId = tblSubject.SubjectId INNER JOIN tblEmployee ON tblOrganization.OrganizationId = tblEmployee.OrgId AND tblStudetnClassAttendanceMaster.EmployeeId = tblEmployee.UserCode INNER JOIN tblStudent ON tblStudentClassAttendance.StudentID = tblStudent.UserCode and tblStudent.orgid= tblStudetnClassAttendanceMaster.OrgID WHERE(tblStudentClassAttendance.Status = 'P' And tblStudetnClassAttendanceMaster.CourseId='" + ddlCourses.SelectedValue.Trim() + "' and tblStudetnClassAttendanceMaster.ClassId='" + ddlClasses.SelectedValue.Trim() + "' and tblSubject.SubjectId = '" + ddlSelectSubject.SelectedValue + "' and tblStudetnClassAttendanceMaster.AttendanceDate='" + txtSelectDate.Text + "' and tblStudetnClassAttendanceMaster.OrgID=" + Session["OrgId"].ToString() + ") Order By tblStudent.RollNo"); grdAttendance.DataBind(); } else { //grdAttendance.DataSource = db.Displaygrid(" SELECT tblStudetnClassAttendanceMaster.AttendanceDate, tblStudetnClassAttendanceMaster.AttendanceTime, tblStudentClassAttendance.StudentID, tblStudentClassAttendance.StudentName, tblClass.ClassName, tblCourse.CourseName, tblBranch.BranchName, tblOrganization.OrgName, tblDivision.DivisionName, tblSubject.SubjectName FROM tblStudetnClassAttendanceMaster INNER JOIN tblStudentClassAttendance ON tblStudetnClassAttendanceMaster.AttendanceId = tblStudentClassAttendance.AttendanceID INNER JOIN tblClass ON tblStudetnClassAttendanceMaster.ClassId = tblClass.ClassId INNER JOIN tblCourse ON tblStudetnClassAttendanceMaster.CourseId = tblCourse.CourseId INNER JOIN tblBranch ON tblClass.BranchId = tblBranch.BranchId AND tblCourse.CourseId = tblBranch.CourseId AND tblStudetnClassAttendanceMaster.BranchId = tblBranch.BranchId INNER JOIN tblOrganization ON tblCourse.OrgId = tblOrganization.OrganizationId AND tblStudetnClassAttendanceMaster.OrgId = tblOrganization.OrganizationId INNER JOIN tblDivision ON tblClass.ClassId = tblDivision.ClassId AND tblStudetnClassAttendanceMaster.DivId = tblDivision.DivisionId INNER JOIN tblSubject ON tblClass.ClassId = tblSubject.ClassId AND tblCourse.CourseId = tblSubject.CourseId AND tblBranch.BranchId = tblSubject.BranchId AND tblOrganization.OrganizationId = tblSubject.OrgId AND tblStudetnClassAttendanceMaster.SubjectId = tblSubject.SubjectId INNER JOIN tblEmployee ON tblOrganization.OrganizationId = tblEmployee.OrgId AND tblStudetnClassAttendanceMaster.EmployeeId = tblEmployee.UserCode WHERE (tblStudentClassAttendance.Status = ' ' And tblStudetnClassAttendanceMaster.CourseId='" + ddlCourses.SelectedValue.Trim() + "' and tblStudetnClassAttendanceMaster.ClassId='" + ddlClasses.SelectedValue.Trim() + "' and tblSubject.SubjectId = '" + ddlSelectSubject.SelectedValue + "' and tblStudetnClassAttendanceMaster.AttendanceDate='" + txtSelectDate.Text + "')"); grdAttendance.DataSource = db.Displaygrid("SELECT isnull(tblStudent.RollNo,0)RollNo, tblStudetnClassAttendanceMaster.AttendanceDate, tblStudetnClassAttendanceMaster.AttendanceTime, tblStudent.FirstName + ' ' + tblStudent.MiddleName + ' ' + tblStudent.LastName AS Studentname, tblClass.ClassName, tblCourse.CourseName, tblBranch.BranchName, tblOrganization.OrgName, tblSubject.SubjectName FROM tblStudetnClassAttendanceMaster INNER JOIN tblStudentClassAttendance ON tblStudetnClassAttendanceMaster.AttendanceId = tblStudentClassAttendance.AttendanceID INNER JOIN tblClass ON tblStudetnClassAttendanceMaster.ClassId = tblClass.ClassId INNER JOIN tblCourse ON tblStudetnClassAttendanceMaster.CourseId = tblCourse.CourseId INNER JOIN tblBranch ON tblClass.BranchId = tblBranch.BranchId AND tblCourse.CourseId = tblBranch.CourseId AND tblStudetnClassAttendanceMaster.BranchId = tblBranch.BranchId INNER JOIN tblOrganization ON tblCourse.OrgId = tblOrganization.OrganizationId AND tblStudetnClassAttendanceMaster.OrgId = tblOrganization.OrganizationId INNER JOIN tblSubject ON tblClass.ClassId = tblSubject.ClassId AND tblCourse.CourseId = tblSubject.CourseId AND tblBranch.BranchId = tblSubject.BranchId AND tblOrganization.OrganizationId = tblSubject.OrgId AND tblStudetnClassAttendanceMaster.SubjectId = tblSubject.SubjectId INNER JOIN tblEmployee ON tblOrganization.OrganizationId = tblEmployee.OrgId AND tblStudetnClassAttendanceMaster.EmployeeId = tblEmployee.UserCode INNER JOIN tblStudent ON tblStudentClassAttendance.StudentID = tblStudent.UserCode and tblStudent.orgid= tblStudetnClassAttendanceMaster.OrgID WHERE(tblStudentClassAttendance.Status = 'A' And tblStudetnClassAttendanceMaster.CourseId='" + ddlCourses.SelectedValue.Trim() + "' and tblStudetnClassAttendanceMaster.ClassId='" + ddlClasses.SelectedValue.Trim() + "' and tblSubject.SubjectId = '" + ddlSelectSubject.SelectedValue + "' and tblStudetnClassAttendanceMaster.AttendanceDate='" + txtSelectDate.Text + "' and tblStudetnClassAttendanceMaster.OrgID=" + Session["OrgId"].ToString() + ") Order By tblStudent.RollNo"); grdAttendance.DataBind(); } db.cnclose(); // BindGrid(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
public void ReportGrid(string RepCondition) { try { GrdReport.DataSource = db.Displaygrid("select id as # , length from length"); GrdReport.DataBind(); } catch (Exception ex) { throw new Exception(ex.Message); } }
void select_qry() { try { int flag = 0; string qry = "Select SrNo = ROW_NUMBER() OVER (ORDER BY PM.Property ) , PM.Property +' '+ UnitNo as 'Property Name' ,PMM.PartyName as 'Party Name' ,case when IsGenerated=0 then 'UnPaid' end as Status ,PRD.Amount as Rent,Convert(nvarchar,PRD.FromDate,106) as 'Rental From',Convert(Nvarchar,PRD.ToDate,106) as 'Rental Up To',PMP.FortheMonthYear,PMP.RentalAmount from Property_RentCard PR inner join PropertyRentDetails PRD On PR.PropertyRentCardId=PRD.PropertyRentCardId inner join PropertyMonthMapping PMP on PMP.ProRentDtlsId=PRD.ProRentDtlsId inner join PropertyMaster PM on PR.PropertyId=PM.PropertyId inner join PartyMaster PMM on PMM.PartyId=PR.PartyId Where PR.Isdeleted=0 and PMP.IsGenerated=0 and "; if (chkmonth.Checked == true) { qry += "Convert(datetime,'01/' + FortheMonthYear,103) <='" + txtformonth.Text + "' "; flag++; } if (TxtParty.Text != "") { if (flag != 0) { qry += "and "; } int PartyId = Convert.ToInt32(hdvSerchParty.Value); qry += " (PMM.PartyId='" + PartyId + "')"; flag++; } if (txtProperty.Text != "") { if (flag != 0) { qry += "and "; } int propId = Convert.ToInt32(hdvSerchProj.Value); qry += " (PR.PropertyId='" + propId + "' )"; //qry += " date ='" + txttodate.Text + "'"; flag++; } if (flag == 0) { qry = "Select SrNo = ROW_NUMBER() OVER (ORDER BY PM.Property ) , PM.Property +' '+ UnitNo as 'Property Name' ,PMM.PartyName as 'Party Name' ,case when IsGenerated=0 then 'UnPaid' end as Status ,PRD.Amount as Rent,Convert(nvarchar,PRD.FromDate,106) as 'Rental From',Convert(Nvarchar,PRD.ToDate,106) as 'Rental Up To',PMP.FortheMonthYear,PMP.RemaingAmount from Property_RentCard PR inner join PropertyRentDetails PRD On PR.PropertyRentCardId=PRD.PropertyRentCardId inner join PropertyMonthMapping PMP on PMP.ProRentDtlsId=PRD.ProRentDtlsId inner join PropertyMaster PM on PR.PropertyId=PM.PropertyId inner join PartyMaster PMM on PMM.PartyId=PR.PartyId inner join FlatTypeMaster FTM on FTM.FlatTypeId=PR.FlatTypeId Where PR.Isdeleted=0 and PMP.IsGenerated=0 "; } GrdProjectReport.DataSource = db.Displaygrid(qry); GrdProjectReport.DataBind(); ViewState["Summary"] = db.Displaygrid(qry); } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserName"].ToString() != "" && Session["UserName"].ToString() != null) { binddrpdrpindentno(); bindcompany(); // grdiparticular.DataBind(); ENNO = db.getDb_Value("select max(id) from enquirymaster "); ENNO++; lblenquiryno.Text = "ENQ" + ENNO.ToString(); txtdate.Text = System.DateTime.Now.ToString("dd/MM/yyyy"); ReportGrid.DataSource = db.Displaygrid("select distinct(Enquirydetails.supplier) , (enquirymaster.id) as #, Enquirydetails.reamrk , enquirymaster.date , enquirymaster.enno from Enquirydetails inner join enquirymaster on enquirymaster.enno=Enquirydetails.enno order by enquirymaster.enno desc "); ReportGrid.DataBind(); txtdate.Text = System.DateTime.Now.ToString("dd/MM/yyyy"); } else { Response.Redirect("~/Default.aspx"); } } ENNO = db.getDb_Value("select max(id) from enquirymaster "); ENNO++; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { chk = 0; drpenquiry.DataSource = db.Displaygrid("select distinct(enqid) from Supplierenquiryitem where enqid NOT IN ( Select enquiry from Conversionpo) "); drpenquiry.DataTextField = "enqid"; drpenquiry.DataValueField = "enqid"; drpenquiry.DataBind(); drpenquiry.Items.Insert(0, "-Select Enquiry -"); drpproject.DataSource = db.Displaygrid("SELECT ProjectName ,id FROM Project_master "); drpproject.DataTextField = "ProjectName"; drpproject.DataValueField = "ProjectName"; drpproject.DataBind(); drpproject.Items.Insert(0, "-Select Project -"); ReportGrid.DataSource = db.Displaygrid("select distinct project ,enquiry , enquiry as # ,status as Status from Conversionpo "); ReportGrid.DataBind(); GETHIGHLITE(); } else { chk = 0; grdreport.DataSource = db.Displaygrid("DECLARE @cols NVARCHAR(MAX) SELECT @cols = COALESCE(@cols + ',[' + (supplier ) + ']','[' + (supplier) + ']' ) FROM supplierenquirydetails where enqid='"+ drpenquiry.SelectedValue + "' DECLARE @qry NVARCHAR(4000) SET @qry = 'SELECT * FROM (select itemname as Itemname, particular as Particular, qty as Qty ,rate ,supplier as Supplier from demosupplierenquiry )emp PIVOT (MAX(rate) FOR supplier IN (' + @cols + ')) AS stat' exec(@qry)"); grdreport.DataBind(); } }
private void BindGridData() { EWA_Messages objEWA = new EWA_Messages(); BL_Messages objBL = new BL_Messages(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.FacultyId = Session["UserCode"].ToString(); objEWA.Action = "FetchStaffMessage"; ds = objBL.BindGrdViewAnnouncement_BL(objEWA); if (ds.Tables[0].Rows.Count == 0) { GrdViewAnnouncement.DataSource = ReturnEmptyDataTable(); GrdViewAnnouncement.DataBind(); GrdViewAnnouncement.Columns[3].Visible = false; GrdViewAnnouncement.Rows[0].Cells[0].ColumnSpan = 3; GrdViewAnnouncement.Rows[0].Cells[1].Visible = false; GrdViewAnnouncement.Rows[0].Cells[2].Visible = false; lblNoMessageFound.Visible = true; } else { // GrdViewAnnouncement.DataSource = db.Displaygrid(" SELECT DISTINCT ms.MessageId, md.StaffUserCode, er.FirstName + ' ' + er.MiddleName + ' ' + er.LastName AS 'Sender', ms.Subject, CONVERT(varchar, md.SendDate, 107) AS 'SendDate', ms.MessageContent FROM tblMessageSave AS ms INNER JOIN tblEmployee AS er ON ms.StaffUserCode = er.UserCode INNER JOIN tblMessageDetails AS md ON ms.MessageId = md.MessageId WHERE (ms.MessageId IN (SELECT MessageId FROM tblMessageDetails WHERE (StaffUserCode = '" + objEWA.FacultyId + "'))) AND (ms.OrgId = '" + objEWA.OrgId + "') "); GrdViewAnnouncement.DataSource = db.Displaygrid(" SELECT DISTINCT ms.MessageId, md.StaffUserCode, er.FirstName + ' ' + er.MiddleName + ' ' + er.LastName AS 'Sender', ms.Subject, CONVERT(varchar, md.SendDate, 107) AS 'SendDate', ms.MessageContent FROM tblMessageSave AS ms INNER JOIN tblMessageDetails AS md ON ms.MessageId = md.MessageId INNER JOIN tblEmployee AS er ON ms.StaffUserCode = er.UserCode WHERE (ms.MessageId IN (SELECT MessageId FROM tblMessageDetails WHERE (StaffUserCode = '" + objEWA.FacultyId + "'))) AND (md.StaffUserCode = '" + objEWA.FacultyId + "') AND (ms.OrgId = '" + objEWA.OrgId + "') ORDER BY ms.MessageId DESC "); GrdViewAnnouncement.DataBind(); // GrdViewAnnouncement.DataBind(); dsGrdViewAnnouncement = ds.Copy(); } }
//Item Grid Bind #region [Item Category Grid Bind] private void BindItemGrid() { try { //DataSet ds = objBL.BindItemGrid_BL(); //if (ds.Tables[0].Rows.Count == 0 || ds == null) //{ // ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); // GrdItem.DataSource = ds; // GrdItem.DataBind(); // int columncount = GrdItem.Rows[0].Cells.Count; // GrdItem.Rows[0].Cells.Clear(); // GrdItem.Rows[0].Cells.Add(new TableCell()); // GrdItem.Rows[0].Cells[0].ColumnSpan = columncount; // GrdItem.Rows[0].Cells[0].Text = "No Records Found"; //} //else //{ GrdItem.DataSource = db.Displaygrid("SELECT tblItem.ItemId,tblItem.ItemName, tblItem.ItemCode, tblItem.CategoryId,tblCategory.CategoryName, tblItem.UnitId,tblUnit.UnitName, tblItem.Stock FROM tblItem INNER JOIN tblCategory ON tblItem.CategoryId = tblCategory.CategoryId INNER JOIN tblUnit ON tblItem.UnitId = tblUnit.UnitId WHERE tblItem.OrgId='" + Convert.ToInt32(Session["OrgId"]) + "' "); GrdItem.DataBind(); //} } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Leave Type Bind #region [Leave Type Bind] private void GrdLeaveData() { try { GrdLeaveDetails.DataSource = db.Displaygrid("SELECT ApplicationId AS 'Id',FirstName + ' ' + MiddleName + ' ' + LastName + ' ' AS 'Name',lapp.UserCode AS 'User Code', CONVERT(varchar(15), ApplicationDate,105) AS 'Application Date' ,CONVERT(varchar(15), FromDate,105) AS 'From Date',CONVERT(varchar(15), ToDate,105) AS 'To Date', lapp.Reason,TotalLeave AS 'Total Leave Days',LeaveStatus AS 'Leave Status', lapp.OrgID AS 'Org Id' FROM tblLeaveApplication lapp INNER JOIN tblEmployee emp ON lapp.UserCode = emp.UserCode WHERE lapp.OrgID = "+ Session["OrgId"].ToString() + " and lapp.LeaveStatus = 'Pending' order by (Id)desc"); GrdLeaveDetails.DataBind(); } catch (Exception exp) { GeneralErr(exp.Message); } }
protected void Page_Load(object sender, EventArgs e) { orgId = Convert.ToInt32(Session["OrgId"]); if (orgId == 0) { Response.Redirect("~/CMSHome.aspx"); } GrdStock.DataSource = db.Displaygrid("SELECT tblItem.ItemCode, tblItem.ItemName,tblCategory.CategoryName, tblItem.Stock, tblUnit.UnitName as Unit FROM tblItem INNER JOIN tblCategory ON tblItem.CategoryId = tblCategory.CategoryId INNER JOIN tblUnit ON tblItem.UnitId = tblUnit.UnitId WHERE (tblItem.OrgId = '" + Convert.ToInt32(Session["OrgId"]) + "')"); GrdStock.DataBind();/*tblItem.UserId,*/ //BindItemGrid(); }
public void BindReportGrid(string RepCondition) { try { DataSet DsReport = new DataSet(); string RepCondition1 = string.Empty; //if (!Convert.ToBoolean(Session["IsCentral"].ToString())) //{ // RepCondition1 = RepCondition1 + " AND D.CafeteriaId=" + Convert.ToInt32(Session["CafeteriaId"].ToString()); //} DataTable dt = new DataTable(); dt = db.Displaygrid(" select distinct project , enquiry , enquiry as # , status from Conversionpo where status <> '" + "Authorised" + "' "); DsReport.Tables.Add(dt); if (DsReport.Tables.Count > 0 && DsReport.Tables[0].Rows.Count > 0) { GrdReq.DataSource = DsReport.Tables[0]; GrdReq.DataBind(); } else { GrdReq.DataSource = null; GrdReq.DataBind(); // SetInitialRow_ReqDetails(); } //if (DsReport.Tables.Count > 0 && DsReport.Tables[1].Rows.Count > 0) //{ // LblGen.Text = DsReport.Tables[1].Rows[0][0].ToString(); // LblApprov.Text = DsReport.Tables[1].Rows[0][1].ToString(); // LblAutho.Text = DsReport.Tables[1].Rows[0][2].ToString(); //} //else //{ // LblAutho.Text = LblApprov.Text = LblGen.Text = "0"; //} } catch (Exception ex) { throw new Exception(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { orgId = Convert.ToInt32(Session["OrgId"]); if (orgId == 0) { Response.Redirect("~/CMSHome.aspx"); } else { hdnid.Value = orgId.ToString(); gvcompany.DataSource = db.Displaygrid("select * from tblCompanyPlacementMaster where OrgId='" + Convert.ToInt32(Session["OrgId"]).ToString() + "'"); gvcompany.DataBind(); if (Request.QueryString["Company_id"] != null) { if (!IsPostBack) { clse.Company_id = int.Parse(Request.QueryString["Company_id"].ToString()); ds = clsd.COMPANY(clse); if (ds.Tables[0].Rows.Count > 0) { txtCompanyName.Text = ds.Tables[0].Rows[0]["Company_Name"].ToString(); txtCompanyAddress.Text = ds.Tables[0].Rows[0]["Company_Address"].ToString(); txtCompanyEmail.Text = ds.Tables[0].Rows[0]["Company_email"].ToString(); txtMobileNumber.Text = ds.Tables[0].Rows[0]["Company_mob"].ToString(); txtContactPerson.Text = ds.Tables[0].Rows[0]["Contact_Person"].ToString(); txtwebsite.Text = ds.Tables[0].Rows[0]["Website"].ToString(); txtCriteria.Text = ds.Tables[0].Rows[0]["Criteria"].ToString(); hdbId.Value = (clse.Company_id).ToString(); } else { //btnsave.Visible = true; //btnupdate.Visible = false; //btndelete.Visible = false; } } } } }
protected void btnSave_Click(object sender, EventArgs e) { try { float b = db.getDb_Value("select BookId from tblLibAddBook where OrgId='" + orgId.ToString() + "'and barcode='" + txtBarcode.Text + "'"); bookid.Text = b.ToString(); //string booknam = db.getDbstatus_Value("select BookName from tblLibAddBook where BookId='" + bookid.Text + "'"); //float a = db.getDb_Value("select StudentId from tblStudent where UserCode='" + txtIssueTo.Text + "' and OrgId='"+orgId.ToString()+"'"); //studid.Text = a.ToString(); string status = db.getDbstatus_Value("select count(*) from tblLibIssueBook where StudentId='" + txtIssueTo.Text + "' and BookId='" + bookid.Text + "'"); if (Convert.ToInt32(status) == 0) { db.cnopen(); db.insert("insert into tblLibIssueBook values('" + txtGroupName.Text + "','" + bookid.Text + "','" + txtIssueTo.Text + "','" + DateTime.Now.Date + "','" + txtDueDate.Text + "','" + orgId.ToString() + "','" + Convert.ToInt32(Session["UserCode"].ToString()) + "','" + System.DateTime.Now.ToString("MM/dd/yyyy") + "','" + "True" + "','" + 1 + "','" + txtBarcode.Text + "')"); float getoldstock = float.Parse(lblstock.Text); float newstock = getoldstock - 1; db.insert("update tblLibAddBook set qty='" + newstock + " ' where BookId ='" + bookid.Text + "' and OrgId='" + Convert.ToInt32(Session["OrgId"]) + "'"); db.cnclose(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Book Issued Successfully')", true); clear(); GrdBook.DataSource = db.Displaygrid("SELECT tblStudent.UserCode, tblLibAddBook.BookName, tblLibAddBook.barcode, tblLibIssueBook.IssueDate, tblLibIssueBook.DueDate, tblLibIssueBook.IssueId FROM tblLibIssueBook INNER JOIN tblLibAddBook ON tblLibIssueBook.BookId = tblLibAddBook.BookId INNER JOIN tblStudent ON tblLibAddBook.OrgId = tblStudent.OrgId AND tblLibIssueBook.StudentId = tblStudent.StudentId WHERE tblLibIssueBook.OrgId = '" + orgId.ToString() + "' ORDER BY tblLibIssueBook.IssueId DESC"); GrdBook.DataBind(); } else if (Convert.ToInt32(status) > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Book already Issued ')", true); } } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { orgId = Convert.ToInt32(Session["OrgID"]); if (orgId == 0) { Response.Redirect("~/CMSHome.aspx"); } grdnew.DataSource = db.Displaygrid("SELECT UserCode,FirstName +' '+ MiddleName +' ' +LastName AS StudentName, CourseName,BranchName,TCL.ClassName,TD.DivisionName,TS.Address ,TS.Mobile ,TS.AdharNo FROM tblStudent TS INNER JOIN tblCourse TC ON TC.CourseId=TS.CourseId INNER JOIN tblBranch TB ON TB.BranchId=TS.BranchId INNER JOIN tblClass TCL ON TCL.ClassId=TS.ClassId INNER JOIN tblAcademicYear AY ON AY.AcademicYearId=TS.AcademicYearId WHERE TS.OrgId='"+ Session["OrgId"] + "'"); grdnew.DataBind(); export(); // grdpassword.DataSource = db.Displaygrid ("SELECT tblStudent.FirstName + ' ' + tblStudent.MiddleName + ' ' + tblStudent.LastName AS StudentName, tblStudent.UserCode, tblUser.UserName, tblUser.Password FROM tblStudent INNER JOIN tblUser ON tblStudent.UserCode = tblUser.UserCode where Role='Student' and OrgId='22' "); //.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //gvCustomers.DataSource = GetData("select top 10 * from ItemDetails"); //gvCustomers.DataBind(); bindparty(); bindsupplier(); estmateid = Convert.ToInt32(db.getDb_Value("select max (estmateno) from addrowestimate ")); estmateid++; est.Text = estmateid.ToString(); ReportGrid.DataSource = db.Displaygrid("select indentno as EST_No, indentno as #, party as Project from estimatemaster "); ReportGrid.DataBind(); } }
protected void txtBarcode_TextChanged(object sender, EventArgs e) { try { txtBarcode.Focus(); if (txtBarcode.Text != null) { //SqlCommand cmd1 = new SqlCommand("SELECT tblLibIssueBook.IssueId, tblLibIssueBook.GroupId, tblLibIssueBook.BookId, tblLibIssueBook.IssueDate, tblLibIssueBook.DueDate, tblStudent.UserCode,tblLibIssueBook.StudentId , (tblStudent.FirstName +' ' + tblStudent.MiddleName + ' '+tblStudent.LastName)Firstname FROM tblLibIssueBook INNER JOIN tblStudent ON tblLibIssueBook.StudentId = tblStudent.UserCode where barcode='" + txtBarcode.Text + "'", cn); //SqlDataAdapter adp1 = new SqlDataAdapter(); //DataSet ds1 = new DataSet(); //adp1.SelectCommand = cmd1; //adp1.Fill(ds1); // studid1= Convert.ToInt32(ds1.Tables[0].Rows[0]["IssueId"].ToString()); // bookid.Text = ds1.Tables[0].Rows[0]["BookId"].ToString(); //grpid.Text = ds1.Tables[0].Rows[0]["GroupId"].ToString(); //bookid.Text = ds1.Tables[0].Rows[0]["BookId"].ToString(); //txtIssueDate.Text = Convert.ToDateTime(ds1.Tables[0].Rows[0]["IssueDate"]).ToShortDateString(); //txtDueDate.Text = Convert.ToDateTime(ds1.Tables[0].Rows[0]["DueDate"]).ToShortDateString(); //txtIssueTo.Text = ds1.Tables[0].Rows[0]["UserCode"].ToString(); // txtIssueName.Text = ds1.Tables[0].Rows[0]["Firstname"].ToString(); // // string name = db.getDbstatus_Value("SELECT FirstName + ' ' + MiddleName + ' ' + LastName AS StdName FROM tblStudent WHERE OrgId='" + orgId.ToString() + "' and StudentId='"++"'"); // string abc = db.getDbstatus_Value("select BookName from tblLibAddBook where BookId='" + bookid.Text + "'"); //txtBookName.Text = abc.ToString(); //string author = db.getDbstatus_Value("select Author from tblLibAddBook where BookId='" + bookid.Text + "'"); //txtAuthor.Text = author.ToString(); //string xyz = db.getDbstatus_Value("select GroupName from tblLibAddGroup where GroupId='" + grpid.Text + "' "); //txtGroupName.Text = xyz.ToString(); hdnbarcode.Value = txtBarcode.Text; // hdnfirstname.Value = txtIssueName.Text; gvbook.DataSource = db.Displaygrid("SELECT tblLibIssueBook.IssueId, tblLibAddBook.BookName, tblStudent.FirstName + ' ' + tblStudent.MiddleName + ' ' + tblStudent.LastName as Name, tblLibIssueBook.IssueDate, tblLibIssueBook.DueDate, tblLibIssueBook.barcode, tblLibIssueBook.StudentId FROM tblLibIssueBook INNER JOIN tblLibAddBook ON tblLibIssueBook.BookId = tblLibAddBook.BookId INNER JOIN tblStudent ON tblLibIssueBook.StudentId = tblStudent.UserCode WHERE (tblLibIssueBook.barcode = '" + txtBarcode.Text + "')"); gvbook.DataSourceID = null; gvbook.DataBind(); } } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Not Found')", true); } }
//Bind Grid #region [Bind grid] private void BindGrid() { try { BL_StudentView objBAL = new BL_StudentView(); EWA_StudentView objEWA = new EWA_StudentView(); objEWA.CourseId = ddlcourse.SelectedValue.Trim(); objEWA.BranchId = ddlbranch.SelectedValue.Trim(); objEWA.ClassId = ddlclass.SelectedValue.Trim(); objEWA.OrgId = Convert.ToInt32(Session["OrgId"]); DataSet ds = new DataSet(); ds = objBAL.BL_StudentIcard(objEWA); //if (ds.Tables[0].Rows.Count > 0) //{ database db = new database(); grdIcard.DataSource = db.Displaygrid("SELECT tblStudent.UserCode, tblStudent.FirstName + ' ' + tblStudent.MiddleName + ' ' + tblStudent.LastName AS FullName FROM tblStudent INNER JOIN tblClass ON tblStudent.BranchId = tblClass.BranchId WHERE (tblStudent.OrgId = '" + Convert.ToInt32(Session["OrgId"]) + "') AND (tblStudent.CourseId = '" + ddlcourse.SelectedValue.Trim() + "') AND (tblStudent.BranchId = '" + ddlbranch.SelectedValue.Trim() + "') AND (tblClass.ClassId = '" + ddlclass.SelectedValue.Trim() + "')"); // grdIcard.DataSource = ds.Tables[0]; grdIcard.DataBind(); // } //else //{ // DataTable dt = new DataTable(); // dt.Columns.Add("UserCode"); // dt.Columns.Add("FullName"); // //dt.Rows.Add(); // //dt.Rows.Add(); // //dt.Rows.Add(); // grdIcard.DataSource = dt; // grdIcard.DataBind(); //} } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserName"].ToString() != "" && Session["UserName"].ToString() != null) { txtdate.Text = System.DateTime.Now.ToString("dd/MM/yyyy"); bindsupplier(); lbldate.Text = System.DateTime.Now.ToString("dd/MM/yyyy"); estmateid = Convert.ToInt32(db.getDb_Value("select max (id) from supplierenquirydetails ")); estmateid++; est.Text = estmateid.ToString(); ReportGrid.DataSource = db.Displaygrid(" select enqid as ENQ_No , id as #, supplier as Supplier from supplierenquirydetails order by id desc"); ReportGrid.DataBind(); } else { Response.Redirect("~/Default.aspx"); } } }
protected void lnkBtnStudentName_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)sender; //Get the row that contains this button GridViewRow gvr = (GridViewRow)btn.NamingContainer; string ReceiptNO = grdFees.DataKeys[gvr.RowIndex].Values[0].ToString(); string FeesID = grdFees.DataKeys[gvr.RowIndex].Values[1].ToString(); string TransDate = grdFees.DataKeys[gvr.RowIndex].Values[2].ToString(); lblReceiptNo.Text = ReceiptNO; lblReceiptNo1.Text = ReceiptNO; Label1.Text = txtName.Text; lblDate.Text = TransDate; //todaysdate; lblDate1.Text = TransDate; //todaysdate; float _tamount = db.getDb_Value("select sum(Amount) from tblFeesDetails where FeesId =" + FeesID + " "); float _pamount = db.getDb_Value("select isnull(sum(paidamount),0) from tblstudentfeespaid " + " where studentid =" + txtStudentId.Text + ""); lblReceiptNo.Text = ReceiptNO; lblReceiptNo1.Text = ReceiptNO; Label1.Text = txtName.Text; string RouteId = db.getDbstatus_Value("select isnull((select routeid from tblStudentRouteAssign where UserCode = " + txtStudentId.Text + "),0)"); float _pamount_bus = db.getDb_Value("select isnull((select sum(paidamount) from tblStudentBusFeesPaid where StudentId=" + txtStudentId.Text + "" + " and Studentrouteid=" + RouteId + "),0)"); float _tamount_bus = db.getDb_Value("select isnull((select amount from tblroute where RouteId=" + RouteId + "),0)"); _tamount = _tamount + _tamount_bus; lblTotalFees_Footer.Text = lblTotalFees_Footer1.Text = _tamount.ToString(); _pamount = _pamount + _pamount_bus; lblPendingFees_Footer.Text = lblPendingFees_Footer1.Text = (_tamount - _pamount).ToString(); string query = "select remark Particular,'First/Second Term' Term,(select amount from tblfeesdetails where feesdetailsid=tblStudentFeesPaid.feesdetailsid) 'Total Fees',PaidAmount'Received Fees',PendingAmount 'Due Fees'" + " from tblStudentFeesPaid where studentid='" + txtStudentId.Text + "' and GroupReceiptNo=" + ReceiptNO + "" + " union all " + "select remark Particular,'First/Second Term' Term,TotalAmount 'Total Fees',PaidAmount'Received Fees',PendingAmount 'Due Fees'" + " from tblStudentBusFeesPaid where studentid='" + txtStudentId.Text + "' and ReceiptNo=" + ReceiptNO + ""; DataTable gridDT = db.Displaygrid(query); DataTable gridDT1 = new DataTable(); gridDT1.Columns.Add("Particular"); gridDT1.Columns.Add("Term"); gridDT1.Columns.Add("Total Fees"); gridDT1.Columns.Add("Received Fees"); gridDT1.Columns.Add("Due Fees"); double TF = 0.00, RF = 0.00, DF = 0.00; DataRow dr; for (int i = 0; i < gridDT.Rows.Count; i++) { dr = gridDT1.NewRow(); dr[0] = gridDT.Rows[i]["Particular"].ToString(); dr[1] = gridDT.Rows[i]["Term"].ToString(); dr[2] = gridDT.Rows[i]["Total Fees"].ToString(); dr[3] = gridDT.Rows[i]["Received Fees"].ToString(); dr[4] = gridDT.Rows[i]["Due Fees"].ToString(); TF = TF + Convert.ToDouble(gridDT.Rows[i]["Total Fees"].ToString()); RF = RF + Convert.ToDouble(gridDT.Rows[i]["Received Fees"].ToString()); DF = DF + Convert.ToDouble(gridDT.Rows[i]["Due Fees"].ToString()); gridDT1.Rows.Add(dr); } dr = gridDT1.NewRow(); dr[0] = "Total"; dr[1] = ""; dr[2] = TF; dr[3] = RF; dr[4] = DF; gridDT1.Rows.Add(dr); gridHistory.DataSource = gridDT1; gridHistory.DataBind(); gridHistory1.DataSource = gridDT1; gridHistory1.DataBind(); gridHistory.Rows[gridDT1.Rows.Count - 1].Cells[0].Font.Bold = true; gridHistory.Rows[gridDT1.Rows.Count - 1].Cells[2].Font.Bold = true; gridHistory.Rows[gridDT1.Rows.Count - 1].Cells[3].Font.Bold = true; gridHistory.Rows[gridDT1.Rows.Count - 1].Cells[4].Font.Bold = true; gridHistory1.Rows[gridDT1.Rows.Count - 1].Cells[0].Font.Bold = true; gridHistory1.Rows[gridDT1.Rows.Count - 1].Cells[2].Font.Bold = true; gridHistory1.Rows[gridDT1.Rows.Count - 1].Cells[3].Font.Bold = true; gridHistory1.Rows[gridDT1.Rows.Count - 1].Cells[4].Font.Bold = true; DataTable co_br_cl = db.Displaygrid("SELECT (FirstName + ' ' + MiddleName + ' ' + LastName) AS Name,co.CourseName," + " br.BranchName,cl.ClassName,GRNo,ay.AcademicYear FROM tblStudent st inner join tblCourse co ON co.CourseId=st.CourseId " + " inner join tblBranch br ON br.BranchId=st.BranchId inner join tblClass cl ON cl.ClassId=st.ClassId" + " inner join tblAcademicYear ay ON ay.AcademicYearId=st.AcademicYearId where UserCode='" + txtStudentId.Text + "'"); //Added by Ashwini 23-sep-2020 DataTable dtClassdtls = db.Displaygrid("select tblcourse.Coursename as CourseName,tblclass.ClassName as ClassName,tblBranch.Branchname as BranchName,tblAcademicYear.AcademicYear as AcademicYear from tblFees left join tblcourse on tblcourse.CourseId=tblFees.CourseId left join tblclass on tblclass.ClassId=tblFees.classId left join tblBranch on tblBranch.BranchId = tblFees.BranchId left join tblAcademicYear on tblAcademicYear.AcademicYearId = tblFees.AcademicYearId where FeesId ='" + FeesID + "'"); lblCourse.Text = co_br_cl.Rows[0]["CourseName"].ToString(); lblCourse1.Text = lblCourse.Text; lblStd.Text = co_br_cl.Rows[0]["BranchName"].ToString(); lblStd1.Text = lblStd.Text; lblDiv.Text = co_br_cl.Rows[0]["ClassName"].ToString(); lblDiv1.Text = lblDiv.Text; lblAcademicYear.Text = co_br_cl.Rows[0]["AcademicYear"].ToString(); lblAcademicYear1.Text = lblAcademicYear.Text; // lblName.Text = co_br_cl.Rows[0]["Name"].ToString(); lblName1.Text = lblName.Text; // lblCourse.Text = co_br_cl.Rows[0]["CourseName"].ToString(); // lblCourse1.Text = lblCourse.Text; //lblAcademicYear.Text = co_br_cl.Rows[0]["AcademicYear"].ToString(); //lblAcademicYear1.Text = lblAcademicYear.Text; // lblStd.Text = co_br_cl.Rows[0]["BranchName"].ToString(); // lblStd1.Text = lblStd.Text; // lblDiv.Text = co_br_cl.Rows[0]["ClassName"].ToString(); // lblDiv1.Text = lblDiv.Text; lblGRNo.Text = co_br_cl.Rows[0]["GRNo"].ToString(); lblGRNo1.Text = lblGRNo.Text; MessagePopUp.Show(); }
public void bindreport() { ReportGrid.DataSource = db.Displaygrid("select distinct 0 as # , itemname as TemplateName ,0 as title from nonstnonstdhardware"); ReportGrid.DataBind(); }
protected void btnsave_Click(object sender, EventArgs e) { bindvariable(); if (Convert.ToDecimal(LblPendingAmtvalue.Text) < Convert.ToDecimal(TxtPayAmt.Text)) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('Please Enter Valid Pay Amount')", true); return; } if (Convert.ToDecimal(TxtPayAmt.Text) == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('Please Enter Valid Pay Amount')", true); return; } Label feesId = new Label(); for (int i = 0; i < GrdFeesPaidDetails.Rows.Count; i++) { feesId = (Label)GrdFeesPaidDetails.Rows[i].Cells[0].FindControl("lblFeesID"); } decimal PaidAmt = Convert.ToDecimal(lblPaidAmountValue.Text) + Convert.ToDecimal(TxtPayAmt.Text); decimal PendingAmt = Convert.ToDecimal(lblTotalAmountvalue.Text) - PaidAmt; string TransDate1 = DateTime.Now.Date.ToString("dd/MMM/yyyy"); int UserID1 = Convert.ToInt32(Session["UserCode"].ToString()); db.insert("INSERT INTO [tblPreviousYearFees] ( [CourseId],[BranchId],[ClassId],[AcademicYearId],[StudentId],[TotalAmount],[PaidAmount],[pendingAmount],[PayAmount],[CurrentDate],[FeesID],[UserId]) VALUES ('" + ddlCourse.SelectedValue + "','" + ddlBranch.SelectedValue + "','" + ddlClass.SelectedValue + "','" + DDLAcademicYear.SelectedValue + "','" + ddlStudentname.SelectedValue + "','" + lblTotalAmountvalue.Text + "','" + PaidAmt.ToString() + "','" + PendingAmt.ToString() + "','" + TxtPayAmt.Text + "','" + TransDate1 + "','" + feesId.Text + "','" + UserID1 + "')"); string StudentId1 = ddlStudentname.SelectedValue; GetPaidPreviousFee(); ClearAll(); //-----------------for Print Slip var todaysdate = DateTime.Today.Date.ToString("dd/MM/yyyy"); txtdate1.Text = todaysdate; StudentId1 = lblStudentCode.Text; string UserId = Session["UserCode"].ToString(); string FeesId = feesId.Text; DataTable co_br_cl = db.Displaygrid("SELECT (FirstName + ' ' + MiddleName + ' ' + LastName) AS Name,co.CourseName,br.BranchName,cl.ClassName,GRNo,ay.AcademicYear FROM tblStudent st inner join tblCourse co ON co.CourseId=st.CourseId inner join tblBranch br ON br.BranchId=st.BranchId inner join tblClass cl ON cl.ClassId=st.ClassId inner join tblAcademicYear ay ON ay.AcademicYearId=st.AcademicYearId where UserCode='" + StudentId1 + "'"); DataTable co_br_cl1 = db.Displaygrid("SELECT (FirstName + ' ' + MiddleName + ' ' + LastName) AS Name,co.CourseName,br.BranchName,cl.ClassName,GRNo,ay.AcademicYear FROM tblStudent st inner join tblCourse co ON co.CourseId=st.CourseId inner join tblBranch br ON br.BranchId=st.BranchId inner join tblClass cl ON cl.ClassId=st.ClassId inner join tblAcademicYear ay ON ay.AcademicYearId=st.AcademicYearId where UserCode='" + StudentId1 + "'"); lblCourse.Text = co_br_cl1.Rows[0]["CourseName"].ToString(); lblCourse1.Text = lblCourse.Text; lblAcademicYear1.Text = co_br_cl1.Rows[0]["AcademicYear"].ToString(); Label34.Text = lblAcademicYear1.Text; lblStd1.Text = ddlClass.SelectedItem.Text; lblDiv1.Text = ddlBranch.SelectedItem.Text; lblGRNo1.Text = co_br_cl.Rows[0]["GRNo"].ToString(); lblReceiptNo1.Text = co_br_cl.Rows[0]["Name"].ToString(); lblDate1.Text = Convert.ToDateTime(txtReceiptDate.Text).ToString("dd/MM/yyyy"); string name = co_br_cl.Rows[0]["Name"].ToString(); string[] arrNM = name.Split(' '); lblPrevious1.Text = TxtPayAmt.Text; lblPrevious111.Text = TxtPayAmt.Text; Label8.Text = co_br_cl.Rows[0]["Name"].ToString(); Label10.Text = Convert.ToDateTime(txtReceiptDate.Text).ToString("dd/MM/yyyy"); Label12.Text = ddlClass.SelectedItem.Text; Label14.Text = ddlBranch.SelectedItem.Text; Label17.Text = co_br_cl.Rows[0]["GRNo"].ToString(); }
void select_qry() { try { database db = new database(); int flag = 0; // string qry = "SELECT PaymentMaster.date as Date, PaymentDetails.paidBills as [Bill No], PaymentMaster.supplierName as [Supplier Name], PaymentMaster.grandTotal as [Grand Total], PaymentMaster.paidAmt as [Paid Amount], PaymentMaster.dueAmt as [Balance Amount],PaymentDetails.paymentType as [Payment Mode], PaymentDetails.bankName as [Bank Name], PaymentDetails.chequeNo as [Cheque No], PaymentDetails.chequeDate as [Cheque Date], PaymentDetails.chequeStatus as [Cheque Status] FROM PaymentDetails INNER JOIN PaymentMaster ON PaymentDetails.billNo = PaymentMaster.billNo AND PaymentDetails.voucherNo = PaymentMaster.voucherNo where PaymentMaster.paidAmt<>0 and "; string qry = " SELECT tblEmpAssignDeptDes.UserCode, tblEmployee.FirstName + ' ' + tblEmployee.LastName AS FullName, tblDepartment.DepartmentName, tblDesignation.DesignationName,tblEmployee.IsActive FROM tblEmpAssignDeptDes INNER JOIN tblEmployee ON tblEmpAssignDeptDes.OrgId = tblEmployee.OrgId AND tblEmpAssignDeptDes.UserCode = tblEmployee.UserCode INNER JOIN tblDepartment ON tblEmpAssignDeptDes.DepartmentId = tblDepartment.DepartmentId INNER JOIN tblDesignation ON tblEmpAssignDeptDes.DesignationId = tblDesignation.DesignationId where tblEmployee.OrgId='" + orgID.ToString() + "' and "; if (ddlDepartment.Text != "Select") { if (flag != 0) { qry += "and "; } qry += " ( tblEmpAssignDeptDes.DepartmentId='" + ddlDepartment.SelectedValue.ToString() + "') "; flag++; } if (ddlDesignation.Text != "Select") { if (flag != 0) { qry += "and "; } qry += " tblEmpAssignDeptDes.DesignationId='" + ddlDesignation.SelectedValue.ToString() + "'"; flag++; } DataTable dt = new DataTable(); if (flag == 0) { dt = db.Displaygrid(" SELECT tblEmpAssignDeptDes.UserCode, tblEmployee.FirstName + ' ' + tblEmployee.LastName AS FullName, tblDepartment.DepartmentName, tblDesignation.DesignationName,tblEmployee.IsActive FROM tblEmpAssignDeptDes INNER JOIN tblEmployee ON tblEmpAssignDeptDes.OrgId = tblEmployee.OrgId AND tblEmpAssignDeptDes.UserCode = tblEmployee.UserCode INNER JOIN tblDepartment ON tblEmpAssignDeptDes.DepartmentId = tblDepartment.DepartmentId INNER JOIN tblDesignation ON tblEmpAssignDeptDes.DesignationId = tblDesignation.DesignationId where tblEmployee.OrgId='" + orgID.ToString() + "'"); } else { dt = db.Displaygrid(qry); } // grdSearchFaculty.DataSourceID = db.Displaygrid(qry).ToString(); if (dt.Rows.Count > 0) { grd.Columns[4].Visible = true; grd.DataSource = dt; grd.DataBind(); grd.Columns[4].Visible = false; } else { grd.DataSource = dt; grd.DataBind(); GeneralErr("Record Not Found...!"); //Response.Write("<script>alert('Record Not Found...!')</script>"); } //serial_no(); } catch (Exception ex) { } }
public void directSearch() { try { database db = new database(); int flag = 0; //----Commnented And Added By Ashwini-7-oct-2020---------------------------------------------------------------------------------- //string qury = "SELECT A.AdmissionID,A.AdmissionType,A.FirstName +' '+ A.MiddleName + ' '+ A.LastName as StudentName,A.EMail, " + // "case when(select count(*) from tblFees inner join tblFeesDetails on tblFees.FeesId = tblFeesDetails.FeesId "+ // " where tblFees.ClassId = A.ClassId and tblFees.CasteCategoryId = A.FeesCategory and AcademicYearId ="+ // " (select AcademicYearId from tblAcademicYear where IsCurrentYear = 1 and OrgId="+ orgID.ToString() + "))> 0 then '' else 'Add fees' end as Status" + // " FROM tblAdmissionDetails A where A.OrgId='" + orgID.ToString() + "' and A.Status='"+"Pending"+"' and "; string qury = "SELECT A.AdmissionID,A.AdmissionType,A.FirstName +' '+ A.MiddleName + ' '+ A.LastName as StudentName,A.Mobile, " + "tblCourse.CourseName+' - '+tblBranch.BranchName+' - '+tblClass.ClassName as class," + "tblFeesCategory.FeesCategoryName as Category," + "case when(select count(*) from tblFees inner join tblFeesDetails on tblFees.FeesId = tblFeesDetails.FeesId " + " where tblFees.ClassId = A.ClassId and tblFees.CasteCategoryId = A.FeesCategory and AcademicYearId =" + " (select AcademicYearId from tblAcademicYear where IsCurrentYear = 1 and OrgId=" + orgID.ToString() + "))> 0 then '' else 'Add fees' end as Status" + " FROM tblAdmissionDetails A " + " INNER JOIN tblCourse on tblCourse.CourseId=A.CourseId" + " INNER JOIN tblClass on tblClass.ClassId=A.ClassId" + " INNER JOIN TblBranch on TblBranch.BranchId=A.BranchId" + " INNER JOIN tblFeesCategory on tblFeesCategory.FeesCategoryId=A.FeesCategory" + " where A.OrgId='" + orgID.ToString() + "' and A.Status='" + "Pending" + "' and "; //-------------------------------------------------------------------------------------------------------------------------------------------// if (ddl_Course.Text != "Select") { if (flag != 0) { qury += "and "; } qury += "(A.CourseId='" + ddl_Course.SelectedValue.ToString() + "')"; flag++; } if (ddl_Branch.Text != "Select") { if (flag != 0) { qury += "and"; } qury += "(A.BranchId ='" + ddl_Branch.SelectedValue.ToString() + "')"; flag++; } if (ddl_Class.Text != "Select") { if (flag != 0) { qury += "and"; } qury += "(A.ClassId = '" + ddl_Class.SelectedValue.ToString() + "')"; flag++; } if (txtFromDate.Text != "" && txtToDate.Text != "") { if (flag != 0) { qury += "and"; } // ApplicationDate BETWEEN convert(varchar(10),(CONVERT(Date, @FromDate,103)),121) AND CONVERT(varchar(10), (CONVERT(date, @ToDate, 103)),121) qury += "( A.ApplicationDate BETWEEN (CONVERT(Date, '" + txtFromDate.Text + "',103)) AND CONVERT(varchar(10), (CONVERT(date, '" + txtToDate.Text + "',103)),121))"; flag++; } else if (txtFromDate.Text != "") { if (flag != 0) { qury += "and"; } // ApplicationDate BETWEEN convert(varchar(10),(CONVERT(Date, @FromDate,103)),121) AND CONVERT(varchar(10), (CONVERT(date, @ToDate, 103)),121) qury += "( A.ApplicationDate >= (CONVERT(Date, '" + txtFromDate.Text + "',103)))"; flag++; } else if (txtToDate.Text != "") { if (flag != 0) { qury += "and"; } // ApplicationDate BETWEEN convert(varchar(10),(CONVERT(Date, @FromDate,103)),121) AND CONVERT(varchar(10), (CONVERT(date, @ToDate, 103)),121) qury += "( A.ApplicationDate <= CONVERT(varchar(10), (CONVERT(date, '" + txtToDate.Text + "',103)),121))"; flag++; } if (flag == 0) { //------------------ Commented And Added By Ashwini ---7-oct-2020--------------------------------------------------------------------------// // qury= "SELECT A.AdmissionID,A.AdmissionType,A.FirstName +' '+ A.MiddleName + ' '+ A.LastName as StudentName,A.EMail, " + //"case when(select count(*) from tblFees inner join tblFeesDetails on tblFees.FeesId = tblFeesDetails.FeesId " + //" where tblFees.ClassId = A.ClassId and tblFees.CasteCategoryId = A.FeesCategory and AcademicYearId =" + //" (select AcademicYearId from tblAcademicYear where IsCurrentYear = 1 and OrgId="+ orgID.ToString() + "))> 0 then '' else 'Add fees' end as Status" + //" FROM tblAdmissionDetails A where A.OrgId='" + orgID.ToString() + "' and A.Status='" + "Pending" + "'"; qury = "SELECT A.AdmissionID,A.AdmissionType,A.FirstName +' '+ A.MiddleName + ' '+ A.LastName as StudentName,A.Mobile, " + "tblCourse.CourseName+' - '+tblBranch.BranchName+' - '+tblClass.ClassName as class," + "tblFeesCategory.FeesCategoryName as Category," + "case when(select count(*) from tblFees inner join tblFeesDetails on tblFees.FeesId = tblFeesDetails.FeesId " + " where tblFees.ClassId = A.ClassId and tblFees.CasteCategoryId = A.FeesCategory and AcademicYearId =" + " (select AcademicYearId from tblAcademicYear where IsCurrentYear = 1 and OrgId=" + orgID.ToString() + "))> 0 then '' else 'Add fees' end as Status" + " FROM tblAdmissionDetails A " + " INNER JOIN tblCourse on tblCourse.CourseId=A.CourseId" + " INNER JOIN tblClass on tblClass.ClassId=A.ClassId" + " INNER JOIN TblBranch on TblBranch.BranchId=A.BranchId" + " INNER JOIN tblFeesCategory on tblFeesCategory.FeesCategoryId=A.FeesCategory" + " where A.OrgId='" + orgID.ToString() + "' and A.Status='" + "Pending" + "'"; //-------------------------------------------------------------------------------------------------------------------------------------------// //grdPendingAdmission.DataSource = db.Displaygrid("SELECT AdmissionID,AdmissionType,FirstName +' '+ MiddleName + ' '+ LastName as StudentName,EMail FROM tblAdmissionDetails where OrgId='" + orgID.ToString() + "' and Status='" + "Pending" + "' "); } grdPendingAdmission.DataSource = db.Displaygrid(qury); //grdPendingAdmission.DataSourceID = db.Displaygrid(qury).ToString(); grdPendingAdmission.DataBind(); //serial_no(); } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { try { DataTable dt; database db = new database(); if (Request.QueryString["url"] != null) { Response.Redirect(Request.QueryString["url"]); } if (Request.QueryString["RowIndex"] != null) { int rowIndex = int.Parse(Request.QueryString["RowIndex"]); if (Request.QueryString["FormName"] == "ItemMaster") { dt = (DataTable)Session["ItemData"]; //string product = dt.Rows[rowIndex]["Product"].ToString(); string path = dt.Rows[rowIndex]["DrawingPath"].ToString(); Response.Redirect("Drawing.aspx?url=" + dt.Rows[rowIndex]["DrawingPath"].ToString()); } if (Request.QueryString["FormName"] == "MaterialRequisitionTemplate1") { if (!string.IsNullOrEmpty(Session["customerId"] as string)) { DataSet Ds = Obj_RequisitionCafeteria.GetTemplateData(Convert.ToInt32(Session["customerId"]), string.IsNullOrEmpty("1") ? 1 : Convert.ToDecimal("1"), out StrError); DataTable dm = new DataTable(); dm = Ds.Tables[0]; string path = dm.Rows[rowIndex]["DrawingPath"].ToString(); Response.Redirect("Drawing.aspx?url=" + dm.Rows[rowIndex]["DrawingPath"].ToString()); } } if (Request.QueryString["FormName"] == "MaterialRequisitionTemplate12") { if (!string.IsNullOrEmpty(Session["templateid1"] as string)) { DataSet Ds = db.dgv_display("select DrawingPath from ItemDetails where ItemDetailsId='" + Session["templateid1"] + "'"); DataTable dm = new DataTable(); dm = Ds.Tables[0]; string path = dm.Rows[0]["DrawingPath"].ToString(); Response.Redirect("Drawing.aspx?url=" + dm.Rows[0]["DrawingPath"].ToString()); } } if (Request.QueryString["FormName"] == "MaterialRequisitionTemplate") { if (!string.IsNullOrEmpty(Session["categoryid"] as string)) { dt = db.Displaygrid("select ItemCategory.CategoryId as [#] , '0' as ItemToolTip, ItemMaster.ItemId ,ItemMaster.SubcategoryId ,ItemMaster.CategoryId, ItemCategory.CategoryName ,SubCategory.SubCategory , ItemMaster.ItemCode ,ItemName + ' => ' + isnull(ItemMaster.ItemRemark,' ') + ' => ' + isnull(SubCategory.Remark,' ') as ItemName, '' as Location,ItemDetails.OpeningStock as AvlQty, ItemDetails.OpeningStock as txtAvlQty , 0 as TransitQty, ItemMaster.MinStockLevel,ItemMaster.MaxStockLevel, ItemMaster.DeliveryPeriod,ISNULL(ItemDetails.ItemDetailsId,0)as ItemDetailsId,0 as UnitConvDtlsId, ItemDetails.PurchaseRate as AvgRate ,ItemMaster.AsOn as AvgRateDate , 'Demo' as Vendor, '1' as VendorId, ItemDetails.PurchaseRate as Rate ,'abc' as Priority,'0' as IsCancel, '1' as PriorityID , ItemDetails.ToQty as txtOrdQty , '0' as RequiredDate ,'0' as Remark , ItemDetails.DrawingPath from ItemMaster inner join ItemCategory on ItemCategory.CategoryId=ItemMaster.CategoryId inner join SubCategory on SubCategory.SubCategoryId=ItemMaster.SubcategoryId inner join ItemDetails on ItemDetails.ItemId=ItemMaster.ItemId where ItemCategory.CategoryId='" + Session["categoryid"] + "' "); //string product = dt.Rows[rowIndex]["Product"].ToString(); string path = dt.Rows[rowIndex]["DrawingPath"].ToString(); Response.Redirect("Drawing.aspx?url=" + dt.Rows[rowIndex]["DrawingPath"].ToString()); } else if (!string.IsNullOrEmpty(Session["templateid"] as string)) { DataSet Ds = Obj_RequisitionCafeteria.GetTemplateData(Convert.ToInt32(Session["templateid"]), string.IsNullOrEmpty("1") ? 1 : Convert.ToDecimal("1"), out StrError); DataTable dm = new DataTable(); dm = Ds.Tables[0]; string path = dm.Rows[rowIndex]["DrawingPath"].ToString(); Response.Redirect("Drawing.aspx?url=" + dm.Rows[rowIndex]["DrawingPath"].ToString()); } } else { dt = (DataTable)Session["StockData"]; string product = dt.Rows[rowIndex]["Product"].ToString(); //GrdReport.DataKeys[gvr.RowIndex]["Product"].ToString(); var query = from a in dt.AsEnumerable() where a.Field <string>("Product") == product select a; // Display records from the query foreach (var EmpID in query) { //Response.Write("<script type='text/javascript'>"); //Response.Write("window.open('Drawing.aspx?url=~/ScannedDrawings/Kunal Passports.pdf','_blank');"); //Response.Write("</script>"); // ScriptManager.RegisterStartupScript(Page, Page.GetType(), "popup", "window.open('~/Reports/Drawing.aspx?url=~/ScannedDrawings/Kunal Passports.pdf','_blank')", true); string path = dt.Rows[rowIndex]["DrawingPath"].ToString(); //Response.Redirect(path); Response.Redirect("Drawing.aspx?url=" + dt.Rows[rowIndex]["DrawingPath"].ToString()); //Process.Start(@"~/ScannedDrawings/Kunal Passports.pdf"); } } } } //Since you use Bound Fields, use row.Cells[] to read values catch (Exception ex) { StrError = ex.Message; if (StrError == "Thread was being aborted.") { Obj_Comm.ShowPopUpMsg("Please Check drawing path..!!", this.Page); } else { Obj_Comm.ShowPopUpMsg(StrError, this.Page); } } }