| public Connection ( ConnectionPool pool, string connectionString ) | ||
| pool | ConnectionPool | |
| connectionString | string | |
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);
}
