/// <summary>
/// Change password method which will interact with database and change the password
/// </summary>
/// <param name="changePassword">You need to pass ChangePassword type object to process the request</param>
/// <returns></returns>
public MDTTransactionInfo ChangePassword(ChangePassword changePassword)
{
MDTTransactionInfo mdt = null;
try
{
List <SqlParameter> prm = new List <SqlParameter>();
//SqlParameter email = new SqlParameter("@email", changePassword.Email);
//prm.Add(email);
//SqlParameter oldPwd = new SqlParameter("@oldPwd", changePassword.OldPassword);
//prm.Add(oldPwd);
//SqlParameter NewPwd = new SqlParameter("@newPwd", changePassword.NewPassword);
//prm.Add(NewPwd);
//SqlParameter status = new SqlParameter("@Status", 0);
//status.Direction = ParameterDirection.Output;
//prm.Add(status);
prm = DatabaseSettings.BindParamers(APIHelper.updatePasswordParameters, changePassword.Email + "~||~" + changePassword.OldPassword + "~||~" + changePassword.NewPassword);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.updatePassword, out StatusValue, prm);
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
}
return(mdt);
}
private IEnumerable <SystemVariants> GetSystemVariants(int VariantID)
{
IEnumerable <SystemVariants> systemVariants = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter System_Variant_ID = new SqlParameter("@System_Variant_ID", VariantID);
prm.Add(System_Variant_ID);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
DataTable dt = DatabaseSettings.GetDataSet("sp_GetSystemVariants", out StatusValue, prm).Tables[0];
if (StatusValue == 1)
{
if (dt.Rows.Count > 0)
{
systemVariants = from d in dt.AsEnumerable()
select new SystemVariants
{
SYSTEM_ID = d.Field <int>("SYSTEM_ID"),
SYSTEM_VARIANT_ID = d.Field <int>("SYSTEM_VARIANT_ID"),
SYSTEM_IMAGE = d.Field <string>("SYSTEM_IMAGE"),
SYSTEM_NAME = d.Field <string>("SYSTEM_NAME"),
EQUIPMENT_COST = d.Field <double>("EQUIPMENT_COST"),
ELECTRICAL_COST = d.Field <double>("ELECTRICAL_COST"),
MECHANICAL_COST = d.Field <double>("MECHANICAL_COST"),
COMMENTS = d.Field <string>("COMMENTS"),
REMARKS = d.Field <string>("REMARKS")
};
}
}
return(systemVariants);
}
/// <summary>
/// It will check if login user is valid user or not
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public bool IsValid(string userName, string password)
{
List <SqlParameter> prm = new List <SqlParameter>();
//SqlParameter userid = new SqlParameter("@username", userName);
//prm.Add(userid);
//SqlParameter filepath = new SqlParameter("@password", password);
//prm.Add(filepath);
//SqlParameter status = new SqlParameter("@Status", 0);
//status.Direction = ParameterDirection.Output;
//prm.Add(status);
prm = DatabaseSettings.BindParamers(APIHelper.checkLoginParameters, userName + "~||~" + password);
int statusValue = 0;
bool IsVaild = false;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.checkLogin, out statusValue, prm);
if (statusValue == 1)
{
IsVaild = true;
}
else if (statusValue == 0)
{
IsVaild = false;
}
return(IsVaild);
}
/// <summary>
/// It will check if login user is valid user or not
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public bool IsValid(string username, string password)
{
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter userid = new SqlParameter("@username", username);
prm.Add(userid);
SqlParameter filepath = new SqlParameter("@password", password);
prm.Add(filepath);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
bool IsVaild = false;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.CheckLogin, out StatusValue, prm);
if (StatusValue == 1)
{
IsVaild = true;
}
else if (StatusValue == 0)
{
IsVaild = false;
}
//else if (StatusValue == 6)
//{
// //ErrorInfoFromSQL eInfo = DatabaseSettings.GetError(dt);
// //mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
// IsVaild = false;
//}
return(IsVaild);
}
/// <summary>
/// It will return equipment variants with their cost history based on Variant ID
/// </summary>
/// <param name="VariantID">Pass the variant ID for associated equipment</param>
/// <returns></returns>
public MDTTransactionInfo GetEquipmentVariants(int packageID, int systemID, int configurationID, int variantID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
try
{
IEnumerable <EquipmentVariants> equipmentVariants = null;
List <SqlParameter> prm = new List <SqlParameter>();
prm = DatabaseSettings.BindParamers(APIHelper.getEquipmentVariantsParameters, packageID.ToString() + "~||~" + systemID.ToString() + "~||~" + configurationID.ToString() + "~||~" + variantID.ToString());
int statusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getEquipmentVariants, out statusValue, prm);
DataTable dt;
if (statusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
equipmentVariants = from d in dt.AsEnumerable()
select new EquipmentVariants
{
SELECT = Convert.ToBoolean(d.Field <int>("SELECT")),
PACKAGE_ID = d.Field <int>("PACKAGE_ID"),
SYSTEM_ID = d.Field <int>("SYSTEM_ID"),
EQUIPMENT_ID = d.Field <int>("EQUIPMENT_ID"),
SUPPLIER_ID = d.Field <int>("SUPPLIER_ID"),
CONFIGURATION_ID = d.Field <int>("CONFIGURATION_ID"),
UPDT_USER_ID = d.Field <int>("UPDT_USER_ID"),
IS_MANDATORY = d.Field <bool>("IS_MANDATORY"),
EQUIPMENT_NAME = d.Field <string>("EQUIPMENT_NAME"),
SUPPLIER_NAME = d.Field <string>("SUPPLIER_NAME"),
EQUIPMENT_COST = d.Field <double>("EQUIPMENT_COST"),
EQPMNT_VARIANT_ID = d.Field <int>("EQPMNT_VARIANT_ID"),
COMMENTS = d.Field <string>("COMMENTS"),
EQUIPMENT_DESC = d.Field <string>("EQUIPMENT_DESC"),
EQUIPMENT_TYPE = d.Field <string>("EQUIPMENT_TYPE"),
Documents = GetEquipmentDocuments(d.Field <int>("EQUIPMENT_ID")).transactionObject as IEnumerable <EquipmentDocuments>,
SAPLinks = GetEquipmentSAPLinks(d.Field <int>("EQUIPMENT_ID")).transactionObject as IEnumerable <EquipmentSAPLink>,
Suppliers = Suppliers = GetSuppliers(d.Field <int>("SYSTEM_ID"), d.Field <int>("EQUIPMENT_ID"), d.Field <int>("CONFIGURATION_ID"), d.Field <string>("EQUIPMENT_TYPE")) //(d.Field<int>("SUPPLIER_ID")!=0)?Suppliers:null
};
mdt = DatabaseSettings.GetTransObject(equipmentVariants, statusValue, "System equipment variants fetched successfully", ds);
}
else
{
mdt.msgCode = MessageCode.Failed;
mdt.status = HttpStatusCode.NoContent;
mdt.message = "No record found";
}
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
// Need to log error in logger from ex
}
return(mdt);
}
/// <summary>
/// It will auto generate new random password and send to user on his email.
/// </summary>
/// <param name="forgotPassword"></param>
/// <returns></returns>
public MDTTransactionInfo ForgotPassword(ForgotPassword forgotPassword)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
ErrorInfoFromSQL eInfo = null;
try
{
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter email = new SqlParameter("@email", forgotPassword.Email);
prm.Add(email);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.forgotPassword, out StatusValue, prm);
DataTable dt = ds.Tables[0];
if (StatusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
SendMailRequest sendMailRequest = new SendMailRequest();
sendMailRequest.recipient = dt.Rows[0]["Email"].ToString();
sendMailRequest.subject = "MDT Password Reset";
sendMailRequest.body = "Dear User," + Environment.NewLine + "Your password has been reset successfully. please login with new password given below " + Environment.NewLine + "New Password : "******"New Password"].ToString();
IMessager messager = new Email();
var Notification = new Notification(messager);
if (Notification.DoNotify(sendMailRequest))
{
mdt.status = HttpStatusCode.OK;
mdt.msgCode = MessageCode.Success;
mdt.message = "Password has been reset and sent to your registered email.";
}
else
{
mdt.status = HttpStatusCode.BadGateway;
mdt.msgCode = MessageCode.Failed;
mdt.message = "Password has been reset but unable to send an email due some technical issue, please contact to administrator";
}
}
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
}
return(mdt);
}
/// <summary>
/// This is login method and it will connect to DB and check if user is exists or not. If user exists then it will display the user detail
/// </summary>
/// <param name="userLogin"></param>
/// <returns></returns>
public MDTTransactionInfo Login(UserLogin userLogin)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
UserLoginDetails loginDetails = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter email = new SqlParameter("@email", userLogin.UserName);
prm.Add(email);
SqlParameter pwd = new SqlParameter("@pwd", userLogin.Password);
prm.Add(pwd);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
DataTable dt = DatabaseSettings.GetDataSet("sp_LoginUser", out APIHelper.StatusValue, prm).Tables[0];
if (APIHelper.StatusValue == 1)
{
if (dt.Rows.Count > 0)
{
loginDetails = new UserLoginDetails();
loginDetails.USER_ID = Convert.ToInt32(dt.Rows[0]["USER_ID"]);
loginDetails.FIRST_NAME = dt.Rows[0]["FIRST_NAME"].ToString();
loginDetails.LAST_NAME = dt.Rows[0]["LAST_NAME"].ToString();
loginDetails.EMAIL_ADDRESS = dt.Rows[0]["EMAIL_ADDRESS"].ToString();
loginDetails.FORCE_PWD_CHNG = Convert.ToBoolean(dt.Rows[0]["FORCE_PWD_CHNG"]);
loginDetails.PHOTO = dt.Rows[0]["PHOTO"].ToString();
loginDetails.ROLE_NAME = dt.Rows[0]["ROLE_NAME"].ToString();
loginDetails.ROLE_ID = Convert.ToInt32(dt.Rows[0]["ROLE_ID"]);
}
mdt.status = HttpStatusCode.OK;
mdt.transactionObject = loginDetails;
mdt.msgCode = MessageCode.Success;
mdt.message = "Login Successfully";
}
else if (APIHelper.StatusValue == 5)
{
ErrorInfoFromSQL eInfo = null;
if (dt.Rows.Count > 0)
{
eInfo = new ErrorInfoFromSQL();
eInfo = DatabaseSettings.GetError(dt);
mdt.status = HttpStatusCode.BadRequest;
mdt.transactionObject = eInfo;
mdt.msgCode = (eInfo.Status == 1) ? MessageCode.Success : MessageCode.Failed;
mdt.message = eInfo.ErrorMessage;
mdt.LineNumber = eInfo.ErrorLineNo;
mdt.ProcedureName = eInfo.Procedure;
}
}
return(mdt);
}
private MDTTransactionInfo GetBasicInputOptions(int basicInputID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
try
{
IEnumerable <BasicInputOptions> basicInputOptions = null;
List <SqlParameter> prm = new List <SqlParameter>();
//SqlParameter Basic_Input_ID = new SqlParameter("@BASIC_INPUT_ID", basicInputID);
//prm.Add(Basic_Input_ID);
//SqlParameter status = new SqlParameter("@Status", 0);
//status.Direction = ParameterDirection.Output;
//prm.Add(status);
prm = DatabaseSettings.BindParamers(APIHelper.getBasicInputDetailsParameters, basicInputID.ToString());
int statusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet("sp_GetBasicInputDetails", out statusValue, prm);
DataTable dt;
if (statusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
basicInputOptions = from d in dt.AsEnumerable()
select new BasicInputOptions
{
BASIC_INPUT_OPTN_ID = d.Field <int>("BASIC_INPUT_OPTN_ID"),
INPUT_OPT_NAME = d.Field <string>("INPUT_OPT_NAME"),
BASIC_INPUT_ID = d.Field <int>("BASIC_INPUT_ID"),
//CONFIGURATION_ID = d.Field<int>("CONFIGURATION_ID"),
//CONFIG_INPUT_OPT_ID = d.Field<int>("CONFIG_INPUT_OPT_ID"),
//UPDT_USER_ID = d.Field<int>("UPDT_USER_ID")
};
}
mdt.msgCode = MessageCode.Success;
mdt.status = HttpStatusCode.OK;
mdt.message = "Record found";
mdt.transactionObject = basicInputOptions;
}
else if (statusValue == 5 || statusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, statusValue, "", ds);
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
}
return(mdt);
}
/// <summary>
/// It will auto generate new random password and send to user on his email.
/// </summary>
/// <param name="forgotPassword"></param>
/// <returns></returns>
public MDTTransactionInfo ForgotPassword(ForgotPassword forgotPassword)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter email = new SqlParameter("@email", forgotPassword.Email);
prm.Add(email);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet("sp_UpdatePassword", out StatusValue, prm);
DataTable dt = ds.Tables[0];
ErrorInfoFromSQL eInfo = null;
if (StatusValue == 1)
{
mdt.status = HttpStatusCode.OK;
}
else if (StatusValue == 5)
{
mdt.status = HttpStatusCode.BadRequest;
}
if (dt.Rows.Count == 1)
{
eInfo = DatabaseSettings.GetError(dt);
mdt.transactionObject = eInfo;
mdt.msgCode = (eInfo.Status == 1) ? MessageCode.Success : MessageCode.Failed;
mdt.message = eInfo.ErrorMessage;
mdt.LineNumber = eInfo.ErrorLineNo;
mdt.ProcedureName = eInfo.Procedure;
}
// If above call success then sending an email to user with latest password.
if (eInfo.Status == 1)
{
dt = ds.Tables[1];
if (dt.Rows.Count > 0)
{
SendMailRequest sendMailRequest = new SendMailRequest();
sendMailRequest.recipient = dt.Rows[0]["Email"].ToString();
sendMailRequest.subject = "MDT Password Reset";
sendMailRequest.body = "Dear User," + Environment.NewLine + "Your password has been reset successfully. please login with new password given below " + Environment.NewLine + "New Password : "******"New Password"].ToString();
IMessager messager = new Email();
var Notification = new Notification(messager);
mdt.message = Notification.DoNotify(sendMailRequest);
}
}
return(mdt);
}
/// <summary>
/// It will return the Sub System details in landing page for sales based on Package ID
/// </summary>
/// <param name="PackageID"></param>
/// <returns></returns>
public MDTTransactionInfo GetPackageSystemDetails(int PackageID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
IEnumerable <PackageSystem> PackageSystems = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter package_Id = new SqlParameter("@PackageID", PackageID);
prm.Add(package_Id);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getPackageSystemDetails, out StatusValue, prm);
DataTable dt;
if (StatusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
PackageSystems = from d in dt.AsEnumerable()
select new PackageSystem
{
PACKAGE_ID = d.Field <int>("PACKAGE_ID"),
SYSTEM_ID = d.Field <int>("SYSTEM_ID"),
SYSTEM_VARIANT_ID = d.Field <int>("SYSTEM_VARIANT_ID"),
DEPENDENT_ID = d.Field <int>("DEPENDENT_ID"),
SELECT = Convert.ToBoolean(d.Field <int>("SELECT")),
TYPE = d.Field <bool>("TYPE"),
COST_TYPE = Convert.ToBoolean(d.Field <int>("COST_TYPE")),
SYSTEM_IMAGE = d.Field <string>("SYSTEM_IMAGE"),
SYSTEM_NAME = d.Field <string>("SYSTEM_NAME"),
EQUIPMENT_COST = d.Field <double>("EQUIPMENT_COST"),
ELECTRICAL_COST = d.Field <double>("ELECTRICAL_COST"),
MECHANICAL_COST = d.Field <double>("MECHANICAL_COST"),
COMMENTS = d.Field <string>("COMMENTS"),
REMARKS = d.Field <string>("REMARKS"),
SystemVariants = GetSystemVariants(d.Field <int>("SYSTEM_VARIANT_ID")).transactionObject as IEnumerable <SystemVariants>
};
}
mdt = DatabaseSettings.GetTransObject(PackageSystems, StatusValue, "Package System Details Fetched Successfully", ds);
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
return(mdt);
}
private MDTTransactionInfo GetSystemVariants(int VariantID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
IEnumerable <SystemVariants> systemVariants = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter System_Variant_ID = new SqlParameter("@System_Variant_ID", VariantID);
prm.Add(System_Variant_ID);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getSystemVariants, out StatusValue, prm);
DataTable dt;
if (StatusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
systemVariants = from d in dt.AsEnumerable()
select new SystemVariants
{
PACKAGE_ID = d.Field <int>("PACKAGE_ID"),
SYSTEM_ID = d.Field <int>("SYSTEM_ID"),
SYSTEM_VARIANT_ID = d.Field <int>("SYSTEM_VARIANT_ID"),
DEPENDENT_ID = d.Field <int>("DEPENDENT_ID"),
SELECT = Convert.ToBoolean(d.Field <int>("SELECT")),
TYPE = d.Field <bool>("TYPE"),
COST_TYPE = Convert.ToBoolean(d.Field <int>("COST_TYPE")),
SYSTEM_IMAGE = d.Field <string>("SYSTEM_IMAGE"),
SYSTEM_NAME = d.Field <string>("SYSTEM_NAME"),
EQUIPMENT_COST = d.Field <double>("EQUIPMENT_COST"),
ELECTRICAL_COST = d.Field <double>("ELECTRICAL_COST"),
MECHANICAL_COST = d.Field <double>("MECHANICAL_COST"),
COMMENTS = d.Field <string>("COMMENTS"),
REMARKS = d.Field <string>("REMARKS")
};
}
mdt.msgCode = MessageCode.Success;
mdt.status = HttpStatusCode.OK;
mdt.message = "Record found";
mdt.transactionObject = systemVariants;
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
return(mdt);
}
/// <summary>
/// This will return the list side menu from Solution to Configuration
/// </summary>
/// <returns></returns>
public MDTTransactionInfo GetSideMenu(int UserID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
try
{
IEnumerable <SolutionList> solutionLists = null;
//List<SqlParameter> prm = new List<SqlParameter>();
//SqlParameter Status = new SqlParameter("@Status", 0);
//Status.Direction = ParameterDirection.Output;
//prm.Add(Status);
List <SqlParameter> prm = DatabaseSettings.BindParamers();
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getSolutions, out StatusValue, prm);
DataTable dt;
if (StatusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
solutionLists = from d in dt.AsEnumerable()
select new SolutionList
{
SOLUTION_ID = d.Field <int>("SOLUTION_ID"),
SOLUTION_NAME = d.Field <string>("SOLUTION_NAME"),
Packages = GetPackageList(d.Field <int>("SOLUTION_ID"), UserID).transactionObject as IEnumerable <PackageList>
};
}
//mdt = DatabaseSettings.GetTransObject(solutionLists, StatusValue, "Record Found", ds);
mdt.msgCode = MessageCode.Success;
mdt.status = HttpStatusCode.OK;
mdt.message = "Record found";
mdt.transactionObject = solutionLists;
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
}
return(mdt);
}
/// <summary>
/// This will return list of Basic input options available in database
/// </summary>
/// <returns></returns>
public MDTTransactionInfo GetBasicInputs()
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
IEnumerable <BasicInput> basicInputs = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getBasicInput, out StatusValue, prm);
DataTable dt;
if (StatusValue == 1)
{
mdt = new MDTTransactionInfo();
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
basicInputs = from d in dt.AsEnumerable()
select new BasicInput
{
BASIC_INPUT_ID = d.Field <int>("BASIC_INPUT_ID"),
BASIC_INPUT_NAME = d.Field <string>("BASIC_INPUT_NAME"),
BasicInputOptions = GetBasicInputOptions(d.Field <int>("BASIC_INPUT_ID")).transactionObject as IEnumerable <BasicInputOptions>
};
}
if (basicInputs != null)
{
mdt.transactionObject = basicInputs;
mdt.status = HttpStatusCode.OK;
mdt.msgCode = MessageCode.Success;
mdt.message = "Fetched basic input detail successfully";
}
else
{
mdt.transactionObject = null;
mdt.status = HttpStatusCode.NotFound;
mdt.msgCode = MessageCode.Failed;
mdt.message = "No record found";
}
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
return(mdt);
}
/// <summary>
/// It will return respective equipment SAP links to navigate SAP
/// </summary>
/// <param name="EquipmentID"></param>
/// <returns></returns>
public MDTTransactionInfo GetEquipmentSAPLinks(int equipmentID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
try
{
IEnumerable <EquipmentSAPLink> equipmentSAPLinks = null;
List <SqlParameter> prm = new List <SqlParameter>();
prm = DatabaseSettings.BindParamers(APIHelper.getEquipmentSAPLinksParameters, equipmentID.ToString());
int statusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getEquipmentSAPLinks, out statusValue, prm);
DataTable dt;
if (statusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
equipmentSAPLinks = from d in dt.AsEnumerable()
select new EquipmentSAPLink
{
SAP_LINK_ID = d.Field <int>("SAP_LINK_ID"),
EQUIPMENT_ID = d.Field <int>("EQUIPMENT_ID"),
NAME = d.Field <string>("NAME"),
DESCRIPTION = d.Field <string>("DESCRIPTION"),
SAP_LINK_URL = d.Field <string>("SAP_LINK_URL"),
};
mdt = DatabaseSettings.GetTransObject(equipmentSAPLinks, statusValue, "System equipment SAP links fetched successfully", ds);
}
else
{
mdt.msgCode = MessageCode.Failed;
mdt.status = HttpStatusCode.NoContent;
mdt.message = "No record found";
}
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
// Need to log error in logger from ex
}
return(mdt);
}
//private List<PackageList> GetPackageList(int SolutionID, int UserID)
//{
// List<PackageList> packageLists = null;
// PackageList packageList = null;
// List<SqlParameter> prm = new List<SqlParameter>();
// SqlParameter Solution_ID = new SqlParameter("@SolutionID", SolutionID);
// prm.Add(Solution_ID);
// SqlParameter Status = new SqlParameter("@Status", 0);
// Status.Direction = ParameterDirection.Output;
// prm.Add(Status);
// int StatusValue = 0;
// DataTable dt = DatabaseSettings.GetDataSet("sp_GetPackageList", out StatusValue, prm).Tables[0];
// if (StatusValue == 1)
// {
// if (dt.Rows.Count > 0)
// {
// packageLists = new List<PackageList>();
// foreach (DataRow row in dt.Rows)
// {
// packageList = new PackageList();
// packageList.PACKAGE_ID = Convert.ToInt32(row["PACKAGE_ID"]);
// packageList.PACKAGE_NAME = row["PACKAGE_NAME"].ToString();
// packageList.SOLUTION_ID = Convert.ToInt32(row["SOLUTION_ID"]);
// if (Convert.ToInt32(row["PACKAGE_ID"]) > 0)
// {
// packageList.Configurations = GetConfigurationList(UserID, Convert.ToInt32(row["PACKAGE_ID"]));
// }
// packageLists.Add(packageList);
// }
// }
// }
// return packageLists;
//}
/// <summary>
/// It return all package list for respective Solution
/// </summary>
/// <param name="SolutionID"></param>
/// <param name="UserID"></param>
/// <returns></returns>
private IEnumerable <PackageList> GetPackageList(int SolutionID, int UserID)
{
IEnumerable <PackageList> packageLists = null;
PackageList packageList = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter Solution_ID = new SqlParameter("@SolutionID", SolutionID);
prm.Add(Solution_ID);
SqlParameter Status = new SqlParameter("@Status", 0);
Status.Direction = ParameterDirection.Output;
prm.Add(Status);
int StatusValue = 0;
DataTable dt = DatabaseSettings.GetDataSet("sp_GetPackageList", out StatusValue, prm).Tables[0];
if (StatusValue == 1)
{
if (dt.Rows.Count > 0)
{
packageLists = from d in dt.AsEnumerable()
select new PackageList
{
PACKAGE_ID = d.Field <int>("PACKAGE_ID"),
PACKAGE_NAME = d.Field <string>("PACKAGE_NAME"),
SOLUTION_ID = d.Field <int>("SOLUTION_ID"),
Configurations = GetConfigurationList(UserID, d.Field <int>("PACKAGE_ID"))
};
}
//packageLists = new List<PackageList>();
//foreach (DataRow row in dt.Rows)
//{
// packageList = new PackageList();
// packageList.PACKAGE_ID = Convert.ToInt32(row["PACKAGE_ID"]);
// packageList.PACKAGE_NAME = row["PACKAGE_NAME"].ToString();
// packageList.SOLUTION_ID = Convert.ToInt32(row["SOLUTION_ID"]);
// if (Convert.ToInt32(row["PACKAGE_ID"]) > 0)
// {
// packageList.Configurations = GetConfigurationList(UserID, Convert.ToInt32(row["PACKAGE_ID"]));
// }
// packageLists.Add(packageList);
//}
}
return(packageLists);
}
/// <summary>
/// It will return Top 3 configurations for respective package and User
/// </summary>
/// <param name="UserID"></param>
/// <param name="PackageID"></param>
/// <returns></returns>
private MDTTransactionInfo GetConfigurationList(int UserID, int PackageID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
IEnumerable <ConfigurationList> configLists = null;
//List<SqlParameter> prm = new List<SqlParameter>();
//SqlParameter userID = new SqlParameter("@UserID", UserID);
//prm.Add(userID);
//SqlParameter packageID = new SqlParameter("@PackageID", PackageID);
//prm.Add(packageID);
//SqlParameter NoofConfiguration = new SqlParameter("@NoofConfiguration", 3);
//prm.Add(NoofConfiguration);
//SqlParameter Status = new SqlParameter("@Status", 0);
//Status.Direction = ParameterDirection.Output;
//prm.Add(Status);
List <SqlParameter> prm = DatabaseSettings.BindParamers(APIHelper.getLatestConfigurationsParameters, UserID.ToString() + "," + PackageID.ToString() + ",3");
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getLatestConfigurations, out StatusValue, prm);
DataTable dt;
if (StatusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
configLists = from d in dt.AsEnumerable()
select new ConfigurationList
{
CONFIGURATION_ID = d.Field <int>("CONFIGURATION_ID"),
CONFIGURATION_NAME = d.Field <string>("CONFIGURATION_NAME"),
PACKAGE_ID = d.Field <int>("PACKAGE_ID")
};
}
mdt.msgCode = MessageCode.Success;
mdt.status = HttpStatusCode.OK;
mdt.message = "Record found";
mdt.transactionObject = configLists;
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
return(mdt);
}
/// <summary>
/// It return all package list for respective Solution
/// </summary>
/// <param name="SolutionID"></param>
/// <param name="UserID"></param>
/// <returns></returns>
private MDTTransactionInfo GetPackageList(int solutionID, int userID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
try
{
IEnumerable <PackageList> packageLists = null;
List <SqlParameter> prm = DatabaseSettings.BindParamers(APIHelper.getPackageListParameters, solutionID.ToString());
int statusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getPackageList, out statusValue, prm);
DataTable dt;
if (statusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
packageLists = from d in dt.AsEnumerable()
select new PackageList
{
PACKAGE_ID = d.Field <int>("PACKAGE_ID"),
PACKAGE_NAME = d.Field <string>("PACKAGE_NAME"),
SOLUTION_ID = d.Field <int>("SOLUTION_ID"),
Configurations = GetConfigurationList(userID, d.Field <int>("PACKAGE_ID")).transactionObject as IEnumerable <ConfigurationList>
};
}
mdt.msgCode = MessageCode.Success;
mdt.status = HttpStatusCode.OK;
mdt.message = "Record found";
mdt.transactionObject = packageLists;
}
else if (statusValue == 5 || statusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, statusValue, "", ds);
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
}
return(mdt);
}
/// <summary>
/// Change password method which will interact with database and change the password
/// </summary>
/// <param name="changePassword">You need to pass ChangePassword type object to process the request</param>
/// <returns></returns>
public MDTTransactionInfo ChangePassword(ChangePassword changePassword)
{
MDTTransactionInfo mdt = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter email = new SqlParameter("@email", changePassword.Email);
prm.Add(email);
SqlParameter oldPwd = new SqlParameter("@oldPwd", changePassword.OldPassword);
prm.Add(oldPwd);
SqlParameter NewPwd = new SqlParameter("@newPwd", changePassword.NewPassword);
prm.Add(NewPwd);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.UpdatePassword, out StatusValue, prm);
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
//if (StatusValue == 1)
//{
// mdt.status = HttpStatusCode.OK;
//}
//else if (StatusValue == 5 || StatusValue == 6)
//{
// mdt.status = HttpStatusCode.BadRequest;
//}
//if (dt.Rows.Count == 1)
//{
// ErrorInfoFromSQL eInfo = DatabaseSettings.GetError(dt);
// mdt.transactionObject = eInfo;
// mdt.message = eInfo.ErrorMessage;
// mdt.msgCode = (eInfo.Status == 1) ? MessageCode.Success : (eInfo.Status == 6) ? MessageCode.TechnicalError : MessageCode.Failed;
// mdt.LineNumber = eInfo.ErrorLineNo;
// mdt.ProcedureName = eInfo.Procedure;
//}
return(mdt);
}
/// <summary>
/// This will return the list side menu from Solution to Configuration
/// </summary>
/// <returns></returns>
public MDTTransactionInfo GetSideMenu(int UserID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
IEnumerable <SolutionList> solutionLists = null;
SolutionList solutionList = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter Status = new SqlParameter("@Status", 0);
Status.Direction = ParameterDirection.Output;
prm.Add(Status);
int StatusValue = 0;
DataTable dt = DatabaseSettings.GetDataSet("sp_GetSolutions", out StatusValue, prm).Tables[0];
if (StatusValue == 1)
{
if (dt.Rows.Count > 0)
{
solutionLists = from d in dt.AsEnumerable()
select new SolutionList
{
SOLUTION_ID = d.Field <int>("SOLUTION_ID"),
SOLUTION_NAME = d.Field <string>("SOLUTION_NAME"),
Packages = GetPackageList(d.Field <int>("SOLUTION_ID"), UserID)
};
//solutionLists = new List<SolutionList>();
//foreach (DataRow row in dt.Rows)
//{
// solutionList = new SolutionList();
// solutionList.SOLUTION_ID = Convert.ToInt32(row["SOLUTION_ID"]);
// solutionList.SOLUTION_NAME = row["SOLUTION_NAME"].ToString();
// if (Convert.ToInt32(row["SOLUTION_ID"]) > 0)
// {
// solutionList.Packages = GetPackageList(Convert.ToInt32(row["SOLUTION_ID"]), UserID);
// }
// solutionLists.Add(solutionList);
//}
}
}
mdt = DatabaseSettings.GetTransObject(solutionLists, StatusValue, "Record Found", dt);
return(mdt);
}
/// <summary>
/// Change password method which will interact with database and change the password
/// </summary>
/// <param name="changePassword">You need to pass ChangePassword type object to process the request</param>
/// <returns></returns>
public MDTTransactionInfo ChangePassword(ChangePassword changePassword)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter email = new SqlParameter("@email", changePassword.Email);
prm.Add(email);
SqlParameter oldPwd = new SqlParameter("@oldPwd", changePassword.OldPassword);
prm.Add(oldPwd);
SqlParameter NewPwd = new SqlParameter("@newPwd", changePassword.NewPassword);
prm.Add(NewPwd);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
DataTable dt = DatabaseSettings.GetDataSet("sp_UpdatePassword", out APIHelper.StatusValue, prm).Tables[0];
if (APIHelper.StatusValue == 1)
{
mdt.msgCode = MessageCode.Success;
mdt.status = HttpStatusCode.OK;
}
else if (APIHelper.StatusValue == 5)
{
mdt.status = HttpStatusCode.BadRequest;
mdt.msgCode = MessageCode.Failed;
}
if (dt.Rows.Count == 1)
{
ErrorInfoFromSQL eInfo = DatabaseSettings.GetError(dt);
mdt.transactionObject = eInfo;
mdt.message = eInfo.ErrorMessage;
mdt.LineNumber = eInfo.ErrorLineNo;
mdt.ProcedureName = eInfo.Procedure;
}
return(mdt);
}
/// <summary>
/// It return all package list for respective Solution
/// </summary>
/// <param name="SolutionID"></param>
/// <param name="UserID"></param>
/// <returns></returns>
private MDTTransactionInfo GetPackageList(int SolutionID, int UserID)
{
IEnumerable <PackageList> packageLists = null;
//PackageList packageList = null;
MDTTransactionInfo mdt = new MDTTransactionInfo();
//List<SqlParameter> prm = new List<SqlParameter>();
//SqlParameter Solution_ID = new SqlParameter("@SolutionID", SolutionID);
//prm.Add(Solution_ID);
//SqlParameter Status = new SqlParameter("@Status", 0);
//Status.Direction = ParameterDirection.Output;
//prm.Add(Status);
List <SqlParameter> prm = DatabaseSettings.BindParamers(APIHelper.getPackageListParameters, SolutionID.ToString());
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getPackageList, out StatusValue, prm);
DataTable dt;
if (StatusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
packageLists = from d in dt.AsEnumerable()
select new PackageList
{
PACKAGE_ID = d.Field <int>("PACKAGE_ID"),
PACKAGE_NAME = d.Field <string>("PACKAGE_NAME"),
SOLUTION_ID = d.Field <int>("SOLUTION_ID"),
Configurations = GetConfigurationList(UserID, d.Field <int>("PACKAGE_ID")).transactionObject as IEnumerable <ConfigurationList>
};
}
mdt.msgCode = MessageCode.Success;
mdt.status = HttpStatusCode.OK;
mdt.message = "Record found";
mdt.transactionObject = packageLists;
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
return(mdt);
}
/// <summary>
/// This will update the user profile pic path into DB after upload.
/// </summary>
/// <param name="UserID"></param>
/// <param name="filePath"></param>
/// <returns></returns>
public MDTTransactionInfo UploadProfilePic(int UserID, string filePath)
{
MDTTransactionInfo mdt = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter userid = new SqlParameter("@UserID", UserID);
prm.Add(userid);
SqlParameter filepath = new SqlParameter("@ProfilePic", filePath);
prm.Add(filepath);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.UploadProfilePic, out StatusValue, prm);
UploadProfilePics uploadProfilePics = new UploadProfilePics();
if (StatusValue == 1)
{
mdt = new MDTTransactionInfo();
uploadProfilePics.ProfilePicPath = filePath;
mdt.transactionObject = uploadProfilePics;
mdt.status = HttpStatusCode.OK;
mdt.msgCode = MessageCode.Success;
mdt.message = "File uploaded successfully";
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
//if (dt.Rows.Count == 1)
//{
// ErrorInfoFromSQL eInfo = DatabaseSettings.GetError(dt);
// mdt.transactionObject = eInfo;
// mdt.message = eInfo.ErrorMessage;
// mdt.msgCode = (eInfo.Status == 1) ? MessageCode.Success : (eInfo.Status == 6) ? MessageCode.TechnicalError : MessageCode.Failed;
// mdt.LineNumber = eInfo.ErrorLineNo;
// mdt.ProcedureName = eInfo.Procedure;
//}
return(mdt);
}
/// <summary>
/// It will return Top 3 configurations for respective package and User
/// </summary>
/// <param name="UserID"></param>
/// <param name="PackageID"></param>
/// <returns></returns>
private MDTTransactionInfo GetConfigurationList(int userID, int packageID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
try
{
IEnumerable <ConfigurationList> configLists = null;
List <SqlParameter> prm = DatabaseSettings.BindParamers(APIHelper.getLatestConfigurationsParameters, userID.ToString() + "~||~" + packageID.ToString() + "~||~" + ConfigurationManager.AppSettings["NumberOfConfiguration"].ToString());
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getLatestConfigurations, out StatusValue, prm);
DataTable dt;
if (StatusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
configLists = from d in dt.AsEnumerable()
select new ConfigurationList
{
CONFIGURATION_ID = d.Field <int>("CONFIGURATION_ID"),
CONFIGURATION_NAME = d.Field <string>("CONFIGURATION_NAME"),
PACKAGE_ID = d.Field <int>("PACKAGE_ID")
};
}
mdt.msgCode = MessageCode.Success;
mdt.status = HttpStatusCode.OK;
mdt.message = "Record found";
mdt.transactionObject = configLists;
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
}
return(mdt);
}
/// <summary>
/// This will update the user profile pic path into DB after upload.
/// </summary>
/// <param name="UserID"></param>
/// <param name="filePath"></param>
/// <returns></returns>
public MDTTransactionInfo UploadProfilePic(int userID, string filePath)
{
MDTTransactionInfo mdt = null;
try
{
List <SqlParameter> prm = new List <SqlParameter>();
//SqlParameter userid = new SqlParameter("@UserID", userID);
//prm.Add(userid);
//SqlParameter filepath = new SqlParameter("@ProfilePic", filePath);
//prm.Add(filepath);
//SqlParameter status = new SqlParameter("@Status", 0);
//status.Direction = ParameterDirection.Output;
//prm.Add(status);
prm = DatabaseSettings.BindParamers(APIHelper.uploadProfilePicParameters, userID.ToString() + "~||~" + filePath.ToString());
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.uploadProfilePic, out StatusValue, prm);
UploadProfilePics uploadProfilePics = new UploadProfilePics();
if (StatusValue == 1)
{
mdt = new MDTTransactionInfo();
uploadProfilePics.ProfilePicPath = filePath;
mdt.transactionObject = uploadProfilePics;
mdt.status = HttpStatusCode.OK;
mdt.msgCode = MessageCode.Success;
mdt.message = "File uploaded successfully";
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
}
return(mdt);
}
private MDTTransactionInfo GetBasicInputOptions(int BasicInputID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
IEnumerable <BasicInputOptions> basicInputOptions = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter Basic_Input_ID = new SqlParameter("@BASIC_INPUT_ID", BasicInputID);
prm.Add(Basic_Input_ID);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet("sp_GetBasicInputDetails", out StatusValue, prm);
DataTable dt;
if (StatusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
basicInputOptions = from d in dt.AsEnumerable()
select new BasicInputOptions
{
BASIC_INPUT_OPTN_ID = d.Field <int>("BASIC_INPUT_OPTN_ID"),
INPUT_OPT_NAME = d.Field <string>("INPUT_OPT_NAME"),
BASIC_INPUT_ID = d.Field <int>("BASIC_INPUT_ID")
};
}
mdt.msgCode = MessageCode.Success;
mdt.status = HttpStatusCode.OK;
mdt.message = "Record found";
mdt.transactionObject = basicInputOptions;
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
return(mdt);
}
/// <summary>
/// It will return the list of Suppliers
/// </summary>
/// <returns></returns>
public IEnumerable <Supplier> GetSuppliers(int systemID, int equipmentID, int configurationID, string equipment_Type)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
//Suppliers = new List<Supplier>();
try
{
List <SqlParameter> prm = new List <SqlParameter>();
prm = DatabaseSettings.BindParamers(APIHelper.getSuppiersParameters, systemID.ToString() + "~||~" + equipmentID.ToString() + "~||~" + configurationID.ToString() + "~||~" + equipment_Type.ToString());
int statusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getSuppiers, out statusValue, prm);
DataTable dt;
if (statusValue == 1)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
Suppliers = from d in dt.AsEnumerable()
select new Supplier
{
SUPPLIER_ID = d.Field <int>("SUPPLIER_ID"),
EQUIPMENT_ID = d.Field <int>("EQUIPMENT_ID"),
SYSTEM_ID = d.Field <int>("SYSTEM_ID"),
SUPPLIER_NAME = d.Field <string>("SUPPLIER_NAME"),
COST = d.Field <double>("COST"),
VALID_FROM = d.Field <DateTime>("VALID_FROM"),
VALID_TO = d.Field <DateTime>("VALID_TO")
};
}
}
}
catch (Exception ex)
{
throw new Exception("Technical Error in the system, please contact to administrator");
// Need to log error in logger from ex
}
return(Suppliers);
}
private IEnumerable <BasicInputOptions> GetBasicInputOptions(int BasicInputID)
{
IEnumerable <BasicInputOptions> basicInputOptions = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter Basic_Input_ID = new SqlParameter("@BASIC_INPUT_ID", BasicInputID);
prm.Add(Basic_Input_ID);
DataTable dt = DatabaseSettings.GetDataSet("sp_GetBasicInputDetails", prm).Tables[0];
if (dt.Rows.Count > 0)
{
basicInputOptions = from d in dt.AsEnumerable()
select new BasicInputOptions
{
BASIC_INPUT_OPTN_ID = d.Field <int>("BASIC_INPUT_OPTN_ID"),
INPUT_OPT_NAME = d.Field <string>("INPUT_OPT_NAME"),
BASIC_INPUT_ID = d.Field <int>("BASIC_INPUT_ID")
};
}
return(basicInputOptions);
}
/// <summary>
/// It will return Top 3 configurations for respective package and User
/// </summary>
/// <param name="UserID"></param>
/// <param name="PackageID"></param>
/// <returns></returns>
private IEnumerable <ConfigurationList> GetConfigurationList(int UserID, int PackageID)
{
IEnumerable <ConfigurationList> configLists = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter userID = new SqlParameter("@UserID", UserID);
prm.Add(userID);
SqlParameter packageID = new SqlParameter("@PackageID", PackageID);
prm.Add(packageID);
SqlParameter NoofConfiguration = new SqlParameter("@NoofConfiguration", 3);
prm.Add(NoofConfiguration);
SqlParameter Status = new SqlParameter("@Status", 0);
Status.Direction = ParameterDirection.Output;
prm.Add(Status);
int StatusValue = 0;
DataTable dt = DatabaseSettings.GetDataSet("sp_GetLatestConfiguration", out StatusValue, prm).Tables[0];
if (StatusValue == 1)
{
if (dt.Rows.Count > 0)
{
configLists = from d in dt.AsEnumerable()
select new ConfigurationList
{
CONFIGURATION_ID = d.Field <int>("CONFIGURATION_ID"),
CONFIGURATION_NAME = d.Field <string>("CONFIGURATION_NAME"),
PACKAGE_ID = d.Field <int>("PACKAGE_ID")
};
}
}
return(configLists);
}
/// <summary>
/// This is login method and it will connect to DB and check if user is exists or not. If user exists then it will display the user detail
/// </summary>
/// <param name="userLogin"></param>
/// <returns></returns>
public MDTTransactionInfo Login(UserLogin userLogin)
{
MDTTransactionInfo mdt = null;
try
{
UserLoginDetails loginDetails = null;
List <SqlParameter> prm = new List <SqlParameter>();
//SqlParameter email = new SqlParameter("@email", userLogin.UserName);
//prm.Add(email);
//SqlParameter pwd = new SqlParameter("@pwd", userLogin.Password);
//prm.Add(pwd);
//SqlParameter status = new SqlParameter("@Status", 0);
//status.Direction = ParameterDirection.Output;
//prm.Add(status);
prm = DatabaseSettings.BindParamers(APIHelper.getLoginDetailsParameters, userLogin.UserName + "~||~" + userLogin.Password);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getLoginDetails, out StatusValue, prm);
DataTable dt;
if (StatusValue == 1)
{
dt = ds.Tables[0];
mdt = new MDTTransactionInfo();
if (dt.Rows.Count > 0)
{
loginDetails = new UserLoginDetails();
loginDetails.USER_ID = Convert.ToInt32(dt.Rows[0]["USER_ID"]);
loginDetails.FIRST_NAME = dt.Rows[0]["FIRST_NAME"].ToString();
loginDetails.LAST_NAME = dt.Rows[0]["LAST_NAME"].ToString();
loginDetails.EMAIL_ADDRESS = dt.Rows[0]["EMAIL_ADDRESS"].ToString();
loginDetails.FORCE_PWD_CHNG = Convert.ToBoolean(dt.Rows[0]["FORCE_PWD_CHNG"]);
loginDetails.PHOTO = dt.Rows[0]["PHOTO"].ToString();
loginDetails.ROLE_NAME = dt.Rows[0]["ROLE_NAME"].ToString();
loginDetails.ROLE_ID = Convert.ToInt32(dt.Rows[0]["ROLE_ID"]);
loginDetails.UserKey = SecurityEncryptDecrypt.Encrypt(dt.Rows[0]["EMAIL_ADDRESS"].ToString());
loginDetails.UserValue = SecurityEncryptDecrypt.Encrypt(dt.Rows[0]["PASSWORD"].ToString());
mdt.status = HttpStatusCode.OK;
mdt.transactionObject = loginDetails;
mdt.msgCode = MessageCode.Success;
mdt.message = "Login Successfully";
}
else
{
mdt.msgCode = MessageCode.Failed;
mdt.status = HttpStatusCode.NoContent;
mdt.message = "No record found";
}
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
}
return(mdt);
}
/// <summary>
/// This will return list of Basic input options available in database
/// </summary>
/// <returns></returns>
public MDTTransactionInfo GetBasicInputs(int packageID, int configurationID)
{
MDTTransactionInfo mdt = new MDTTransactionInfo();
try
{
IEnumerable <BasicInput> basicInputs = null;
List <SqlParameter> prm = new List <SqlParameter>();
//SqlParameter status = new SqlParameter("@Status", 0);
//status.Direction = ParameterDirection.Output;
//prm.Add(status);
prm = DatabaseSettings.BindParamers(APIHelper.getBasicInputdParameters, packageID.ToString() + "~||~" + configurationID.ToString());
int statusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getBasicInput, out statusValue, prm);
DataTable dt;
if (statusValue == 1)
{
mdt = new MDTTransactionInfo();
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
basicInputs = from d in dt.AsEnumerable()
select new BasicInput
{
BASIC_INPUT_ID = d.Field <int>("BASIC_INPUT_ID"),
DEFAULT_INPUT_OPT_ID = d.Field <int>("DEFAULT_INPUT_OPT_ID"),
CONFIGURATION_ID = d.Field <int>("CONFIGURATION_ID"),
UPDT_USER_ID = d.Field <int>("UPDT_USER_ID"),
BASIC_INPUT_NAME = d.Field <string>("BASIC_INPUT_NAME"),
BasicInputOptions = GetBasicInputOptions(d.Field <int>("BASIC_INPUT_ID")).transactionObject as IEnumerable <BasicInputOptions>
};
}
if (basicInputs != null)
{
mdt.transactionObject = basicInputs;
mdt.status = HttpStatusCode.OK;
mdt.msgCode = MessageCode.Success;
mdt.message = "Fetched basic input detail successfully";
}
else
{
mdt.transactionObject = null;
mdt.status = HttpStatusCode.NotFound;
mdt.msgCode = MessageCode.Failed;
mdt.message = "No record found";
}
}
else if (statusValue == 5 || statusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, statusValue, "", ds);
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
}
return(mdt);
}
