public static string GetNextBuildNumber(Guid?componentId) { string result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@ComponentId", componentId, SqlDbType.UniqueIdentifier); result = Convert.ToString(qb.ExecuteScalar("spGetNextBuildNumber")); return(result); }
public static string GetUserId(string employeeId) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@EmployeeId", Guid.Parse(employeeId), SqlDbType.UniqueIdentifier); string id = qb.ExecuteScalar("spGetUserId", CommandType.StoredProcedure).ToString(); return(id); }
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 string InsertTaskFromEmail(string from, string to, string cc, string subject, string body) { string retTaskId = string.Empty; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@From", from, SqlDbType.NVarChar); qb.SetInParam("@To", to, SqlDbType.NVarChar); qb.SetInParam("@Cc", cc, SqlDbType.NVarChar); qb.SetInParam("@Subject", subject, SqlDbType.NVarChar); qb.SetInParam("@Body", body, SqlDbType.NVarChar); retTaskId = Convert.ToString(qb.ExecuteScalar("spInsertTaskFromEmail")); return(retTaskId); }
public static void BulkUpdateTask(string taskIds, int operationType, string param1, string param2, string loginUserId) { BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.SetInParam("@TaskIds", taskIds, SqlDbType.VarChar); qb.SetInParam("@OperationType", operationType, SqlDbType.Int); if (!string.IsNullOrEmpty(param1)) { qb.SetInParam("@Param1", param1.Trim(), SqlDbType.NVarChar); } if (!string.IsNullOrEmpty(param2)) { qb.SetInParam("@Param2", param2.Trim(), SqlDbType.NVarChar); } qb.SetInParam("@ModifiedBy", new Guid(loginUserId), SqlDbType.UniqueIdentifier); qb.ExecuteScalar("spUpdateTaskBulk", CommandType.StoredProcedure); }
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); }