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);
}
