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 filldata(string vqry) { SqlDataAdapter da = new SqlDataAdapter(vqry, CGLOBAL.getConnectionString()); 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); }