public void FetchRecordPending() { EnableControls(); string SqlPass = null; SqlCommand Cmd = new SqlCommand(); SqlPass = "******"; Cmd = new SqlCommand(SqlPass, obj.Connection()); Cmd.CommandType = CommandType.StoredProcedure; Cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 10).Value = Session["EmpCode"]; Cmd.Parameters.Add("@Param", SqlDbType.VarChar, 20).Value = DrpLvStatus.SelectedItem.Text; SqlDataAdapter Da = new SqlDataAdapter(Cmd); DataSet ds = new DataSet(); Da.Fill(ds); if (ds.Tables.Count == 0) { GridExtTask.DataSource = null; GridExtTask.DataBind(); string script = "alert('No Record Found');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); return; } else { GridExtTask.DataSource = ds.Tables[0]; GridExtTask.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindAddressGrid(); cardno = Session["Empcode"].ToString(); try { string sql = "jct_payroll_Contact_InfoFetch"; SqlCommand cmd = new SqlCommand(sql, obj.Connection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 30).Value = Session["Empcode"].ToString(); //cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 30).Value = "9000000334"; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { TxtPri_Mobile.Text = dr["PrimaryMobileNo"].ToString(); txtlandline.Text = dr["PrimaryLandlineNo"].ToString(); TxtSecondaryLandline.Text = dr["SecondaryLandlineNo"].ToString(); TxtEmailID.Text = dr["EmailID"].ToString(); } } dr.Close(); } catch (Exception ex) { string script = "alert(''" + ex.Message + "'');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); } } }
public void CheckEligibility() { try { string sql = "Jct_Payroll_reimbursement_Req_Disablebuttons"; SqlCommand cmd = new SqlCommand(sql, obj.Connection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 10).Value = Session["Empcode"]; //cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 10).Value = "9000000443"; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { } } dr.Close(); } catch (Exception ex) { CheckEligile = 1; DisableControlsTwo(); //string Scrpt = "alert('" + ex.Message + "');"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", Scrpt, true); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //ViewState["YEARMONTH"] = Request.QueryString["YEARMONTH"].ToString(); //ViewState["empcode"] = Request.QueryString["empcode"].ToString(); //ViewState["YEARMONTH"] = "201810"; //ViewState["empcode"] = "9000000334"; //requestID = Convert.ToInt32(Request.QueryString["requestid"]); CheckEligibility(); if (CheckEligile == 0) { string sql = "Jct_Payroll_Converyance_Voucher_Print_Header"; SqlCommand cmd = new SqlCommand(sql, obj.Connection()); cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@Srno", SqlDbType.Int).Value = requestID; //cmd.Parameters.Add("@YearMonth", SqlDbType.Int).Value = ViewState["YEARMONTH"]; //cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 10).Value = Session["Empcode"]; cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 10).Value = "9000000443"; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { //lblPlant.Text = dr["Plant"].ToString(); //lblLocation.Text = dr["Location"].ToString(); lblDepartment.Text = dr["Department"].ToString(); lbldesignation.Text = dr["Designation"].ToString(); lblEmployeeName.Text = dr["EmployeeName"].ToString(); lblEmployeecode.Text = dr["EmployeeCode"].ToString(); //lblCardNo.Text = dr["CardNo"].ToString(); lblPrintdate.Text = dr["PrintDate"].ToString(); //lblFromp.Text = dr["FromDate"].ToString(); //lblTodatep.Text = dr["ToDate"].ToString(); lblEmployeeName0.Text = dr["Period"].ToString(); } } else { string script = "alert(No data available!!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); return; } dr.Close(); BindLIst(); } } }
public void Yearmonth() { string Sqlpass = "******"; SqlCommand cmd = new SqlCommand(Sqlpass, obj.Connection()); SqlDataReader dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows == true) { this.DTP2.SelectedValue = dr[2].ToString(); DTP3.Text = dr[1].ToString(); } dr.Close(); }
private void GetData() { try { string sql = "Jct_Payroll_OnlinePF_ValidateFetch"; SqlCommand cmd = new SqlCommand(sql, Obj.Connection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UanNo", SqlDbType.VarChar, 15).Value = txtUANNO.Text.ToString(); cmd.Parameters.Add("@Pass", SqlDbType.VarChar, 12).Value = TextBox1.Text.ToString(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { dr.Close(); Response.Redirect("OnlinePFLoanApply.aspx?UANNO=" + txtUANNO.Text); } } else { dr.Close(); string script = "alert('Credentials is Incorrect.!!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); } } catch (Exception ex) { string script = "alert(''" + ex.Message + "'');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); } }
protected void lnkapply_Click(object sender, EventArgs e) { try { SqlCommand cmd = new SqlCommand("JCT_Payroll_LeaveEncashment_Apply", obj.Connection()); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); //con.Open(); //cmd.Parameters.Add("@year_month", SqlDbType.VarChar, 10).Value = Convert.ToInt32(OvertimeDt); cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 10).Value = Session["Empcode"]; //cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 10).Value = "9000000334"; cmd.Parameters.Add("@autoid", SqlDbType.Int).Value = gencode(); //cmd.Parameters.Add("@EnterPersonName", SqlDbType.VarChar, 30).Value = txtEntpername1.Text; //cmd.Parameters.Add("@PersonCompanyName", SqlDbType.VarChar, 30).Value = txtpercomname1.Text; //cmd.Parameters.Add("@PersonDesignation", SqlDbType.VarChar, 30).Value = txtperdesg1.Text; //cmd.Parameters.Add("@PlaceofEnter", SqlDbType.VarChar, 30).Value = txtplaceenter1.Text; //cmd.Parameters.Add("@remarks", SqlDbType.VarChar, 50).Value = txtpurpose1.Text; //cmd.Parameters.Add("@DriverName", SqlDbType.VarChar, 25).Value = txtDriverName1.Text; cmd.ExecuteNonQuery(); Sendmail(); //con.Close(); string script = "alert('Leave Encashment Applied Successfully.!! ');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); return; } catch (Exception ex) { string script = "alert('" + ex.Message + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); } }
public void fetchrecordload() { try { string sql = "JCt_Payroll_TaxComputation_Accept_view"; SqlCommand cmd = new SqlCommand(sql, obj.Connection()); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 0; cmd.Parameters.Add("@empcode", SqlDbType.VarChar, 10).Value = Session["EmpCode"]; cmd.ExecuteNonQuery(); SqlDataAdapter Da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); Da.Fill(ds); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); if (ds.Tables[0].Rows.Count > 0) { //string script = "alert('No Record Found');"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); //return; rblMeasurementSystem.Visible = true; LinkButton1.Visible = true; lblcat.Visible = true; Label5.Visible = true; } else { rblMeasurementSystem.Visible = false; LinkButton1.Visible = false; lblcat.Visible = false; Label5.Visible = false; } } catch (Exception ex) { string script2 = "alert('" + ex.Message + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script2, true); return; } finally { obj.ConClose(); } }
public void Locationbind() { string sql = "Jct_Payroll_Reim_Attendence_LastFourMonth"; SqlCommand cmd = new SqlCommand(sql, obj.Connection()); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 0; cmd.Parameters.Add("@employeecode", SqlDbType.VarChar, 10).Value = Session["EmpCode"]; cmd.ExecuteNonQuery(); SqlDataAdapter Da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); Da.Fill(ds); DrpLvStatus.Items.Clear(); DrpLvStatus.DataSource = ds; DrpLvStatus.DataTextField = "Monthyear"; DrpLvStatus.DataValueField = "Monthyear"; DrpLvStatus.DataBind(); }
public void RejectReasonList() { SqlCommand sqlCmd = new SqlCommand("SELECT Reason,Reason FROM Jct_Payroll_ConvReimb_RejectReason WHERE STATUS = 'A' ORDER BY srno ", obj.Connection()); sqlCmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(sqlCmd); DataSet ds = new DataSet(); da.Fill(ds); ddlReasonReject.Items.Clear(); ddlReasonReject.DataSource = ds; ddlReasonReject.DataTextField = "Reason"; ddlReasonReject.DataValueField = "Reason"; ddlReasonReject.DataBind(); }
public void Componentlist() { string sql = "Jct_Payroll_Reimbursement_ParameterList"; SqlCommand cmd = new SqlCommand(sql, obj.Connection()); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); ddldedtype.DataSource = ds; ddldedtype.DataTextField = "ComponentName"; ddldedtype.DataValueField = "ComponentCode"; ddldedtype.DataBind(); }
private DataTable GetData(string query) { //DataTable dt = new DataTable(); //OleDbConnection VMScon = new OleDbConnection(objcon.Connection().ConnectionString); //using (OleDbConnection con = new OleDbConnection(objcon.Connection().ConnectionString)) //{ // using (OleDbCommand cmd = new OleDbCommand(query)) // { // using (OleDbDataAdapter sda = new OleDbDataAdapter()) // { // cmd.CommandType = CommandType.Text; // cmd.Connection = con; // sda.SelectCommand = cmd; // sda.Fill(dt); // } // } // return dt; //} //string query = "Exec Jct_Payroll_Portal_Proc1 '9000000537',9999"; //' string constr = ConfigurationManager.ConnectionStrings("constr").ConnectionString; using (SqlConnection con = new SqlConnection(objcon.Connection().ConnectionString)) { DataTable dt = new DataTable(); using (SqlCommand cmd = new SqlCommand(query)) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.CommandType = CommandType.Text; cmd.Connection = con; sda.SelectCommand = cmd; sda.Fill(dt); } } return(dt); con.Close(); } objcon.ConClose(); }
public string pathfind() { SqlCommand cmd = new SqlCommand("Jct_Payroll_Custom_Path_Find", obj.Connection()); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr; dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows == true) { MyPathFound = dr[0].ToString(); } else { string script = "alert('No Record Found !! ');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); } dr.Close(); return(MyPathFound); }
protected void lnksave_Click(object sender, EventArgs e) { try { string sql = "JCT_Payroll_Employee_Search"; SqlCommand cmd = new SqlCommand(sql, obj.Connection()); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 0; cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 10).Value = txtEmployee.Text; cmd.ExecuteNonQuery(); SqlDataAdapter Da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); Da.Fill(ds); grdDetail.DataSource = ds.Tables[0]; grdDetail.DataBind(); if (ds.Tables[0].Rows.Count > 1) { Panel1.Visible = true; } grdDetail.UseAccessibleHeader = true; grdDetail.HeaderRow.TableSection = TableRowSection.TableHeader; // grdDetail.HeaderRow.CssClass = "gridh1"; grdDetail.FooterRow.TableSection = TableRowSection.TableFooter; TableCellCollection cells = grdDetail.HeaderRow.Cells; cells[0].Attributes.Add("data-class", "expand"); cells[1].Attributes.Add("data-hide", "phone,tablet"); cells[5].Attributes.Add("data-hide", "phone,tablet"); cells[6].Attributes.Add("data-hide", "phone,tablet"); cells[7].Attributes.Add("data-hide", "phone,tablet"); cells[8].Attributes.Add("data-hide", "phone,tablet"); cells[9].Attributes.Add("data-hide", "phone,tablet"); //cells[4].Attributes.Add("data-hide", "phone,tablet"); if (ds.Tables[0].Rows.Count == 0) { string script = "alert('No Record Found');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); return; } } catch (Exception ex) { string script2 = "alert('" + ex.Message + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script2, true); return; } finally { obj.ConClose(); } }
//private void BindMenu() //{ // Dt_EmpData = GetData("Jct_Payroll_Emp_MonthlyCalender '" + Session["EmpCode"] + "','01','2018'"); // DataView view = new DataView(Dt_EmpData); // this.dlstEmp.DataSource = view; // this.dlstEmp.DataBind(); //} //private DataTable GetData(string query) //{ // SqlConnection con = new SqlConnection(Obj.Connection().ConnectionString); // DataTable dt = new DataTable(); // SqlCommand cmd = new SqlCommand(query); // SqlDataAdapter sda = new SqlDataAdapter(); // cmd.CommandType = CommandType.Text; // cmd.Connection = con; // sda.SelectCommand = cmd; // sda.Fill(dt); // con.Close(); // return dt; //} private Hashtable Getholiday() { Hashtable holiday = new Hashtable(); SqlCommand cmd = new SqlCommand("exec Jct_Payroll_Holiday_List_ashish '" + Session["Empcode"].ToString() + "'", Obj.Connection()); SqlDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { holiday[dr["Date"]] = dr["Ocassion"].ToString(); } dr.Close(); return(holiday); }