public DataSet UserInsertUpdate(JsonMember.UserDetails obj)
{
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(8);
Sqldbmanager.AddParameters(0, "@AUserId", obj.AUserId);
Sqldbmanager.AddParameters(1, "@UserId", obj.UserId);
Sqldbmanager.AddParameters(2, "@LoginId", obj.LoginId);
Sqldbmanager.AddParameters(3, "@Name", obj.Name);
Sqldbmanager.AddParameters(4, "@Password", obj.Password);
Sqldbmanager.AddParameters(5, "@EmailId", obj.EmailId);
Sqldbmanager.AddParameters(6, "@ContactNo", obj.ContactNo);
Sqldbmanager.AddParameters(7, "@DepartmentId", obj.DepartmentId);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_UserInserUpdate");
}
catch (Exception Ex)
{
DS = LogError("User Insert Update", Ex.Message.ToString(), "SP Name: USP_UserInserUpdate");
}
finally
{
Sqldbmanager.Close();
}
return(DS);
}
public DataSet MenuPermission(JsonMember.UserDetails obj)
{
try
{
StringBuilder InMenuPermission = new StringBuilder();
for (int i = 0; i < obj.MenuPermission.Count; i++)
{
InMenuPermission.AppendLine("<nodes>");
InMenuPermission.AppendLine(" <node>");
InMenuPermission.AppendLine(" <MenuId>" + obj.MenuPermission[i].MenuId + "</MenuId>");
InMenuPermission.AppendLine(" <AdminType>" + obj.MenuPermission[i].AdminType + "</AdminType>");
InMenuPermission.AppendLine(" <CounterType>" + obj.MenuPermission[i].CounterType + "</CounterType>");
InMenuPermission.AppendLine(" </node>");
InMenuPermission.AppendLine("</nodes>");
}
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(2);
Sqldbmanager.AddParameters(0, "@UserId", obj.UserId);
Sqldbmanager.AddParameters(1, "@InMenuPermission", InMenuPermission.ToString());
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_MeunPermission");
}
catch (Exception Ex)
{
DS = LogError("MenuPermission", Ex.Message.ToString(), "SP Name: USP_MeunPermission");
}
finally
{
Sqldbmanager.Close();
}
return(DS);
}
public DataTable UpdatePassword(JsonMember.UserDetails obj)
{
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(2);
Sqldbmanager.AddParameters(0, "@Flag", "getPassword");
Sqldbmanager.AddParameters(1, "@Id", obj.UserId);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_CommonData");
if (DS.Tables[0].Rows[0]["UserPassword"].ToString() == obj.Password)
{
Sqldbmanager.CreateParameters(8);
Sqldbmanager.AddParameters(0, "@UserId", obj.UserId);
Sqldbmanager.AddParameters(1, "@NewPassword", obj.NewPassword);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_UpdatePassword");
dt = DS.Tables[0];
}
else
{
dt = DS.Tables[1];
}
}
catch (Exception Ex)
{
DS = LogError("Update Password", Ex.Message.ToString(), "SP Name: USP_UpdatePassword");
}
finally
{
Sqldbmanager.Close();
}
return(dt);
}
public object UpdatePersonalDetails(JsonMember.UserDetails obj)
{
LoginReturn Lobj = new LoginReturn();
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(5);
Sqldbmanager.AddParameters(0, "@UserId", obj.UserId);
Sqldbmanager.AddParameters(1, "@FirstName", obj.FirstName.Trim());
Sqldbmanager.AddParameters(2, "@LastName", obj.LastName.Trim());
Sqldbmanager.AddParameters(3, "@EmailId", obj.EmailId.Trim());
Sqldbmanager.AddParameters(4, "@ProfilePicPath", obj.ProfilePicPath);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_UpdateuserProfile");
Lobj = new LoginReturn()
{
flag = DS.Tables[0].Rows[0]["flag"].ToString(),
Message = DS.Tables[0].Rows[0]["Message"].ToString(),
EmailId = DS.Tables[0].Rows[0]["EmailId"].ToString(),
MobileNo = DS.Tables[0].Rows[0]["MobileNo"].ToString(),
Name = DS.Tables[0].Rows[0]["Name"].ToString(),
UserName = DS.Tables[0].Rows[0]["UserName"].ToString(),
UserId = DS.Tables[0].Rows[0]["UserId"].ToString(),
FirstName = DS.Tables[0].Rows[0]["FirstName"].ToString(),
LastName = DS.Tables[0].Rows[0]["LastName"].ToString(),
ProfilePicPath = DS.Tables[0].Rows[0]["ProfilePicPath"].ToString()
};
}
catch (Exception Ex)
{
DS = LogError("Update Personal Detail", Ex.Message.ToString(), "SP Name: USP_UpdateuserProfile");
Lobj = new LoginReturn()
{
flag = "false",
Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(),
EmailId = "",
MobileNo = "",
Name = "",
UserId = "",
FirstName = "",
LastName = "",
ProfilePicPath = "",
};
}
finally
{
Sqldbmanager.Close();
}
return(Lobj);
}
public object GenerateUser(JsonMember.UserDetails obj)
{
registrationReturn obj1 = new registrationReturn();
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(5);
Sqldbmanager.AddParameters(0, "@Name", obj.Name);
Sqldbmanager.AddParameters(1, "@UserName", obj.UserName);
Sqldbmanager.AddParameters(2, "@UserPassword", obj.Password);
Sqldbmanager.AddParameters(3, "@EmailId", obj.EmailId);
Sqldbmanager.AddParameters(4, "@MobileNo", obj.MobileNo);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_GenerateUser");
if (Convert.ToBoolean(DS.Tables[0].Rows[0]["flag"]) == true)
{
objEMail.SendSMSbyTillio(obj.MobileNo, "Flipprr Verification Code " + DS.Tables[0].Rows[0]["OTP"].ToString());
//Thread thrdSms = new Thread(() => SmsResult = (new Email()).SendSMS(obj.MobileNo, DS.Tables[0].Rows[0]["OTP"].ToString() + " is your flipprr verification code."));
//thrdSms.Start();
//Thread thrdMail = new Thread(() => MailResult = (new Email()).sendMail(obj.EmailId, "", "Flipprr Verification Code", DS.Tables[0].Rows[0]["OTP"].ToString(), ""));
//thrdMail.Start();
}
obj1 = new registrationReturn()
{
flag = DS.Tables[0].Rows[0]["flag"].ToString(),
Message = DS.Tables[0].Rows[0]["Message"].ToString(),
OTPId = DS.Tables[0].Rows[0]["OTPId"].ToString(),
OTP = DS.Tables[0].Rows[0]["OTP"].ToString(),
UserId = DS.Tables[0].Rows[0]["UserId"].ToString()
};
}
catch (Exception Ex)
{
DS = LogError("Generate User", Ex.Message.ToString(), "SP Name: USP_GenerateUser");
obj1 = new registrationReturn()
{
flag = "false",
Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(),
OTPId = "",
OTP = "",
UserId = ""
};
}
finally
{
Sqldbmanager.Close();
}
return(obj1);
}
public DataSet HeaderDetails(JsonMember.UserDetails obj)
{
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(1);
Sqldbmanager.AddParameters(0, "@UserId", obj.UserId);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_HeaderDetails");
}
catch (Exception Ex)
{
DS = LogError("Header Details", Ex.Message.ToString(), "SP Name: USP_HeaderDetails");
}
finally
{
Sqldbmanager.Close();
}
return(DS);
}
public object ForgetPassword(JsonMember.UserDetails obj)
{
registrationReturn obj1 = new registrationReturn();
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(1);
Sqldbmanager.AddParameters(0, "@LoginId", obj.LoginId);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "usp_ForgetPassword");
if (Convert.ToBoolean(DS.Tables[0].Rows[0]["flag"]) == true)
{
//objEMail.SendSMS(obj.MobileNo, DS.Tables[0].Rows[0]["MobileNo"].ToString() + " is your flipprr verification code.");
objEMail.SendSMSbyTillio(DS.Tables[0].Rows[0]["MobileNo"].ToString(), "Flipprr Verification Code " + DS.Tables[0].Rows[0]["OTP"].ToString());
}
obj1 = new registrationReturn()
{
flag = DS.Tables[0].Rows[0]["flag"].ToString(),
Message = DS.Tables[0].Rows[0]["Message"].ToString(),
OTPId = DS.Tables[0].Rows[0]["OTPId"].ToString(),
OTP = DS.Tables[0].Rows[0]["OTP"].ToString(),
UserId = DS.Tables[0].Rows[0]["UserId"].ToString()
};
}
catch (Exception Ex)
{
DS = LogError("Forget Password", Ex.Message.ToString(), "SP Name: usp_ForgetPassword");
obj1 = new registrationReturn()
{
flag = "false",
Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(),
OTPId = "",
OTP = "",
UserId = ""
};
}
finally
{
Sqldbmanager.Close();
}
return(obj1);
}
public object ChangePassword(JsonMember.UserDetails obj)
{
registrationReturn obj1 = new registrationReturn();
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(4);
Sqldbmanager.AddParameters(0, "@UserId", obj.UserId);
Sqldbmanager.AddParameters(1, "@OTPId", obj.OTPId);
Sqldbmanager.AddParameters(2, "@OTP", obj.OTP);
Sqldbmanager.AddParameters(3, "@UserPassword", obj.Password);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_ChangePassword");
obj1 = new registrationReturn()
{
flag = DS.Tables[0].Rows[0]["flag"].ToString(),
Message = DS.Tables[0].Rows[0]["Message"].ToString(),
OTPId = "",
OTP = "",
UserId = DS.Tables[0].Rows[0]["UserId"].ToString()
};
}
catch (Exception Ex)
{
DS = LogError("Change Password", Ex.Message.ToString(), "SP Name: USP_ChangePassword");
obj1 = new registrationReturn()
{
flag = "false",
Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(),
OTPId = "",
OTP = "",
UserId = ""
};
}
finally
{
Sqldbmanager.Close();
}
return(obj1);
}
public DataTable LoginMaster(JsonMember.UserDetails obj)
{
DataTable Logindt = new DataTable();
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(1);
Sqldbmanager.AddParameters(0, "@LoginId", obj.LoginId);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_LoginMaster");
if (DS.Tables[1].Rows.Count > 0)
{
if (DS.Tables[0].Rows[0]["UserPassword"].ToString() == obj.Password)
{
Logindt = DS.Tables[1];
}
else
{
Logindt = LogError("LoginMaster", "Invaid Password", obj.LoginId).Tables[0];
}
}
else
{
Logindt = LogError("LoginMaster", "Invaid Login Id", obj.LoginId).Tables[0];
}
}
catch (Exception Ex)
{
Logindt = LogError("LoginMaster", Ex.Message.ToString(), "").Tables[0];
}
finally
{
Sqldbmanager.Close();
}
return(Logindt);
}
public object GetAllProfileDetails(JsonMember.UserDetails obj)
{
List <JsonMember.LoginReturn> lstDetails = new List <JsonMember.LoginReturn>();
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(1);
Sqldbmanager.AddParameters(0, "@UserId", obj.UserId);
idr = Sqldbmanager.ExecuteReader(CommandType.StoredProcedure, "USP_GetCompletePoflieDetails");
if (idr.Read())
{
while (idr.Read())
{
lstDetails.Add(new JsonMember.LoginReturn()
{
flag = "true",
Message = "Success",
EmailId = Convert.ToString(idr["EmailId"]),
MobileNo = Convert.ToString(idr["MobileNo"]),
Name = Convert.ToString(idr["Name"]),
UserName = Convert.ToString(idr["UserName"]),
UserId = Convert.ToString(idr["UserId"]),
FirstName = Convert.ToString(idr["FirstName"]),
LastName = Convert.ToString(idr["LastName"]),
ProfilePicPath = Convert.ToString(idr["ProfilePicPath"])
});
}
}
else
{
lstDetails.Add(new JsonMember.LoginReturn()
{
flag = "false",
Message = "No User Found",
EmailId = "",
MobileNo = "",
Name = "",
UserId = "",
FirstName = "",
LastName = "",
ProfilePicPath = "",
});
}
}
catch (Exception Ex)
{
lstDetails.Add(new JsonMember.LoginReturn()
{
flag = "false",
Message = Ex.Message.ToString(),
EmailId = "",
MobileNo = "",
Name = "",
UserId = "",
FirstName = "",
LastName = "",
ProfilePicPath = "",
});
}
finally
{
Sqldbmanager.Close();
}
return(lstDetails);
}
public Object LoginMaster(JsonMember.UserDetails obj)
{
LoginReturn Lobj = new LoginReturn();
DataTable Logindt = new DataTable();
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(1);
Sqldbmanager.AddParameters(0, "@LoginId", obj.LoginId);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_LoginMaster");
if (DS.Tables[1].Rows.Count > 0)
{
if (DS.Tables[0].Rows[0]["UserPassword"].ToString() == obj.Password)
{
Lobj = new LoginReturn()
{
flag = "true",
Message = "Success",
EmailId = DS.Tables[1].Rows[0]["EmailId"].ToString(),
MobileNo = DS.Tables[1].Rows[0]["MobileNo"].ToString(),
Name = DS.Tables[1].Rows[0]["Name"].ToString(),
UserName = DS.Tables[1].Rows[0]["UserName"].ToString(),
UserId = DS.Tables[1].Rows[0]["UserId"].ToString(),
FirstName = DS.Tables[1].Rows[0]["FirstName"].ToString(),
LastName = DS.Tables[1].Rows[0]["LastName"].ToString(),
ProfilePicPath = DS.Tables[1].Rows[0]["ProfilePicPath"].ToString()
};
}
else
{
Lobj = new LoginReturn()
{
flag = "false",
Message = "Invalid Password",
EmailId = "",
MobileNo = "",
Name = "",
UserId = "",
FirstName = "",
LastName = "",
ProfilePicPath = "",
};
}
}
else
{
Lobj = new LoginReturn()
{
flag = "false",
Message = "User not register with us.",
EmailId = "",
MobileNo = "",
Name = "",
UserId = "",
FirstName = "",
LastName = "",
ProfilePicPath = "",
};
}
}
catch (Exception)
{
Lobj = new LoginReturn()
{
flag = "false",
Message = "Invalid Email/Mobile",
EmailId = "",
MobileNo = "",
Name = "",
UserId = "",
FirstName = "",
LastName = "",
ProfilePicPath = "",
};
}
finally
{
Sqldbmanager.Close();
}
return(Lobj);
}
public object GetProfileByLogin(JsonMember.UserDetails obj)
{
LoginReturn lstDetails = new LoginReturn();
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(1);
Sqldbmanager.AddParameters(0, "@LoginId", obj.LoginId);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_LoginMaster");
if (DS.Tables[1].Rows.Count > 0)
{
lstDetails = new LoginReturn()
{
flag = "true",
Message = "Success",
EmailId = DS.Tables[1].Rows[0]["EmailId"].ToString(),
MobileNo = DS.Tables[1].Rows[0]["MobileNo"].ToString(),
Name = DS.Tables[1].Rows[0]["Name"].ToString(),
UserName = DS.Tables[1].Rows[0]["UserName"].ToString(),
UserId = DS.Tables[1].Rows[0]["UserId"].ToString(),
FirstName = DS.Tables[1].Rows[0]["FirstName"].ToString(),
LastName = DS.Tables[1].Rows[0]["LastName"].ToString(),
ProfilePicPath = DS.Tables[1].Rows[0]["ProfilePicPath"].ToString()
};
}
else
{
lstDetails = new LoginReturn()
{
flag = "false",
Message = "No User Found",
EmailId = "",
MobileNo = "",
Name = "",
UserId = "",
FirstName = "",
LastName = "",
ProfilePicPath = "",
};
}
}
catch (Exception Ex)
{
lstDetails = new LoginReturn()
{
flag = "false",
Message = Ex.Message.ToString(),
EmailId = "",
MobileNo = "",
Name = "",
UserId = "",
FirstName = "",
LastName = "",
ProfilePicPath = "",
};
}
finally
{
Sqldbmanager.Close();
}
return(lstDetails);
}
