public static x_biodata getDataByKode(long id)
{
x_biodata data = new x_biodata();
using (DBSpecEntities db = new DBSpecEntities())
{
data = db.x_biodata.Where(a => a.id == id).FirstOrDefault();
}
return(data);
}
public static string CekTelp(string phone_number1)
{
using (DBSpecEntities db = new DBSpecEntities())
{
x_biodata dt = db.x_biodata.Where(a => a.phone_number1.Equals(phone_number1)).FirstOrDefault();
if (dt != null)
{
return("ada");
}
else
{
return("tidak ada");
}
}
}
//public static bool saveData(x_biodata bio)
//{
// try
// {
// using (DBSpecEntities db = new DBSpecEntities())
// {
// bio.created_by = 12;
// bio.created_on = System.DateTime.Now;
// bio.is_delete = false;
// db.x_biodata.Add(bio);
// db.SaveChanges();
// }
// return true;
// }
// catch (Exception)
// {
// return false;
// throw;
// }
//}
public static string CekEmail(string email)
{
using (DBSpecEntities db = new DBSpecEntities())
{
x_biodata dt = db.x_biodata.Where(a => a.email.Equals(email)).FirstOrDefault();
if (dt != null)
{
return("ada");
}
else
{
return("tidak ada");
}
}
}
public static string CekData(string searchString)
{
using (DBSpecEntities db = new DBSpecEntities())
{
x_biodata dt = db.x_biodata.Where(a => a.fullname.ToUpper().Contains(searchString.ToUpper())).FirstOrDefault();
if (dt != null)
{
return("ada");
}
else
{
return("tidak ada");
}
}
}
public static bool updateData(VMUndangan und)
{
try
{
using (DBSpecEntities db = new DBSpecEntities())
{
x_undangan dt = db.x_undangan.Where(a => a.id == und.id_undangan).FirstOrDefault();
dt.id = und.id_undangan;
dt.schedule_type_id = und.schedule_type_id;
dt.invitation_date = und.invitation_date;
//dt.invitation_code = und.invitation_code;
dt.time = und.time;
dt.ro = und.ro;
dt.tro = und.tro;
dt.other_ro_tro = und.other_ro_tro;
dt.location = und.location;
dt.modified_by = 12;
dt.modified_on = System.DateTime.Now;
db.Entry(dt).State = EntityState.Modified;
db.SaveChanges();
x_undangan_detail dt3 = db.x_undangan_detail.Where(a => a.undangan_id == und.undangandetail_id).FirstOrDefault();
//dt3.undangan_id = und.undangandetail_id;
//dt3.biodata_id = und.biodata_id;
dt3.notes = und.notes;
db.Entry(dt3).State = EntityState.Modified;
db.SaveChanges();
x_biodata dt4 = db.x_biodata.Where(a => a.id == und.biodata_id).FirstOrDefault();
dt4.fullname = und.fullname;
db.Entry(dt4).State = EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public static bool ExpDate(long id)
{
try
{
using (DBSpecEntities db = new DBSpecEntities())
{
x_biodata dtBio = getDataByKode(id);
//dtBio.expired_token =
db.Entry(dtBio).State = EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public static bool UpdateToken(x_biodata bio)
{
try
{
using (DBSpecEntities db = new DBSpecEntities())
{
x_biodata dtBio = db.x_biodata.Where(a => a.id == bio.id).FirstOrDefault();
dtBio.token = generateToken();
dtBio.expired_token = bio.expired_token;
db.Entry(dtBio).State = EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
//Delete
public static ResponseResult Delete(BiodataViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XContext())
{
x_biodata biodata = db.x_biodata
.Where(o => o.id == entity.Id)
.FirstOrDefault();
if (biodata != null)
{
biodata.delete_by = 1;
biodata.delete_on = DateTime.Now;
biodata.is_delete = true;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Data Not Found ! ";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
//Create and Update
public static ResponseResult Update(BiodataViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XContext())
{
#region Create New / Insert
if (entity.Id == 0)
{
x_biodata biodata = new x_biodata();
biodata.identity_number = entity.NPM;
biodata.fullname = entity.FullName;
biodata.pob = entity.Pob;
biodata.dob = entity.Dob;
biodata.gender = entity.Gender;
biodata.religion = entity.Religion;
biodata.email = entity.Email;
biodata.phone_number1 = entity.Phone_number;
biodata.faculty = entity.Faculty;
biodata.major = entity.Major;
biodata.is_delete = false;
biodata.created_by = 1;
biodata.created_on = DateTime.Now;
db.x_biodata.Add(biodata);
db.SaveChanges();
result.Entity = entity;
}
#endregion
#region Edit
else
{
x_biodata biodata = db.x_biodata
.Where(o => o.id == entity.Id)
.FirstOrDefault();
if (biodata != null)
{
biodata.identity_number = entity.NPM;
biodata.fullname = entity.FullName;
biodata.pob = entity.Pob;
biodata.dob = entity.Dob;
biodata.gender = entity.Gender;
biodata.religion = entity.Religion;
biodata.email = entity.Email;
biodata.phone_number1 = entity.Phone_number;
biodata.faculty = entity.Faculty;
biodata.major = entity.Major;
biodata.modified_by = 1;
biodata.modified_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Data Not Found ! ";
}
}
#endregion
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
//public static string CekNoIden(string identity_no)
//{
// using (DBSpecEntities db = new DBSpecEntities())
// {
// x_biodata dt = db.x_biodata.Where(a => a.identity_no.Equals(identity_no)).FirstOrDefault();
// if(dt!= null)
// {
// return "ada";
// }
// else
// {
// return "tidak ada";
// }
// }
//}
//public static string CekNoIden(string identity_no, int identity_type_id)
//{
// using (DBSpecEntities db = new DBSpecEntities())
// {
// x_biodata dt = db.x_biodata.Where(a => a.identity_no.Equals(identity_no)).FirstOrDefault();
// x_biodata dt2 = db.x_biodata.Where(b => b.identity_type_id.Equals(identity_type_id)).FirstOrDefault();
// if (dt != null)
// {
// if (dt2 != null)
// {
// return "ada";
// }
// }
// else
// {
// return "tidak ada";
// }
// }
//}
public static bool saveData(VMPelamar bio)
{
using (DBSpecEntities db = new DBSpecEntities())
{
try
{
x_biodata isibiodata = new x_biodata();
isibiodata.fullname = bio.fullname;
isibiodata.nick_name = bio.nick_name;
isibiodata.pob = bio.pob;
isibiodata.dob = bio.dob;
isibiodata.gender = bio.gender;
isibiodata.religion_id = bio.religion_id;
isibiodata.high = bio.high;
isibiodata.weight = bio.weight;
isibiodata.nationally = bio.nationally;
isibiodata.ethnic = bio.ethnic;
isibiodata.hobby = bio.hobby;
isibiodata.identity_type_id = bio.identity_type_id;
isibiodata.identity_no = bio.identity_no;
isibiodata.email = bio.email;
isibiodata.phone_number1 = bio.phone_number1;
isibiodata.phone_number2 = bio.phone_number2;
isibiodata.parent_phone_number = bio.parent_phone_number;
isibiodata.child_sequence = bio.child_sequence;
isibiodata.how_many_brothers = bio.how_many_brothers;
isibiodata.marital_status_id = bio.marital_status_id;
isibiodata.marriage_year = bio.marriage_year;
isibiodata.addrbook_id = bio.addrbook_id;
isibiodata.created_by = 12;
isibiodata.created_on = System.DateTime.Now;
isibiodata.is_delete = false;
db.x_biodata.Add(isibiodata);
db.SaveChanges();
x_address isiaddress = new x_address();
isiaddress.address1 = bio.address1;
isiaddress.address2 = bio.address2;
isiaddress.postal_code1 = bio.postal_code1;
isiaddress.postal_code2 = bio.postal_code2;
isiaddress.rt1 = bio.rt1;
isiaddress.rt2 = bio.rt2;
isiaddress.rw1 = bio.rw1;
isiaddress.rw2 = bio.rw2;
isiaddress.kecamatan1 = bio.kecamatan1;
isiaddress.kecamatan2 = bio.kecamatan2;
isiaddress.kelurahan1 = bio.kelurahan1;
isiaddress.kelurahan2 = bio.kelurahan2;
isiaddress.region1 = bio.region1;
isiaddress.region2 = bio.region2;
isiaddress.biodata_id = isibiodata.id;
isiaddress.created_by = 123;
isiaddress.created_on = System.DateTime.Now;
//isiaddress.deleted_by = 123;
//isiaddress.deleted_on = System.DateTime.Now;
//isiaddress.modified_by = 123;
//isiaddress.modified_on = System.DateTime.Now;
isiaddress.is_delete = false;
db.x_address.Add(isiaddress);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
}
