public Result.Result Save(userMaster obj, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.USERMAST_c(obj.IFLAG, obj.USERID, obj.LOGINID, obj.Email, obj.MobileNo == null?"":obj.MobileNo, obj.MobileVerify,
obj.EmailVerify, obj.FNAME == null ? "" : obj.FNAME, obj.MNAME == null?"":obj.MNAME, obj.LNAME == null ?"":obj.LNAME, obj.DOB,
obj.ADDRESS == null?"":obj.ADDRESS, obj.PASSWORD, obj.SVRKEY == null?"":obj.SVRKEY, obj.SVRDATE,
obj.SecondaryEmailID == null ?"":obj.SecondaryEmailID, obj.ISACTIVE, obj.ISADMIN, obj.COUNTRYNAME == null ?"":obj.COUNTRYNAME, USERID, LOGXML);
return(ReadBIErrors(Convert.ToString(SqlExe.GetXml(xdoc))));
}
catch (Exception ex)
{
throw ex;
}
}
public List <userMaster> getLKUserList(int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.LK_USERMAST_g(USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
List <userMaster> dbresult = dt != null ?
(from s in dt.AsEnumerable()
select new userMaster
{
USERID = s.Field <Int64>("USERID"),
LOGINID = s.Field <string>("LOGINID"),
Email = s.Field <string>("Email"),
MobileNo = s.Field <string>("MobileNo"),
MobileVerify = s.Field <bool>("MobileVerify"),
EmailVerify = s.Field <bool>("EmailVerify"),
FNAME = s.Field <string>("FNAME"),
MNAME = s.Field <string>("MNAME"),
LNAME = s.Field <string>("LNAME"),
DOB = s.Field <DateTime>("DOB"),
ADDRESS = s.Field <string>("ADDRESS"),
PASSWORD = s.Field <string>("PASSWORD"),
SVRKEY = s.Field <string>("SVRKEY"),
SVRDATE = s.Field <DateTime>("SVRDATE"),
SecondaryEmailID = s.Field <string>("SecondaryEmailID"),
ISACTIVE = s.Field <bool>("ISACTIVE"),
ISADMIN = s.Field <bool>("ISADMIN"),
COUNTRYNAME = s.Field <string>("COUNTRYNAME")
}).ToList() : null;
return(dbresult);
}
catch (Exception ex)
{
throw ex;
}
}
