public void UpdatePasscode(PasscodeDTO data)
{
SqlParameter[] sqlParams = new SqlParameter[2];
sqlParams[0] = new SqlParameter("RecipientEmail", data.RecipientEmail);
sqlParams[1] = new SqlParameter("IsSignedUp", data.IsSignedUp);
object objResult = SqlClientRMXProd.ExecuteScalar("udsp_UpdatePasscodeInfo", sqlParams);
}
public int InsertPasscode(PasscodeDTO data)
{
int passCodeId = 0;
// string passcode = System.Web.Security.Membership.GeneratePassword(6, 2);
SqlParameter[] sqlParams = new SqlParameter[4];
sqlParams[0] = new SqlParameter("SenderID", data.SenderID);
sqlParams[1] = new SqlParameter("RecipientEmail", data.RecipientEmail);
sqlParams[2] = new SqlParameter("PassCode", data.PassCode);
sqlParams[3] = new SqlParameter("IsSignedUp", data.IsSignedUp);
object objResult = SqlClientRMXProd.ExecuteScalar("udsp_InsertPasscodeInfo", sqlParams);
if ((objResult != null) && (Int32.TryParse(objResult.ToString(), out passCodeId)))
{
return(passCodeId);
}
return(passCodeId);
}
public int UserRegistration(BusinessDTO.User userData)
{
int userId = 0;
SqlParameter[] sqlParams = new SqlParameter[22];
sqlParams[0] = new SqlParameter("UniqueID", userData.UniqueID);
sqlParams[1] = new SqlParameter("RoleId", userData.RoleId); //
sqlParams[2] = new SqlParameter("Password", userData.Password); //
sqlParams[3] = new SqlParameter("IsActive", userData.IsActive); //
sqlParams[4] = new SqlParameter("FirstName", userData.FirstName); //
sqlParams[5] = new SqlParameter("HomeAddress", userData.HomeAddress); //
sqlParams[6] = new SqlParameter("WMTechID", userData.WMTechID); //
sqlParams[7] = new SqlParameter("ClockedIn", userData.ClockedIn); //
sqlParams[8] = new SqlParameter("Company", userData.Company); //
sqlParams[9] = new SqlParameter("Department", userData.Department); //
sqlParams[10] = new SqlParameter("LaborRateCost", userData.LaborRateCost); //
sqlParams[11] = new SqlParameter("LaborRateSell", userData.LaborRateSell); //
sqlParams[12] = new SqlParameter("LastName", userData.LastName); //
sqlParams[13] = new SqlParameter("CurrentLocation", userData.CurrentLocation); //
sqlParams[14] = new SqlParameter("PayRate", userData.PayRate); //
sqlParams[15] = new SqlParameter("PhoneNumber", userData.PhoneNumber); //
sqlParams[16] = new SqlParameter("ProfilePicture", userData.ProfilePicture); //
sqlParams[17] = new SqlParameter("TimeSheets", userData.TimeSheets); //
sqlParams[18] = new SqlParameter("Title", userData.Title); //
sqlParams[19] = new SqlParameter("Truck", userData.Truck); //
sqlParams[20] = new SqlParameter("Type", userData.Type); //
// sqlParams[21] = new SqlParameter("CreationDate", userData.CreationDate);
//sqlParams[22] = new SqlParameter("UniqueID", userData.UniqueID);
sqlParams[21] = new SqlParameter("Email", userData.Email);
object objResult = SqlClientRMXProd.ExecuteScalar("udsp_User_Insert", sqlParams);
if ((objResult != null) && (Int32.TryParse(objResult.ToString(), out userId)))
{
return(userId);
}
return(userId);
}
public int InsertWorkOrder(WorkOrderDTO data)
{
int workOrderId = 0;
SqlParameter[] sqlParams = new SqlParameter[11];
sqlParams[0] = new SqlParameter("CompletedDate", data.CompletedDate);
sqlParams[1] = new SqlParameter("ContractorID", data.ContractorID);
sqlParams[2] = new SqlParameter("DeadLineDate", data.DeadLineDate);
sqlParams[3] = new SqlParameter("DepartmentID", data.DepartmentID);
sqlParams[4] = new SqlParameter("DispatchedDate", data.DispatchedDate);
sqlParams[5] = new SqlParameter("DispatchTo", data.DispatchTo);
sqlParams[6] = new SqlParameter("PriorityID", data.PriorityID);
sqlParams[7] = new SqlParameter("ProblemDescription", data.ProblemDescription);
sqlParams[8] = new SqlParameter("ReceivedDate", data.ReceivedDate);
sqlParams[9] = new SqlParameter("SiteID", data.SiteID);
sqlParams[10] = new SqlParameter("WorkOrderStatus", ActivityStatusEnum.Unscheduled);
object objResult = SqlClientRMXProd.ExecuteScalar("udsp_InsertWorkOrder", sqlParams);
if ((objResult != null) && (Int32.TryParse(objResult.ToString(), out workOrderId)))
{
return(workOrderId);
}
return(workOrderId);
}
