public static bool isvaliddata(string vquery)
{
try
{
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = vquery;
dr = cmd.ExecuteReader();
if (dr.Read())
{
return(true);
}
else
{
return(false);
}
con.Close();
}
catch (Exception ex)
{
return(false);
}
}
public static int isPTPayrollRunExist(string vquery)
{
int lid = 0;
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = vquery;
SqlDataReader reader = default(SqlDataReader);
reader = cmd.ExecuteReader();
while (reader.Read())
{
lid = int.Parse(reader[0].ToString());
//lid = lid + 1;
}
reader.Close();
if ((lid <= 0))
{
con.Close();
cmd.Dispose();
return(lid);
}
con.Close();
cmd.Dispose();
return(lid);
}
public static void UpdSaveElements(string viPersonId, string viEndDateString, int viElementId, Decimal viValue1, string viRemarks, int vEMPID)
{
try
{
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INS_HR_SalModify";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@iPersonId", SqlDbType.VarChar, 20));
cmd.Parameters["@iPersonId"].Value = viPersonId;
cmd.Parameters.Add(new SqlParameter("@iElementId", SqlDbType.Int));
cmd.Parameters["@iElementId"].Value = viElementId;
cmd.Parameters.Add(new SqlParameter("@iEndDateString", SqlDbType.VarChar, 50));
cmd.Parameters["@iEndDateString"].Value = viEndDateString;
cmd.Parameters.Add(new SqlParameter("@iValue1", SqlDbType.Float));
cmd.Parameters["@iValue1"].Value = viValue1;
cmd.Parameters.Add(new SqlParameter("@iRemarks", SqlDbType.VarChar, 200));
cmd.Parameters["@iRemarks"].Value = viRemarks;
cmd.Parameters.Add(new SqlParameter("@iCreatedById", SqlDbType.Int));
cmd.Parameters["@iCreatedById"].Value = vEMPID;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
}
}
public static void SaveTempElementsContract(string viPersonId, string viElementId, string viStartDateString, Decimal viValue1, string viRemarks, string viCreatedById, string viVoucher, int viContract)
{
try
{
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INS_HR_PersonElements_TempContract";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@iPersonId", SqlDbType.VarChar, 20));
cmd.Parameters["@iPersonId"].Value = viPersonId;
cmd.Parameters.Add(new SqlParameter("@iElementId", SqlDbType.Int));
cmd.Parameters["@iElementId"].Value = viElementId;
cmd.Parameters.Add(new SqlParameter("@iDate", SqlDbType.DateTime));
cmd.Parameters["@iDate"].Value = viStartDateString;
cmd.Parameters.Add(new SqlParameter("@iValue1", SqlDbType.Float));
cmd.Parameters["@iValue1"].Value = viValue1;
cmd.Parameters.Add(new SqlParameter("@iRemarks", SqlDbType.VarChar, 200));
cmd.Parameters["@iRemarks"].Value = viRemarks;
cmd.Parameters.Add(new SqlParameter("@iCreatedById", SqlDbType.VarChar, 20));
cmd.Parameters["@iCreatedById"].Value = viCreatedById;
cmd.Parameters.Add(new SqlParameter("@iVoucher", SqlDbType.VarChar, 20));
cmd.Parameters["@iVoucher"].Value = viVoucher;
cmd.Parameters.Add(new SqlParameter("@iContract", SqlDbType.Int));
cmd.Parameters["@iContract"].Value = viContract;
con.Open();
cmd.ExecuteNonQuery();
// MessageBox.Show("Record Saved", "SAVE", MessageBoxButtons.OK, MessageBoxIcon.Information)
con.Close();
}
catch (Exception ex)
{
}
}
public static DataTable fillACSDBdata(string vqry)
{
SqlDataAdapter da = new SqlDataAdapter(vqry, CGLOBAL.getNewConnectionString());
DataTable dt = new DataTable();
da.Fill(dt);
da = null;
return(dt);
}
public static DataTable filldataattendance(string vqry)
{
SqlDataAdapter da = new SqlDataAdapter(vqry, CGLOBAL.getConnectionStringattendance());
DataTable dt = new DataTable();
da.Fill(dt);
da = null;
return(dt);
}
public string InsertJobdescriptionmaster(int JobID, string Jobtitle, string Reporting_To, string Leave_Guidelines, string Leave_Replace, string Educational_Req, string Know_Skills, string Key_Areas
, string strategic_res, string operation_res, string Yearly_planning, string Reporting_Res,
string Coord_Res, string calendar_checklist, string presentation, string orientation, string training, string audit
, string policy_manual, string handbook, string created_by, string created_Ip)
{
try
{
// SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SkyLineConnection"].ToString());
SqlConnection conn = new SqlConnection(CGLOBAL.getConnectionString());
conn.Open();
SqlCommand cmd = new SqlCommand("[SP_INSERT_JOBDESC]", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@JOB_ID", JobID);
cmd.Parameters.AddWithValue("@JOB_TITLE", Jobtitle);
cmd.Parameters.AddWithValue("@Reporting_to", Reporting_To);
cmd.Parameters.AddWithValue("@Leave_Guidelines", Leave_Guidelines);
cmd.Parameters.AddWithValue("@Leave_Replacement", Leave_Replace);
cmd.Parameters.AddWithValue("@Educational_req", Educational_Req);
cmd.Parameters.AddWithValue("@Know_Skills", Know_Skills);
cmd.Parameters.AddWithValue("@Key_areas", Key_Areas);
cmd.Parameters.AddWithValue("@Strategic_res", strategic_res);
cmd.Parameters.AddWithValue("@Operation_res", operation_res);
cmd.Parameters.AddWithValue("@Yearly_planning", Yearly_planning);
cmd.Parameters.AddWithValue("@Reporting_res", Reporting_Res);
cmd.Parameters.AddWithValue("@CoOrd_Res", Coord_Res);
cmd.Parameters.AddWithValue("@Calendar_Checklist", calendar_checklist);
cmd.Parameters.AddWithValue("@Presentation", presentation);
cmd.Parameters.AddWithValue("@Orientation", orientation);
cmd.Parameters.AddWithValue("@Training", training);
cmd.Parameters.AddWithValue("@Audit", audit);
cmd.Parameters.AddWithValue("@Policy_Manual", policy_manual);
cmd.Parameters.AddWithValue("@handbook", handbook);
cmd.Parameters.AddWithValue("@CreatedBy", created_by);
cmd.Parameters.AddWithValue("@createdIP", created_Ip);
using (conn)
cmd.ExecuteNonQuery();
conn.Close();
return("RegisterNo");
}
catch
{
return("error");
}
}
public static bool save(string vquery)
{
try
{
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = vquery.ToUpper();
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public static bool saveolderp(string vquery, int @personid)
{
try
{
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = vquery;
cmd.Parameters.Add("@personid", SqlDbType.Int).Value = @personid;
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public static void DeleteTempElements(string viVoucher)
{
try
{
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "DEL_HR_PersonElements_Temp";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@iVoucher", SqlDbType.VarChar, 20));
cmd.Parameters["@iVoucher"].Value = viVoucher;
con.Open();
cmd.ExecuteNonQuery();
// MessageBox.Show("Record Saved", "SAVE", MessageBoxButtons.OK, MessageBoxIcon.Information)
con.Close();
}
catch (Exception ex)
{
}
}
public static DataTable ReportingDepartment()
{
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
try
{
//cmd = new SqlCommand("sp_DailyPresent", con);
cmd = new SqlCommand("SP_REPORTINGTO", con);
cmd.CommandType = CommandType.StoredProcedure;
da.SelectCommand = cmd;
da.Fill(dt);
return(dt);
}
catch (Exception ex)
{
return(null);
}
}
public static DataTable FillDesignation()
{
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
try
{
//cmd = new SqlCommand("sp_DailyPresent", con);
cmd = new SqlCommand("SP_GETDESIGNATION", con);
cmd.CommandType = CommandType.StoredProcedure;
da.SelectCommand = cmd;
da.Fill(dt);
return(dt);
}
catch (Exception ex)
{
return(null);
}
}
public static DataTable Load_JobDesc_Details(int Jobdesc_ID)
{
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
try
{
//cmd = new SqlCommand("sp_DailyPresent", con);
cmd = new SqlCommand("SP_LOAD_JOBDESC_DETAILS", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@JOBDESC_ID", Jobdesc_ID);
da.SelectCommand = cmd;
da.Fill(dt);
return(dt);
}
catch (Exception ex)
{
return(null);
}
}
public static string GetString(string vquery)
{
string Value = "";
SqlConnection con = new SqlConnection(CGLOBAL.getConnectionString());
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = vquery;
SqlDataReader reader = default(SqlDataReader);
reader = cmd.ExecuteReader();
while (reader.Read())
{
Value = reader[0].ToString();
//lid = lid + 1;
}
reader.Close();
con.Close();
cmd.Dispose();
return(Value);
}
