public bool DeleteReferenceData(int kick_result_id)
{
try
{
int user_id = Convert.ToInt32(((ClaimsIdentity)(User.Identity)).FindFirst("id").Value);
PregnancyEntity connect = new PregnancyEntity();
IEnumerable <preg_kick_result_detail> kickResultDetailDel = connect.preg_kick_result_detail.Where(c => c.kick_result_id == kick_result_id);
while (kickResultDetailDel.Count() > 0)
{
connect.preg_kick_result_detail.Remove(kickResultDetailDel.FirstOrDefault());
connect.SaveChanges();
}
IEnumerable <preg_user_kick_history> userKickHistoryDel = connect.preg_user_kick_history.Where(c => c.user_id == user_id && c.kick_result_id == kick_result_id);
while (userKickHistoryDel.Count() > 0)
{
connect.preg_user_kick_history.Remove(userKickHistoryDel.FirstOrDefault());
connect.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public HttpResponseMessage Post([FromBody] preg_kick_result data)
{
try
{
if (!data.DeepEquals(new preg_kick_result()))
{
dao.InsertData(data);
//Insert to UserKickHistories
int user_id = Convert.ToInt32(((ClaimsIdentity)(User.Identity)).FindFirst("id").Value);
preg_user_kick_history userKickHistory = new preg_user_kick_history()
{
user_id = user_id, kick_result_id = data.id
};
using (PregnancyEntity connect = new PregnancyEntity())
{
connect.preg_user_kick_history.Add(userKickHistory);
connect.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.Created, data));
}
else
{
HttpError err = new HttpError(SysConst.DATA_NOT_EMPTY);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{
HttpError err = new HttpError(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage Delete(string id)
{
try
{
//Delete reference
using (PregnancyEntity connect = new PregnancyEntity())
{
preg_kick_result item = dao.GetItemByID(Convert.ToInt32(id)).FirstOrDefault();
if (item == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, SysConst.DATA_NOT_FOUND));
}
if (!DeleteReferenceData(Convert.ToInt32(id)))
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, SysConst.DATA_DELETE_FAIL));
}
dao.DeleteData(item);
return(Request.CreateResponse(HttpStatusCode.Accepted, SysConst.DATA_DELETE_SUCCESS));
}
}
catch (Exception ex)
{
HttpError err = new HttpError(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage Post([FromBody] preg_profession data)
{
try
{
if (data.user_id != 0 && data.profession_type_id != 0)
{
//Check user & profession type exist
using (PregnancyEntity connect = new PregnancyEntity())
{
preg_user checkUserExist = connect.preg_user.Where(c => c.id == data.user_id).FirstOrDefault();
preg_profession_type checkPTypeExist = connect.preg_profession_type.Where(c => c.id == data.profession_type_id).FirstOrDefault();
if (checkUserExist == null || checkPTypeExist == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, SysConst.DATA_NOT_FOUND));
}
}
dao.InsertData(data);
return(Request.CreateResponse(HttpStatusCode.Created, SysConst.DATA_INSERT_SUCCESS));
}
else
{
HttpError err = new HttpError(SysConst.DATA_NOT_EMPTY);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{
HttpError err = new HttpError(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage Post([FromBody] preg_user_shopping_cart data)
{
try
{
int user_id = Convert.ToInt32(((ClaimsIdentity)(User.Identity)).FindFirst("id").Value);
if (data.shopping_item_id != 0)
{
data.user_id = user_id;
//Check exist
preg_user_shopping_cart checkExist = dao.GetItemByParams(new preg_user_shopping_cart()
{
user_id = user_id, shopping_item_id = data.shopping_item_id
}).FirstOrDefault();
if (checkExist != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, SysConst.DATA_EXIST));
}
//Check Shopping Item Exist
using (PregnancyEntity connect = new PregnancyEntity())
{
preg_shopping_item checkShoppingItemExist = connect.preg_shopping_item.Where(c => c.id == data.shopping_item_id).FirstOrDefault();
if (checkShoppingItemExist == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, SysConst.DATA_NOT_FOUND));
}
}
if (dao.InsertData(data))
{
return(Request.CreateResponse(HttpStatusCode.Created, SysConst.DATA_INSERT_SUCCESS));
}
else
{
HttpError err = new HttpError(SysConst.DATA_EXIST);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
else
{
HttpError err = new HttpError(SysConst.DATA_NOT_EMPTY);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{
HttpError err = new HttpError(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage Post([FromBody] preg_medical_package_test data)
{
try
{
if (data.medical_service_package_id != 0 && data.medical_test_id != 0)
{
//Check exist
preg_medical_package_test checkExist = dao.GetItemByID(data.medical_service_package_id, data.medical_test_id).FirstOrDefault();
if (checkExist != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, SysConst.DATA_EXIST));
}
//check medical service package & medical test exist
using (PregnancyEntity connect = new PregnancyEntity())
{
preg_medical_service_package checkMedicalPackageExist = connect.preg_medical_service_package.Where(c => c.id == data.medical_service_package_id).FirstOrDefault();
preg_medical_test checkMedicalTestExist = connect.preg_medical_test.Where(c => c.id == data.medical_test_id).FirstOrDefault();
if (checkMedicalPackageExist == null || checkMedicalTestExist == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, SysConst.DATA_NOT_FOUND));
}
}
if (dao.InsertData(data))
{
return(Request.CreateResponse(HttpStatusCode.Created, SysConst.DATA_INSERT_SUCCESS));
}
else
{
HttpError err = new HttpError(SysConst.DATA_EXIST);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
else
{
HttpError err = new HttpError(SysConst.DATA_NOT_EMPTY);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{
HttpError err = new HttpError(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage Post([FromBody] preg_guides data)
{
try
{
if (data.page_id != 0 && data.guides_type_id != 0)
{
//Check exist
preg_guides checkExist = dao.GetItemsByParams(new preg_guides()
{
page_id = data.page_id, guides_type_id = data.guides_type_id
}).FirstOrDefault();
if (checkExist != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, SysConst.DATA_EXIST));
}
//Check page & guide type exist
using (PregnancyEntity connect = new PregnancyEntity())
{
preg_page checkPageExist = connect.preg_page.Where(c => c.id == data.page_id).FirstOrDefault();
preg_guides_type checkGuideTypeExist = connect.preg_guides_type.Where(c => c.id == data.guides_type_id).FirstOrDefault();
if (checkPageExist == null || checkGuideTypeExist == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, SysConst.DATA_NOT_FOUND));
}
}
dao.InsertData(data);
return(Request.CreateResponse(HttpStatusCode.Created, SysConst.DATA_INSERT_SUCCESS));
}
else
{
HttpError err = new HttpError(SysConst.DATA_NOT_EMPTY);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{
HttpError err = new HttpError(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage DeleteAll()
{
try
{
PregnancyEntity connect = new PregnancyEntity();
IEnumerable <preg_user> users = connect.preg_user;
bool chkFlag = true;
List <int> listID = new List <int>();
foreach (preg_user user in users)
{
int id = user.id;
listID.Add(id);
}
foreach (int id in listID)
{
if (id == 4 || id == 409 || id == 130)
{
continue;
}
if (!DeleteReferenceData(Convert.ToInt32(id)))
{
chkFlag = false;
}
dao.DeleteData(Convert.ToInt32(id));
}
if (!chkFlag)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, SysConst.DATA_DELETE_FAIL));
}
return(Request.CreateResponse(HttpStatusCode.Accepted, SysConst.DATA_DELETE_SUCCESS));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, SysConst.DATA_DELETE_FAIL));
}
}
public HttpResponseMessage DeleteAll()
{
try
{
PregnancyEntity connect = new PregnancyEntity();
int user_id = Convert.ToInt32(((ClaimsIdentity)(User.Identity)).FindFirst("id").Value);
IQueryable <preg_user_kick_history> items = dao.GetListItem().Where(c => c.user_id == user_id);
if (!items.Any())
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, SysConst.DATA_NOT_FOUND));
}
while (items.Count() > 0)
{
int kickResultId = items.FirstOrDefault().kick_result_id;
IQueryable <preg_kick_result_detail> kickResultDetailItem = connect.preg_kick_result_detail.Where(c => c.kick_result_id == kickResultId);
while (kickResultDetailItem.Count() > 0)
{
connect.preg_kick_result_detail.Remove(kickResultDetailItem.FirstOrDefault());
connect.SaveChanges();
}
dao.DeleteData(items.FirstOrDefault());
IQueryable <preg_kick_result> kickResultItem = connect.preg_kick_result.Where(c => c.id == kickResultId);
while (kickResultItem.Count() > 0)
{
connect.preg_kick_result.Remove(kickResultItem.FirstOrDefault());
connect.SaveChanges();
}
}
return(Request.CreateResponse(HttpStatusCode.Accepted, SysConst.DATA_DELETE_SUCCESS));
}
catch (Exception ex)
{
HttpError err = new HttpError(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err));
}
}
public bool DeleteReferenceData(int user_id)
{
try
{
PregnancyEntity connect = new PregnancyEntity();
preg_user user = connect.preg_user.Where(c => c.id == user_id).FirstOrDefault();
while (user.preg_answer.Count() > 0)
{
connect.preg_answer.Remove(user.preg_answer.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_appointment.Count() > 0)
{
preg_appointment appointment = user.preg_appointment.FirstOrDefault();
while (appointment.preg_appointment_measurement.Count() > 0)
{
connect.preg_appointment_measurement.Remove(appointment.preg_appointment_measurement.FirstOrDefault());
connect.SaveChanges();
}
connect.preg_appointment.Remove(user.preg_appointment.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_auth.Count() > 0)
{
connect.preg_auth.Remove(user.preg_auth.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_contact_us.Count() > 0)
{
connect.preg_contact_us.Remove(user.preg_contact_us.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_contraction.Count() > 0)
{
connect.preg_contraction.Remove(user.preg_contraction.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_customer_response.Count() > 0)
{
connect.preg_customer_response.Remove(user.preg_customer_response.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_customer_response1.Count() > 0)
{
connect.preg_customer_response.Remove(user.preg_customer_response1.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_daily_interact.Count() > 0)
{
connect.preg_daily_interact.Remove(user.preg_daily_interact.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_my_birth_plan.Count() > 0)
{
connect.preg_my_birth_plan.Remove(user.preg_my_birth_plan.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_my_birth_plan_item.Count() > 0)
{
connect.preg_my_birth_plan_item.Remove(user.preg_my_birth_plan_item.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_my_weight.Count() > 0)
{
connect.preg_my_weight.Remove(user.preg_my_weight.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_phone.Count() > 0)
{
connect.preg_phone.Remove(user.preg_phone.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_pregnancy.Count() > 0)
{
connect.preg_pregnancy.Remove(user.preg_pregnancy.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_profession.Count() > 0)
{
connect.preg_profession.Remove(user.preg_profession.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_question.Count() > 0)
{
connect.preg_question.Remove(user.preg_question.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_setting.Count() > 0)
{
connect.preg_setting.Remove(user.preg_setting.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_upgrade.Count() > 0)
{
connect.preg_upgrade.Remove(user.preg_upgrade.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_weekly_interact.Count() > 0)
{
connect.preg_weekly_interact.Remove(user.preg_weekly_interact.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_user_baby_name.Count() > 0)
{
connect.preg_user_baby_name.Remove(user.preg_user_baby_name.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_user_hospital_bag_item.Count() > 0)
{
connect.preg_user_hospital_bag_item.Remove(user.preg_user_hospital_bag_item.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_hospital_bag_item.Count() > 0)
{
connect.preg_hospital_bag_item.Remove(user.preg_hospital_bag_item.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_my_belly.Count() > 0)
{
connect.preg_my_belly.Remove(user.preg_my_belly.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_user_kick_history.Count() > 0)
{
connect.preg_user_kick_history.Remove(user.preg_user_kick_history.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_user_medical_service_package.Count() > 0)
{
connect.preg_user_medical_service_package.Remove(user.preg_user_medical_service_package.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_user_shopping_cart.Count() > 0)
{
connect.preg_user_shopping_cart.Remove(user.preg_user_shopping_cart.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_shopping_item.Count() > 0)
{
connect.preg_shopping_item.Remove(user.preg_shopping_item.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_user_todo.Count() > 0)
{
connect.preg_user_todo.Remove(user.preg_user_todo.FirstOrDefault());
connect.SaveChanges();
}
while (user.preg_todo.Count() > 0)
{
connect.preg_todo.Remove(user.preg_todo.FirstOrDefault());
connect.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public HelpCategoryDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public MyBirthPlanItemDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public MyWeightUnitDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public UserDao()
{
connect = new PregnancyEntity();
}
public UserShoppingCartDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public CustomerResponseDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public async Task <HttpResponseMessage> UploadRoot(int month)
{
string dir = "/Files/MyBellies/" + month.ToString();
string dirRoot = HttpContext.Current.Server.MapPath(dir);
// Check if request contains multipart/form-data
if (!Request.Content.IsMimeMultipartContent())
{
throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
}
// Check if directory folder created
if (!Directory.Exists(dirRoot))
{
Directory.CreateDirectory(dirRoot);
}
// Check if image and html filetype
for (int i = 0; i < HttpContext.Current.Request.Files.Count; i++)
{
HttpPostedFile file = HttpContext.Current.Request.Files[i];
if (!SysConst.imgOnlyExtensions.Any(x => x.Equals(Path.GetExtension(file.FileName.ToLower()), StringComparison.OrdinalIgnoreCase)))
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, SysConst.INVALID_FILE_TYPE));
}
else if (File.Exists(dirRoot + "/" + file.FileName))
{
File.Delete(dirRoot + "/" + file.FileName);
}
}
CustomMultipartFormDataStreamProvider provider = new CustomMultipartFormDataStreamProvider(dirRoot);
List <string> files = new List <string>();
try
{
// Read all contents of multipart message into CustomMultipartFormDataStreamProvider.
await Request.Content.ReadAsMultipartAsync(provider);
// Update to database
preg_my_belly updateRow = new preg_my_belly();
updateRow.month = month;
updateRow.user_id = null;
using (PregnancyEntity connect = new PregnancyEntity())
{
preg_my_belly chkRowExist = connect.preg_my_belly.Where(c => c.month == month).FirstOrDefault();
if (chkRowExist == null)
{
dao.InsertData(updateRow);
}
}
updateRow = dao.GetItemsByParams(updateRow).FirstOrDefault();
foreach (MultipartFileData file in provider.FileData)
{
string path = dir + "/" + HttpUtility.UrlPathEncode(Path.GetFileName(file.LocalFileName));
files.Add(path);
updateRow.image = path;
}
dao.UpdateData(updateRow);
//UpdateData(updateRow.id, updateRow.month.ToString(), updateRow);
return(Request.CreateResponse(HttpStatusCode.Created, files));
}
catch (System.Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
/// <summary>
/// Validate provided username and password when the grant_type is set to "password".
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
if (context.OwinContext.Request.Headers["Provider"] != null)
{
if (context.OwinContext.Request.Headers["Provider"].ToLower() == "facebook" && context.OwinContext.Request.Headers["access_token"] != null)
{
var accessToken = context.OwinContext.Request.Headers["access_token"];
var client = new RestClient("https://graph.facebook.com/");
var request = new RestRequest("me", Method.GET);
request.AddQueryParameter("fields", "id,name,email,picture.width(2000).height(2000)");
request.AddQueryParameter("access_token", accessToken);
var response = client.Execute(request);
if (response.StatusCode == HttpStatusCode.OK)
{
var content = JObject.Parse(response.Content);
var userInfo = new FacebookUserInfo()
{
id = content["id"].ToString()
};
if (content["name"] != null)
{
userInfo.name = content["name"].ToString();
}
if (content["email"] != null)
{
userInfo.email = content["email"].ToString();
}
if (content["picture"]["data"]["url"] != null)
{
userInfo.avatar = content["picture"]["data"]["url"].ToString();
}
PregnancyEntity connect = new PregnancyEntity();
preg_user user = connect.preg_user.Where(c => c.uid == userInfo.id && c.social_type_id == (int)SysConst.SocialTypes.facebook).FirstOrDefault();
if (user != null)
{
//user.email = userInfo.email;
//user.first_name = userInfo.name;
user.time_last_login = DateTime.Now;
connect.SaveChanges();
}
else
{
user = new preg_user();
user.uid = userInfo.id;
user.email = userInfo.email;
user.first_name = userInfo.name;
user.avatar = userInfo.avatar;
user.social_type_id = (int)SysConst.SocialTypes.facebook;
user.time_created = DateTime.Now;
connect.preg_user.Add(user);
SysMethod.createAccountNop(user);
connect.SaveChanges();
user = connect.preg_user.Where(c => c.uid == userInfo.id && c.social_type_id == (int)SysConst.SocialTypes.facebook).FirstOrDefault();
}
preg_auth auth = connect.preg_auth.Where(c => c.user_id == user.id).FirstOrDefault();
if (auth == null)
{
auth = new preg_auth()
{
user_id = user.id
};
connect.preg_auth.Add(auth);
}
auth.token = context.OwinContext.Request.Headers["access_token"];
connect.SaveChanges();
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.social.ToString()));
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.user.ToString()));
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.dev.ToString()));
identity.AddClaim(new Claim("id", user.id.ToString()));
context.Validated(identity);
}
else
{
context.SetError("Invalid grant", SysConst.LOGIN_SOCIAL_FAILED);
return;
}
}
else if (context.OwinContext.Request.Headers["Provider"].ToLower() == "google" && context.OwinContext.Request.Headers["access_token"] != null)
{
var accessToken = context.OwinContext.Request.Headers["access_token"];
var client = new RestClient("https://www.googleapis.com/oauth2/v3/");
var request = new RestRequest("tokeninfo", Method.GET);
request.AddQueryParameter("id_token", accessToken);
var response = client.Execute(request);
if (response.StatusCode == HttpStatusCode.OK)
{
var content = JObject.Parse(response.Content);
var userInfo = new GoogleUserInfo()
{
sub = content["sub"].ToString()
};
if (content["name"] != null)
{
userInfo.name = content["name"].ToString();
}
if (content["email"] != null)
{
userInfo.email = content["email"].ToString();
}
if (content["picture"] != null)
{
userInfo.picture = content["picture"].ToString();
}
if (content["given_name"] != null)
{
userInfo.given_name = content["given_name"].ToString();
}
if (content["family_name"] != null)
{
userInfo.family_name = content["family_name"].ToString();
}
PregnancyEntity connect = new PregnancyEntity();
preg_user user = connect.preg_user.Where(c => c.uid == userInfo.sub && c.social_type_id == (int)SysConst.SocialTypes.google).FirstOrDefault();
if (user != null)
{
//user.email = userInfo.email;
//user.first_name = userInfo.name;
//user.avatar = userInfo.picture;
user.time_last_login = DateTime.Now;
connect.SaveChanges();
}
else
{
user = new preg_user();
user.uid = userInfo.sub;
user.email = userInfo.email;
user.first_name = userInfo.name;
user.avatar = userInfo.picture;
user.social_type_id = (int)SysConst.SocialTypes.google;
user.time_created = DateTime.Now;
connect.preg_user.Add(user);
SysMethod.createAccountNop(user);
connect.SaveChanges();
user = connect.preg_user.Where(c => c.uid == userInfo.sub && c.social_type_id == (int)SysConst.SocialTypes.google).FirstOrDefault();
}
preg_auth auth = connect.preg_auth.Where(c => c.user_id == user.id).FirstOrDefault();
if (auth == null)
{
auth = new preg_auth()
{
user_id = user.id
};
connect.preg_auth.Add(auth);
}
auth.token = context.OwinContext.Request.Headers["access_token"];
connect.SaveChanges();
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.social.ToString()));
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.user.ToString()));
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.dev.ToString()));
identity.AddClaim(new Claim("id", user.id.ToString()));
context.Validated(identity);
}
else
{
var client2 = new RestClient("https://www.googleapis.com/oauth2/v1/");
var request2 = new RestRequest("userinfo", Method.GET);
request2.AddQueryParameter("alt", "json");
request2.AddQueryParameter("access_token", accessToken);
var response2 = client.Execute(request2);
if (response2.StatusCode == HttpStatusCode.OK)
{
var content = JObject.Parse(response2.Content);
var userInfo = new GoogleUserInfo()
{
sub = content["sub"].ToString()
};
if (content["name"] != null)
{
userInfo.name = content["name"].ToString();
}
if (content["email"] != null)
{
userInfo.email = content["email"].ToString();
}
if (content["picture"] != null)
{
userInfo.picture = content["picture"].ToString();
}
if (content["given_name"] != null)
{
userInfo.given_name = content["given_name"].ToString();
}
if (content["family_name"] != null)
{
userInfo.family_name = content["family_name"].ToString();
}
PregnancyEntity connect = new PregnancyEntity();
preg_user user = connect.preg_user.Where(c => c.uid == userInfo.sub && c.social_type_id == (int)SysConst.SocialTypes.google).FirstOrDefault();
if (user != null)
{
//user.email = userInfo.email;
//user.first_name = userInfo.name;
//user.avatar = userInfo.picture;
user.time_last_login = DateTime.Now;
connect.SaveChanges();
}
else
{
user = new preg_user();
user.uid = userInfo.sub;
user.email = userInfo.email;
user.first_name = userInfo.name;
user.avatar = userInfo.picture;
user.social_type_id = (int)SysConst.SocialTypes.google;
user.time_created = DateTime.Now;
connect.preg_user.Add(user);
SysMethod.createAccountNop(user);
connect.SaveChanges();
user = connect.preg_user.Where(c => c.uid == userInfo.sub && c.social_type_id == (int)SysConst.SocialTypes.google).FirstOrDefault();
}
preg_auth auth = connect.preg_auth.Where(c => c.user_id == user.id).FirstOrDefault();
if (auth == null)
{
auth = new preg_auth()
{
user_id = user.id
};
connect.preg_auth.Add(auth);
}
auth.token = context.OwinContext.Request.Headers["access_token"];
connect.SaveChanges();
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.social.ToString()));
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.user.ToString()));
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.dev.ToString()));
identity.AddClaim(new Claim("id", user.id.ToString()));
context.Validated(identity);
}
else
{
context.SetError("Invalid grant", SysConst.LOGIN_SOCIAL_FAILED);
return;
}
}
}
}
else if (context.UserName != null && context.Password != null)
{
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
PregnancyEntity connect = new PregnancyEntity();
UserDao dao = new UserDao();
//Check username & password
string phone = context.UserName;
string password = SysMethod.MD5Hash(context.Password);
preg_user user = connect.preg_user.Where(c => c.phone == phone && c.password == password).FirstOrDefault();
if (user != null)
{
user.time_last_login = DateTime.Now;
connect.SaveChanges();
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.dev.ToString()));
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.user.ToString()));
identity.AddClaim(new Claim("id", user.id.ToString()));
context.Validated(identity);
}
else if (context.UserName == "WSPadmin" && context.Password == "WSPadmin")
{
identity.AddClaim(new Claim(ClaimTypes.Role, SysConst.UserType.admin.ToString()));
identity.AddClaim(new Claim("id", "0"));
context.Validated(identity);
}
else
{
context.SetError("Invalid grant", SysConst.LOGIN_FAILED);
return;
}
}
}
public UserKickHistoryDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public AppointmentTypeDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public WeeklyInteractDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public AuthDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public HospitalBagItemDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public KickResultDetailDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public MedicalServicePackageDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public UserBabyNameDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
public ProfessionTypeDao()
{
connect = new PregnancyEntity();
connect.Configuration.ProxyCreationEnabled = false;
}
