public UserProvider GetByUserID(string Uid) { string filterExpression = "U.UserID='" + Uid + "'"; DataSet ds = new DataSet(); try { SqlCommand command = new SqlCommand(); this.ConnectionOpen(); command.Connection = Connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = StoredProcedureNames.UserGet; command.Parameters.Add("@FilterExpression", SqlDbType.VarChar).Value = filterExpression; command.Parameters.Add("@Option", SqlDbType.Int).Value = DBConstants.DataLoadingOption.LoadWithFilterExpression; sqlDataAdapter = new SqlDataAdapter(command); sqlDataAdapter.Fill(ds); this.ConnectionClosed(); } catch (SqlException exp) { throw new Exception(exp.Message); } if ((ds == null) || (ds.Tables[0].Rows.Count == 0)) { return(null); } else { return(DataTableConversion.ToCollection <UserProvider>(ds.Tables[0])[0]); } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = iTicketService.GetByID(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); Number.Text = dt.Rows[0]["Number"].ToString(); Price.Text = dt.Rows[0]["Price"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } } else { DataTable dt = new DataTable(); bool result = iTicketService.Delete(Convert.ToInt32(id)); if (result) { bindGrid(); } } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { //rowcommand for grid view function performing int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = iPositionInterface.GetPositionByIDFunc(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); PositionName.Text = dt.Rows[0]["PositionName"].ToString(); DailyRate.Text = dt.Rows[0]["DailyRate"].ToString(); MonthlyRate.Text = dt.Rows[0]["MonthlyRate"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } } else { DataTable dt = new DataTable();//datatable instance bool result = iPositionInterface.DeletePositionFunc(Convert.ToInt32(id)); if (result) { bindGrid(); } } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = jobInterface.GetJobByID(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); JobName.Text = dt.Rows[0]["Job"].ToString(); MinSalary.Text = dt.Rows[0]["MinSalary"].ToString(); MaxSalary.Text = dt.Rows[0]["MaxSalary"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } } else { DataTable dt = new DataTable(); bool result = jobInterface.DeleteJob(Convert.ToInt32(id)); if (result) { bindGrid(); } } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { //TeacherAllocationViewModel vmModel = new TeacherAllocationViewModel(); int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); //vmModel.ID = Convert.ToInt32(id); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = iTeacherAllocationService.GetTeacherAllocationByID(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); ClassMasterID.Text = dt.Rows[0]["ClassMasterID"].ToString(); TeacherMasterID.Text = dt.Rows[0]["TeacherMasterID"].ToString(); StudentMasterID.Text = dt.Rows[0]["StudentMasterID"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } } else { DataTable dt = new DataTable(); bool result = iTeacherAllocationService.DeleteTeacherAllocation(Convert.ToInt32(id)); if (result) { bindGrid(); } } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { //EmployeeModel vmModel = new EmployeeModel(); int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); //vmModel.ID = Convert.ToInt32(id); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = iProductSupplierRepository.GetProductSupplierByID(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); SupplierID.Text = dt.Rows[0]["SupplierID"].ToString(); ProductID.Text = dt.Rows[0]["ProductID"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } } else { DataTable dt = new DataTable(); bool result = iProductSupplierRepository.DeleteProductSupplier(Convert.ToInt32(id)); if (result) { bindGrid(); } } }
protected void bindGrid() { DataTableConversion lsttodt = new DataTableConversion(); var lst = iProductSupplierRepository.ProductSupplierLists(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { grd.DataSource = dt; grd.DataBind(); } else { grd.DataBind(); } }
protected void bindGrid() { DataTableConversion lsttodt = new DataTableConversion(); var lst = jobInterface.GetJobList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { grd.DataSource = dt; grd.DataBind(); } else { grd.DataBind(); } }
protected void bindGrid() { DataTableConversion lsttodt = new DataTableConversion(); var lst = iTeacherAllocationService.GetTeacherAllocationList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { grd.DataSource = dt; grd.DataBind(); } else { grd.DataBind(); } }
protected void bindGrid() { DataTableConversion lsttodt = new DataTableConversion(); var lst = iCustomerService.Lists(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { grd.DataSource = dt; grd.DataBind(); } else { grd.DataBind(); } }
protected void bindGrid()//gridview binding { DataTableConversion lsttodt = new DataTableConversion(); var lst = iPositionInterface.GetPositionListFunc(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { grd.DataSource = dt; grd.DataBind(); } else { grd.DataBind(); } }
protected void bindGrid()//bind grid method for binding the gridview { DataTableConversion lsttodt = new DataTableConversion(); var lst = _empService.GetEmployeeDataFunc(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { grd.DataSource = dt; grd.DataBind(); } else { grd.DataBind(); } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { //ClassMasterViewModel vmModel = new ClassMasterViewModel(); int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); //vmModel.ID = Convert.ToInt32(id); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = iClassMasterService.GetClassMasterByID(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); ClassName.Text = dt.Rows[0]["ClassName"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } //if (lst != null) //{ // HiddenField1.Value = lst.ID.ToString(); // ClassName.Text = lst.ClassName; // Submit.Text = "Update"; //} //else //{ // //do nothing // Submit.Text = "Save"; //} } else { DataTable dt = new DataTable(); bool result = iClassMasterService.DeleteClassMaster(Convert.ToInt32(id)); if (result) { bindGrid(); } } }
protected void bindStudentList() { DataTableConversion lsttodt = new DataTableConversion(); IStudentMasterService service = new StudentMasterService(); var lst = service.GetStudentMasterList().Select(x => new { x.Name, x.ID }).ToList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { StudentMasterID.DataSource = dt; StudentMasterID.DataTextField = "Name"; StudentMasterID.DataValueField = "ID"; StudentMasterID.DataBind(); } else { StudentMasterID.DataBind(); } }
protected void bindDepartmentList() { DataTableConversion lsttodt = new DataTableConversion(); DepartmentInterface service = new DepartmentBussiness(); var lst = service.GetDepartmentList().Select(x => new { x.Name, x.ID }).ToList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { DepartmentID.DataSource = dt; DepartmentID.DataTextField = "Name"; DepartmentID.DataValueField = "ID"; DepartmentID.DataBind(); } else { DepartmentID.DataBind(); } }
protected void bindSeatList() { DataTableConversion lsttodt = new DataTableConversion(); ISeatService service = new SeatService(); var lst = service.Lists().Select(x => new { Name = x.SeatNumber + " " + x.SeatSide, x.ID }).ToList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { SeatID.DataSource = dt; SeatID.DataTextField = "Name"; SeatID.DataValueField = "ID"; SeatID.DataBind(); } else { SeatID.DataBind(); } }
protected void bindSupplierList() { DataTableConversion lsttodt = new DataTableConversion(); ISupplierRepository repository = new SupplierRepository(); var lst = repository.SupplierLists().Select(x => new { x.Name, x.ID }).ToList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { SupplierID.DataSource = dt; SupplierID.DataTextField = "Name"; SupplierID.DataValueField = "ID"; SupplierID.DataBind(); } else { SupplierID.DataBind(); } }
protected void bindClassList() { DataTableConversion lsttodt = new DataTableConversion(); IClassMasterService service = new ClassMasterService(); var lst = service.GetClassMasterList().Select(x => new { x.ClassName, x.ID }).ToList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { ClassMasterID.DataSource = dt; ClassMasterID.DataTextField = "ClassName"; ClassMasterID.DataValueField = "ID"; ClassMasterID.DataBind(); } else { ClassMasterID.DataBind(); } }
protected void bindJobList() { DataTableConversion lsttodt = new DataTableConversion(); JobInterface service = new JobBussiness(); var lst = service.GetJobList().Select(x => new { x.Job, x.ID }).ToList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { JobID.DataSource = dt; JobID.DataTextField = "Job"; JobID.DataValueField = "ID"; JobID.DataBind(); } else { JobID.DataBind(); } }
protected void bindEmployeeList()//binding the employee dropdown { DataTableConversion lsttodt = new DataTableConversion(); IEmployeeInterface service = new EmployeeRepository(); var lst = service.GetEmployeeDataFunc().Select(x => new { x.Name, x.ID }).ToList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { EmployeeID.DataSource = dt; EmployeeID.DataTextField = "Name"; EmployeeID.DataValueField = "ID"; EmployeeID.DataBind(); } else { EmployeeID.DataBind(); } }
protected void bindPositionList()//binding the position dropdown { DataTableConversion lsttodt = new DataTableConversion(); IPositionInterface service = new PositionRepository(); var lst = service.GetPositionListFunc().Select(x => new { x.PositionName, x.ID }).ToList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { PositionID.DataSource = dt; PositionID.DataTextField = "PositionName"; PositionID.DataValueField = "ID"; PositionID.DataBind(); } else { PositionID.DataBind(); } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { //EmployeeModel vmModel = new EmployeeModel(); int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); //vmModel.ID = Convert.ToInt32(id); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = iCustomerService.GetByID(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); TicketID.Text = dt.Rows[0]["TicketID"].ToString(); SeatID.Text = dt.Rows[0]["SeatID"].ToString(); Name.Text = dt.Rows[0]["Name"].ToString(); MobileNumber.Text = dt.Rows[0]["MobileNumber"].ToString(); Email.Text = dt.Rows[0]["EmailID"].ToString(); //HireDate.Text = dt.Rows[0]["HireDate"].ToString(); //Salary.Text = dt.Rows[0]["Salary"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } } else { DataTable dt = new DataTable(); bool result = iCustomerService.Delete(Convert.ToInt32(id)); if (result) { bindGrid(); } } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { //StudentMasterViewModel vmModel = new StudentMasterViewModel(); int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); //vmModel.ID = Convert.ToInt32(id); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = iStudentMasterService.GetStudentMasterByID(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); Name.Text = dt.Rows[0]["Name"].ToString(); FatherName.Text = dt.Rows[0]["FatherName"].ToString(); Address.InnerText = dt.Rows[0]["Address"].ToString(); PhoneNumber.Text = dt.Rows[0]["PhoneNo"].ToString(); Email.Text = dt.Rows[0]["Email"].ToString(); DOB.Text = dt.Rows[0]["DOB"].ToString(); GenderList.Text = dt.Rows[0]["Gender"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } } else { DataTable dt = new DataTable(); bool result = iStudentMasterService.DeleteStudentMaster(Convert.ToInt32(id)); if (result) { bindGrid(); } } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { //row command method int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = _empService.GetEmployeeDataByIDFunc(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); PositionID.Text = dt.Rows[0]["PositionID"].ToString(); Name.Text = dt.Rows[0]["Name"].ToString(); PhoneNumber.Text = dt.Rows[0]["PhoneNo"].ToString(); Email.Text = dt.Rows[0]["Email"].ToString(); DOBDate.Text = dt.Rows[0]["DOB"].ToString(); FatherName.Text = dt.Rows[0]["FatherName"].ToString(); Address.InnerText = dt.Rows[0]["Address"].ToString(); GenderList.Text = dt.Rows[0]["Gender"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } } else { DataTable dt = new DataTable(); bool result = _empService.DeleteEmployeeDataFunc(Convert.ToInt32(id)); if (result) { bindGrid(); } } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { //EmployeeModel myModel = new EmployeeModel(); int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); //myModel.ID = Convert.ToInt32(id); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = employeeInterface.GetEmployeeByID(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); JobID.Text = dt.Rows[0]["tblJobID"].ToString(); DepartmentID.Text = dt.Rows[0]["tblDepartment"].ToString(); Name.Text = dt.Rows[0]["Name"].ToString(); PhoneNumber.Text = dt.Rows[0]["PhoneNumber"].ToString(); Email.Text = dt.Rows[0]["Email"].ToString(); HireDate.Text = dt.Rows[0]["HireDate"].ToString(); Salary.Text = dt.Rows[0]["Salary"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } } else { DataTable dt = new DataTable(); bool result = employeeInterface.DeleteEmployee(Convert.ToInt32(id)); if (result) { bindGrid(); } } }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { //Grid command row function int rowIndex = Convert.ToInt32(e.CommandArgument.ToString()); string id = this.grd.DataKeys[rowIndex]["ID"].ToString(); if (e.CommandName == "updates") { DataTableConversion lsttodt = new DataTableConversion(); var lst = iPayrollInterface.GetPayrollByIDFunc(Convert.ToInt32(id)); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { HiddenField1.Value = dt.Rows[0]["ID"].ToString(); EmployeeID.Text = dt.Rows[0]["EmployeeID"].ToString(); NoOfLeaves.Text = dt.Rows[0]["NoOfLeaves"].ToString(); GrossSalary.Text = dt.Rows[0]["GrossSalary"].ToString(); TotalDeduction.Text = dt.Rows[0]["TotalDeduction"].ToString(); NetPay.Text = dt.Rows[0]["NetPay"].ToString(); Submit.Text = "Update"; } else { Submit.Text = "Save"; } } else { DataTable dt = new DataTable(); bool result = iPayrollInterface.DeletePayrollFunc(Convert.ToInt32(id)); if (result) { bindGrid(); } } }