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