public ActionResult _Details(int id)
{
MemberViewModel model = new MemberViewModel();
radioclubEntities _entities = new radioclubEntities();
var data = _entities.member_update.Where(x => x.member_id == id).FirstOrDefault();
if (data != null)
{
model.member_id = data.member_id;
model.membership_no = data.membership_no;
model.first_name = data.first_name;
model.middle_name = data.middle_name;
model.last_name = data.last_name;
model.dob = data.dob;
model.persent_merital_status = data.persent_merital_status;
model.marriage_date = data.marriage_date;
model.nationality = data.nationality;
model.occupation = data.occupation;
model.divorce_date = data.divorce_date;
model.pancard = data.pancard;
model.aadharcard = data.aadharcard;
model.spouse_full_name = data.spouse_full_name;
model.spouse_dob = data.spouse_dob;
model.spouse_nationality = data.spouse_nationality;
model.spouse_occupation = data.spouse_occupation;
model.spouse_pancard = data.spouse_pancard;
model.spouse_aadharcard = data.spouse_aadharcard;
model.residential_address = data.residential_address;
model.residential_pincode = data.residential_pincode;
model.company_name = data.company_name;
model.business_type = data.business_type;
model.position_held = data.position_held;
model.office_address = data.office_address;
model.office_pincode = data.office_pincode;
model.office_telep = data.office_telep;
model.residential_tele = data.residential_tele;
model.mobile_no = data.mobile_no;
model.fax_no = data.fax_no;
model.email_id = data.email_id;
model.communi_by_email = data.communi_by_email;
model.device_info = data.device_info;
model.ipaddress = data.ipaddress;
model.member_image = data.member_image;
model.spouse_image = data.spouse_image;
model.marriage_certi_img = data.marriage_certi_img;
model.member_pan_image = data.member_pan_image;
model.spouse_pan_img = data.spouse_pan_img;
model.member_aadhar_img = data.member_aadhar_img;
model.spouse_aadhar_img = data.spouse_aadhar_img;
model.member_passport_img = data.member_passport_img;
model.spouse_passport_img = data.spouse_passport_img;
model.spouse_passport_img = data.spouse_passport_img;
model.spouse_passport_img = data.spouse_passport_img;
//record_date = data.record_date;
model.child_info = data.child_info;
}
;
return(View(model));
}
public ActionResult GetMemberInfo(string membership_no, string pan_card)
{
MemberViewModel model = new MemberViewModel();
radioclubEntities _entities = new radioclubEntities();
var data = _entities.member_info.Where(x => x.membership_no.ToLower() == membership_no.ToLower())
.Where(x => x.pan_card.ToLower() == pan_card.ToLower()).FirstOrDefault();
if (data != null)
{
model.membership_no = data.membership_no;
model.pancard = data.pan_card;
return(View("Create", model));
}
else
{
TempData["UserMessage"] = new { CssClassName = "alert-sucess", Title = "Error!", Message = "Please choose another values." };
//ViewBag.GetMemberInfoError = "";
return(View("Index", "Home", model));
}
}
public ActionResult Processed(int id, string processed_by)
{
try
{
radioclubEntities _entities = new radioclubEntities();
member_update entititySetup = new member_update {
member_id = id
};
var user = _entities.member_update.Find(id);
user.processed_by = processed_by;
user.processed_on = DateTime.Now;
user.data_processed = 1;
_entities.Entry(user).State = EntityState.Modified;
_entities.SaveChanges();
TempData["ResDataProcessed"] = "Data Processed Successfully!";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
string err = ex.Message + "....." + ex.StackTrace;
return(View());
}
}
public ActionResult GetMemberInfo(string membership_no, string pan_card)
{
MemberViewModel model = new MemberViewModel();
member_info _model = new member_info();
radioclubEntities _entities = new radioclubEntities();
var data = _entities.member_info.Where(x => x.membership_no.ToLower() == membership_no.ToLower())
.Where(x => x.pan_card.ToLower() == pan_card.ToLower()).FirstOrDefault();
if (data != null)
{
model.MemberViewModelList = (from s in _entities.member_update
where s.pancard == data.pan_card
where s.membership_no == data.membership_no
select new MemberViewModel
{
member_id = s.member_id,
membership_no = s.membership_no,
first_name = s.first_name,
middle_name = s.middle_name,
last_name = s.last_name,
dob = s.dob,
persent_merital_status = s.persent_merital_status,
marriage_date = s.marriage_date,
nationality = s.nationality,
occupation = s.occupation,
divorce_date = s.divorce_date,
pancard = s.pancard,
aadharcard = s.aadharcard,
spouse_full_name = s.spouse_full_name,
spouse_dob = s.spouse_dob,
spouse_nationality = s.spouse_nationality,
spouse_occupation = s.spouse_occupation,
spouse_pancard = s.spouse_pancard,
spouse_aadharcard = s.spouse_aadharcard,
residential_address = s.residential_address,
residential_pincode = s.residential_pincode,
company_name = s.company_name,
business_type = s.business_type,
position_held = s.position_held,
office_address = s.office_address,
office_pincode = s.office_pincode,
office_telep = s.office_telep,
residential_tele = s.residential_tele,
mobile_no = s.mobile_no,
fax_no = s.fax_no,
email_id = s.email_id,
communi_by_email = s.communi_by_email,
device_info = s.device_info,
ipaddress = s.ipaddress,
member_image = s.member_image,
spouse_image = s.spouse_image,
marriage_certi_img = s.marriage_certi_img,
member_pan_image = s.member_pan_image,
spouse_pan_img = s.spouse_pan_img,
member_aadhar_img = s.member_aadhar_img,
spouse_aadhar_img = s.spouse_aadhar_img,
member_passport_img = s.member_passport_img,
spouse_passport_img = s.spouse_passport_img,
divorce_certi_image = s.divorce_certi_image,
record_date = s.record_date,
spouse_sign = s.spouse_sign,
member_sign = s.member_sign,
processed_by = s.processed_by,
data_processed = s.data_processed,
processed_on = s.processed_on,
child_info = s.child_info
}).ToList();
if (model.MemberViewModelList.Count > 0)
{
return(PartialView("_ListDetails", model));
}
else
{
model.membership_no = data.membership_no;
model.pancard = data.pan_card;
_model.membership_no = data.membership_no;
_model.pan_card = data.pan_card;
return(PartialView("_Create", model));
}
}
else
{
TempData["cssClass"] = "alert-danger";
TempData["UserMessage"] = "Your Membership Id or Pan Card is incorrect. If you don't remember contact admin.";
return(View("Index", _model));
}
}
public ActionResult Create(MemberViewModel model)
{
try
{
//string hostName = Dns.GetHostName();
//string myIP = Dns.GetHostByName(hostName).AddressList[0].ToString();
string myIP = GetIPAddress();
if (ModelState.IsValid)
{
radioclubEntities _entities = new radioclubEntities();
member_update entititySetup = new member_update();
entititySetup.membership_no = model.membership_no;
entititySetup.first_name = model.first_name;
entititySetup.middle_name = model.middle_name;
entititySetup.last_name = model.last_name;
entititySetup.dob = model.dob;
entititySetup.persent_merital_status = model.persent_merital_status;
entititySetup.marriage_date = model.marriage_date;
entititySetup.nationality = model.nationality;
entititySetup.occupation = model.occupation;
entititySetup.divorce_date = model.divorce_date;
entititySetup.pancard = model.pancard;
entititySetup.aadharcard = model.aadharcard;
entititySetup.spouse_full_name = model.spouse_full_name;
entititySetup.spouse_dob = model.spouse_dob;
entititySetup.spouse_nationality = model.spouse_nationality;
entititySetup.spouse_occupation = model.spouse_occupation;
entititySetup.spouse_pancard = model.spouse_pancard;
entititySetup.spouse_aadharcard = model.spouse_aadharcard;
entititySetup.residential_address = model.residential_address;
entititySetup.residential_pincode = model.residential_pincode;
entititySetup.company_name = model.company_name;
entititySetup.business_type = model.business_type;
entititySetup.position_held = model.position_held;
entititySetup.office_address = model.office_address;
entititySetup.office_pincode = model.office_pincode;
entititySetup.office_telep = model.office_telep;
entititySetup.residential_tele = model.residential_tele;
entititySetup.mobile_no = model.mobile_no;
entititySetup.fax_no = model.fax_no;
entititySetup.email_id = model.email_id;
entititySetup.communi_by_email = model.communi_by_email;
entititySetup.device_info = model.device_info;
entititySetup.ipaddress = myIP;
entititySetup.member_image = model.member_image;
entititySetup.spouse_image = model.spouse_image;
entititySetup.marriage_certi_img = model.marriage_certi_img;
entititySetup.member_pan_image = model.member_pan_image;
entititySetup.spouse_pan_img = model.spouse_pan_img;
entititySetup.member_aadhar_img = model.member_aadhar_img;
entititySetup.spouse_aadhar_img = model.spouse_aadhar_img;
entititySetup.member_passport_img = model.member_passport_img;
entititySetup.spouse_passport_img = model.spouse_passport_img;
entititySetup.record_date = DateTime.Now;
entititySetup.member_sign = model.member_sign;
entititySetup.spouse_sign = model.spouse_sign;
entititySetup.divorce_certi_image = model.divorce_certi_image;
entititySetup.child_info = model.child_info;
_entities.Entry(entititySetup).State = EntityState.Added;
_entities.SaveChanges();
TempData["ResponseCssClass"] = "alert-success";
TempData["ResponseMessage"] = "Your request for updation of data is received.";
//return RedirectToAction("GetMemberInfo");
return(RedirectToAction("GetMemberInfo", new
{
membership_no = model.membership_no,
pan_card = model.pancard
}));
}
else
{
return(PartialView("_Create", model));
}
}
catch (Exception ex)
{
string error = ex.Message;
return(PartialView("_Create", model));
}
}
public ActionResult _ProcessedTokens()
{
//var result = context.YourEntityName.Where(entry => entry.DateField >= minDate
// && entry.DateField <= maxDate).ToList();
MemberViewModel model = new MemberViewModel();
radioclubEntities _entities = new radioclubEntities();
model.MemberViewModelList = (from s in _entities.member_update.Where(x => x.data_processed == 1)
select new MemberViewModel
{
member_id = s.member_id,
membership_no = s.membership_no,
first_name = s.first_name,
middle_name = s.middle_name,
last_name = s.last_name,
dob = s.dob,
persent_merital_status = s.persent_merital_status,
marriage_date = s.marriage_date,
nationality = s.nationality,
occupation = s.occupation,
divorce_date = s.divorce_date,
pancard = s.pancard,
aadharcard = s.aadharcard,
spouse_full_name = s.spouse_full_name,
spouse_dob = s.spouse_dob,
spouse_nationality = s.spouse_nationality,
spouse_occupation = s.spouse_occupation,
spouse_pancard = s.spouse_pancard,
spouse_aadharcard = s.spouse_aadharcard,
residential_address = s.residential_address,
residential_pincode = s.residential_pincode,
company_name = s.company_name,
business_type = s.business_type,
position_held = s.position_held,
office_address = s.office_address,
office_pincode = s.office_pincode,
office_telep = s.office_telep,
residential_tele = s.residential_tele,
mobile_no = s.mobile_no,
fax_no = s.fax_no,
email_id = s.email_id,
communi_by_email = s.communi_by_email,
device_info = s.device_info,
ipaddress = s.ipaddress,
member_image = s.member_image,
spouse_image = s.spouse_image,
marriage_certi_img = s.marriage_certi_img,
member_pan_image = s.member_pan_image,
spouse_pan_img = s.spouse_pan_img,
member_aadhar_img = s.member_aadhar_img,
spouse_aadhar_img = s.spouse_aadhar_img,
member_passport_img = s.member_passport_img,
spouse_passport_img = s.spouse_passport_img,
member_sign = s.member_sign,
spouse_sign = s.spouse_sign,
divorce_certi_image = s.divorce_certi_image,
record_date = s.record_date,
data_processed = s.data_processed,
processed_by = s.processed_by,
processed_on = s.processed_on,
child_info = s.child_info
}).ToList();
return(View(model));
}
public ActionResult Export()
{
MemberViewModel model = new MemberViewModel();
radioclubEntities _entities = new radioclubEntities();
var dataCollection = (from s in _entities.member_update.Where(x => x.data_processed == 0)
select new MemberViewModel
{
member_id = s.member_id,
membership_no = s.membership_no,
first_name = s.first_name,
middle_name = s.middle_name,
last_name = s.last_name,
dob = s.dob,
persent_merital_status = s.persent_merital_status,
marriage_date = s.marriage_date,
nationality = s.nationality,
occupation = s.occupation,
divorce_date = s.divorce_date,
pancard = s.pancard,
aadharcard = s.aadharcard,
spouse_full_name = s.spouse_full_name,
spouse_dob = s.spouse_dob,
spouse_nationality = s.spouse_nationality,
spouse_occupation = s.spouse_occupation,
spouse_pancard = s.spouse_pancard,
spouse_aadharcard = s.spouse_aadharcard,
residential_address = s.residential_address,
residential_pincode = s.residential_pincode,
company_name = s.company_name,
business_type = s.business_type,
position_held = s.position_held,
office_address = s.office_address,
office_pincode = s.office_pincode,
office_telep = s.office_telep,
residential_tele = s.residential_tele,
mobile_no = s.mobile_no,
fax_no = s.fax_no,
email_id = s.email_id,
communi_by_email = s.communi_by_email,
device_info = s.device_info,
ipaddress = s.ipaddress,
member_image = s.member_image,
spouse_image = s.spouse_image,
marriage_certi_img = s.marriage_certi_img,
member_pan_image = s.member_pan_image,
spouse_pan_img = s.spouse_pan_img,
member_aadhar_img = s.member_aadhar_img,
spouse_aadhar_img = s.spouse_aadhar_img,
member_passport_img = s.member_passport_img,
spouse_passport_img = s.spouse_passport_img,
member_sign = s.member_sign,
spouse_sign = s.spouse_sign,
divorce_certi_image = s.divorce_certi_image,
record_date = s.record_date,
data_processed = s.data_processed,
child_info = s.child_info
}).ToList();
var gv = new GridView();
gv.DataSource = dataCollection;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=DemoExcel.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter objStringWriter = new StringWriter();
HtmlTextWriter objHtmlTextWriter = new HtmlTextWriter(objStringWriter);
gv.RenderControl(objHtmlTextWriter);
Response.Output.Write(objStringWriter.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Index", "Admin"));
}
public ActionResult Create(MemberViewModel model)
{
//string hostName = Dns.GetHostName();
//string myIP = Dns.GetHostByName(hostName).AddressList[0].ToString();
string myIP = GetIPAddress();
//model.child_info.Add(new child_info()
//{
//});
if (ModelState.IsValid)
{
radioclubEntities _entities = new radioclubEntities();
member_update entititySetup = new member_update();
entititySetup.membership_no = model.membership_no;
entititySetup.first_name = model.first_name;
entititySetup.middle_name = model.middle_name;
entititySetup.last_name = model.last_name;
entititySetup.dob = model.dob;
entititySetup.persent_merital_status = model.persent_merital_status;
entititySetup.marriage_date = model.marriage_date;
entititySetup.nationality = model.nationality;
entititySetup.occupation = model.occupation;
entititySetup.divorce_date = model.divorce_date;
entititySetup.pancard = model.pancard;
entititySetup.aadharcard = model.aadharcard;
entititySetup.spouse_full_name = model.spouse_full_name;
entititySetup.spouse_dob = model.spouse_dob;
entititySetup.spouse_nationality = model.spouse_nationality;
entititySetup.spouse_occupation = model.spouse_occupation;
entititySetup.spouse_pancard = model.spouse_pancard;
entititySetup.spouse_aadharcard = model.spouse_aadharcard;
entititySetup.residential_address = model.residential_address;
entititySetup.residential_pincode = model.residential_pincode;
entititySetup.company_name = model.company_name;
entititySetup.business_type = model.business_type;
entititySetup.position_held = model.position_held;
entititySetup.office_address = model.office_address;
entititySetup.office_pincode = model.office_pincode;
entititySetup.office_telep = model.office_telep;
entititySetup.residential_tele = model.residential_tele;
entititySetup.mobile_no = model.mobile_no;
entititySetup.fax_no = model.fax_no;
entititySetup.email_id = model.email_id;
entititySetup.communi_by_email = model.communi_by_email;
entititySetup.device_info = model.device_info;
entititySetup.ipaddress = myIP;
entititySetup.member_image = model.member_image;
entititySetup.spouse_image = model.spouse_image;
entititySetup.marriage_certi_img = model.marriage_certi_img;
entititySetup.member_pan_image = model.member_pan_image;
entititySetup.spouse_pan_img = model.spouse_pan_img;
entititySetup.member_aadhar_img = model.member_aadhar_img;
entititySetup.spouse_aadhar_img = model.spouse_aadhar_img;
entititySetup.member_passport_img = model.member_passport_img;
entititySetup.spouse_passport_img = model.spouse_passport_img;
entititySetup.record_date = DateTime.Today;
entititySetup.child_info = model.child_info;
_entities.Entry(entititySetup).State = EntityState.Added;
_entities.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
