public string PutUserService(int id, UserServiceDetails u)
{
try
{
var a = (from ad in es.User_Service_Details
where ad.User_Id == id
select ad).SingleOrDefault();
if (a == null)
{
return("Invalid Id");
}
else
{
a.User_Id = u.User_Id;
a.Service_Category_ID = u.Service_Category_ID;
a.User_Name = u.User_Name;
a.User_Address = u.User_Address;
a.User_Contact = u.User_Contact;
a.User_Availavility = u.User_Availability;
a.User_Rate = u.User_Rate;
var res = es.SaveChanges();
if (res > 0)
{
return("Data Uploaded");
}
}
return("Error In data Updating");
}
catch (Exception ex)
{
throw ex;
}
}
public string PutUserServiceDetails(int id, UserServiceDetails r)
{
try
{
User_Service_Details us = new User_Service_Details();
var u = (from user in es.User_Service_Details
where user.User_Id == id
select user).SingleOrDefault();
if (u == null)
{
return("Id Invalid");
}
else
{
u.Service_Category_ID = r.Service_Category_ID;
u.User_Name = r.User_Name;
u.User_Address = r.User_Address;
u.User_Contact = r.User_Contact;
u.User_Availavility = r.User_Availability;
u.User_Rate = r.User_Rate;
var res = es.SaveChanges();
if (res > 0)
{
return("data Inserted");
}
return("Error In Inserting Data");
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool PostUserService(UserServiceDetails u)
{
try
{
User_Service_Details a = new User_Service_Details();
a.Service_Category_ID = u.Service_Category_ID;
a.User_Name = u.User_Name;
a.User_Address = u.User_Address;
a.User_Contact = u.User_Contact;
a.User_Availavility = u.User_Availability;
a.User_Rate = u.User_Rate;
es.User_Service_Details.Add(a);
var res = es.SaveChanges();
if (res > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <UserServiceDetails> GetUserService()
{
try
{
var res = es.User_Service_Details.ToList();
List <UserServiceDetails> ad = new List <UserServiceDetails>();
foreach (var r in res)
{
UserServiceDetails a = new UserServiceDetails();
a.User_Id = r.User_Id;
a.Service_Category_ID = r.Service_Category.Service_Category_ID;
a.User_Name = r.User_Name;
a.User_Address = r.User_Address;
a.User_Contact = r.User_Contact;
a.User_Availability = r.User_Availavility;
a.User_Rate = r.User_Rate;
ad.Add(a);
}
return(ad);
}
catch (Exception ex)
{
throw ex;
}
}
public UserServiceDetails GetByIdUserService(int id)
{
try
{
UserServiceDetails a = new UserServiceDetails();
var r = es.User_Service_Details.Where(x => x.User_Id == id).SingleOrDefault();
if (r != null)
{
a.User_Id = r.User_Id;
a.Service_Category_ID = Convert.ToInt32(r.Service_Category_ID);
a.User_Name = r.User_Name;
a.User_Address = r.User_Address;
a.User_Contact = r.User_Contact;
a.User_Availability = r.User_Availavility;
a.User_Rate = r.User_Rate;
}
else
{
throw new Exception("invalid Id");
}
return(a);
}
catch (Exception ex)
{
throw ex;
}
}
public UserServiceDetails GetByIdUserServiceDetails(int id)
{
UserServiceDetails u = new UserServiceDetails();
var r = es.User_Service_Details.Where(x => x.User_Id == id).SingleOrDefault();
u.User_Id = r.User_Id;
u.Service_Category_ID = r.Service_Category_ID;
u.User_Name = r.User_Name;
u.User_Address = r.User_Address;
u.User_Contact = r.User_Contact;
u.User_Availability = r.User_Availavility;
u.User_Rate = r.User_Rate;
return(u);
}
public IEnumerable <UserServiceDetails> GetAllUserServiceDetails()
{
List <UserServiceDetails> us = new List <UserServiceDetails>();
var res = es.User_Service_Details.ToList();
foreach (var r in res)
{
UserServiceDetails u = new UserServiceDetails();
u.User_Id = r.User_Id;
u.Service_Category_ID = r.Service_Category_ID;
u.User_Name = r.User_Name;
u.User_Address = r.User_Address;
u.User_Contact = r.User_Contact;
u.User_Availability = r.User_Availavility;
u.User_Rate = r.User_Rate;
us.Add(u);
}
return(us);
}
public string put(int id, [FromBody] UserServiceDetails u)
{
return(ud.PutUserService(id, u));
}
public bool post([FromBody] UserServiceDetails u)
{
return(ud.PostUserService(u));
}
