public static void UpdateTaskRank(string data, int?status) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.ClearParameters(); qb.SetInParam("@data", data, SqlDbType.NVarChar); qb.SetInParam("@status", status, SqlDbType.Int); qb.ExecuteScalar("spUpdateTaskRank", CommandType.StoredProcedure); }
public static long InsertTaxSavingType(TaxSavingTypeModel taxSavingType) { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.ClearParameters(); qb.SetInParam("@TaxSavingTypeName", taxSavingType.TaxSavingTypeName, SqlDbType.NVarChar); qb.SetInParam("@TaxCategoryCode", taxSavingType.TaxCategoryCode, SqlDbType.NVarChar); result = qb.ExecuteNonQuery("spInsertTaxSavingType", CommandType.StoredProcedure); return(result); }
public static long DeleteHoliday(DateTime holidaydate) { try { long result; BuildQuery bq = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); bq.ClearParameters(); bq.SetInParam("@HolidayDate", holidaydate, SqlDbType.DateTime); result = bq.ExecuteNonQuery("spDeleteHoliday"); return(result); } catch (Exception ex) { throw ex; } }
public static long UpdateHoliday(HolidayModel holiday) { try { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.ClearParameters(); qb.SetInParam("@HolidayDate", holiday.HolidayDate, SqlDbType.DateTime); qb.SetInParam("@Name", holiday.Name, SqlDbType.NVarChar); qb.SetInParam("@Remarks", holiday.Remark, SqlDbType.NVarChar); result = qb.ExecuteNonQuery("spUpdateHoliday", CommandType.StoredProcedure); return(result); } catch (Exception ex) { throw ex; } }
public static void CreateEmployee(Employee employeeDetails) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.ClearParameters(); qb.SetInParam("@FirstName ", employeeDetails.FirstName, SqlDbType.NVarChar); qb.SetInParam("@MiddleName", employeeDetails.MiddleName, SqlDbType.NVarChar); qb.SetInParam("@LastName", employeeDetails.LastName, SqlDbType.NVarChar); qb.SetInParam("@Designation", employeeDetails.Designation, SqlDbType.NVarChar); qb.SetInParam("@Gender", employeeDetails.Gender, SqlDbType.NVarChar); qb.SetInParam("@DateOfBirth", employeeDetails.DateOfBirth, SqlDbType.DateTime); qb.SetInParam("@Anniversary", "1901-01-01", SqlDbType.DateTime); qb.SetInParam("@Remarks", employeeDetails.Remarks, SqlDbType.NVarChar); qb.SetInParam("@DateOfJoining", employeeDetails.DateOfJoining, SqlDbType.DateTime); qb.SetInParam("@DateOfRelieving", employeeDetails.DateOfRelieving, SqlDbType.DateTime); qb.SetInParam("@PanNo", employeeDetails.PanNo, SqlDbType.NVarChar); qb.SetInParam("@FatherName", employeeDetails.FatherName, SqlDbType.NVarChar); qb.SetInParam("@EmployeeType", employeeDetails.EmployeeType, SqlDbType.NVarChar); qb.SetInParam("@BankDetail", employeeDetails.BankDetail, SqlDbType.NVarChar); qb.SetInParam("@OrignalDateOfBirth", employeeDetails.OrignalDateOfBirth, SqlDbType.DateTime); qb.ExecuteScalar("spInsertEmployee", CommandType.StoredProcedure); }