public void BindDoctor(DataAccessEntities Slist)
{
try
{
ds = null;
objDAEntities.DoctorId = 0;
ds = (DataSet)objBusinessLogic.GetDoctorDetails(objDAEntities.DoctorId);
if (ds.Tables[0].Rows.Count == 0)
{
lblempty.Visible = true;
dgDoctor.Visible = false;
}
else
{
lblempty.Visible = false;
dgDoctor.Visible = true;
dgDoctor.DataSource = ds;
dgDoctor.DataBind();
}
}
catch (Exception ex)
{
}
}
public string SaveUrun(ent_URUNLER ent)
{
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
l_urunler urun = new l_urunler();
if (ent.urun_id != 0)
{
urun = db.l_urunler.Where(p => p.urun_id == ent.urun_id).First();
}
urun.urun_adi = ent.urun_adi;
urun.urun_kategori_id = ent.urun_kategori_id;
urun.urun_fiyat = ent.urun_fiyat;
urun.urun_detay = ent.urun_detay.ToString();
urun.urun_foto_url = ent.urun_foto_url;
urun.urun_uye_id = ent.urun_uye_id;
urun.urun_tarih = ent.urun_tarih;
urun.urun_ispassive = ent.urun_ispassive;
if (ent.urun_id == 0)
{
db.l_urunler.Add(urun);
}
db.SaveChanges();
}
return("success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string SaveKategori(ent_KATEGORI ent)
{
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
l_kategori kategori = new l_kategori();
if (ent.kategori_id != 0)
{
kategori = db.l_kategori.Where(p => p.kategori_id == ent.kategori_id).First();
}
kategori.kategori_ad = ent.kategori_ad;
if (ent.kategori_id == 0)
{
db.l_kategori.Add(kategori);
}
db.SaveChanges();
}
return("success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string SaveAdmin(ent_ADMIN ent)
{
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
l_admin admin = new l_admin();
if (ent.adm_id != 0)
{
admin = db.l_admin.Where(p => p.adm_id == ent.adm_id).First();
}
admin.adm_ispassive = ent.adm_ispassive;
admin.adm_kullanici_adi = ent.adm_kullanici_adi;
admin.adm_name = ent.adm_name;
admin.adm_sifre = ent.adm_sifre;
if (ent.adm_id == 0)
{
db.l_admin.Add(admin);
}
db.SaveChanges();
}
return("success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public void BindNews(DataAccessEntities Slist)
{
try
{
objDAEntities.NewId = 0;
DataSet ds = new DataSet();
objDAEntities.IsActive = false;
ds = (DataSet)objBusinessLogic.GetNewsDetails(objDAEntities);
if (ds.Tables[0].Rows.Count == 0)
{
//Bind your grid here
lblempty.Visible = true;
dgNews.Visible = false;
}
else
{
lblempty.Visible = false;
dgNews.Visible = true;
dgNews.DataSource = ds;
dgNews.DataBind();
}
}
catch (Exception ex)
{
}
}
public string SaveUyeler(ent_UYELER ent)
{
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
l_uyeler uyeler = new l_uyeler();
if (ent.uye_id != 0)
{
uyeler = db.l_uyeler.Where(p => p.uye_id == ent.uye_id).First();
}
uyeler.uye_ad_soyad = ent.uye_ad_soyad;
uyeler.uye_kullanici_adi = ent.uye_kullanici_adi;
uyeler.uye_sifre = ent.uye_sifre;
uyeler.uye_foto_url = ent.uye_foto_url;
uyeler.uye_detay = ent.uye_detay;
uyeler.uye_kayit_tarihi = ent.uye_kayit_tarihi;
uyeler.uye_telefon = ent.uye_telefon;
uyeler.uye_mail = ent.uye_mail;
uyeler.uye_ispassive = ent.uye_ispassive;
if (ent.uye_id == 0)
{
db.l_uyeler.Add(uyeler);
}
db.SaveChanges();
}
return("success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ent_URUNLER SelectUrun(int urun_id)
{
ent_URUNLER result = new ent_URUNLER();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_URUNLER>("select * from l_urunler as urun where urun.urun_id={0}", urun_id).First();
}
return(result);
}
catch
{
return(result);
}
}
public List <ent_URUNLER> UrunListele_By_Ktgid(int ktg_id)
{
List <ent_URUNLER> result = new List <ent_URUNLER>();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_URUNLER>("SELECT urun.urun_adi,kat.kategori_ad as urun_kategori_adi, uye.uye_ad_soyad as urun_uye_adi,urun.urun_detay,urun.urun_foto_url,urun.urun_tarih,urun.* FROM l_urunler as urun LEFT JOIN l_kategori as kat ON urun.urun_kategori_id = kat.kategori_id LEFT JOIN l_uyeler as uye ON uye.uye_id = urun.urun_uye_id where urun.urun_kategori_id={0} order by urun.urun_tarih desc", ktg_id).ToList();
}
return(result);
}
catch (Exception)
{
return(result);
}
}
public ent_URUNLER UrunGoruntule(int urun_id)
{
ent_URUNLER result = new ent_URUNLER();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_URUNLER>("select urun.urun_adi,kat.kategori_ad as urun_kategori_adi, uye.uye_ad_soyad as urun_uye_adi,urun.urun_detay,urun.urun_foto_url,urun.urun_tarih,urun.urun_fiyat,urun.* FROM l_urunler as urun LEFT JOIN l_kategori as kat ON urun.urun_kategori_id = kat.kategori_id LEFT JOIN l_uyeler as uye ON uye.uye_id = urun.urun_uye_id where urun.urun_id={0}", urun_id).First();
}
return(result);
}
catch (Exception)
{
return(result);
}
}
public List <ent_UYELER> ListUyeler()
{
List <ent_UYELER> result = new List <ent_UYELER>();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_UYELER>("select * from l_uyeler").ToList();
}
return(result);
}
catch
{
return(result);
}
}
public ent_URUNLER SonSporUrun()
{
ent_URUNLER result = new ent_URUNLER();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_URUNLER>("select TOP 1 * from l_urunler where l_urunler.urun_kategori_id = 3 order by l_urunler.urun_tarih desc ").First();
}
return(result);
}
catch
{
return(result);
}
}
public ent_KATEGORI SelectKategori(int ktgr_id)
{
ent_KATEGORI result = new ent_KATEGORI();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_KATEGORI>("select * from l_kategori as a where a.kategori_id={0}", ktgr_id).First();
}
return(result);
}
catch
{
return(result);
}
}
public List <ent_KATEGORI> ListKategori()
{
List <ent_KATEGORI> result = new List <ent_KATEGORI>();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_KATEGORI>("select * from l_kategori").ToList();
}
return(result);
}
catch
{
return(result);
}
}
public ent_UYELER SelectUye(int uye_id)
{
ent_UYELER result = new ent_UYELER();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_UYELER>("select * from l_uyeler as a where a.uye_id={0}", uye_id).First();
}
return(result);
}
catch
{
return(result);
}
}
public ent_ADMIN SelectAdmin(int adm_id)
{
ent_ADMIN result = new ent_ADMIN();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_ADMIN>("select * from l_admin as a where a.adm_id={0}", adm_id).First();
}
return(result);
}
catch
{
return(result);
}
}
public List <ent_URUNLER> ListUrun()
{
List <ent_URUNLER> result = new List <ent_URUNLER>();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_URUNLER>("SELECT kat.kategori_ad as urun_kategori_adi, uye.uye_ad_soyad as urun_uye_adi, urun.urun_detay,urun.urun_foto_url, urun.urun_tarih, urun.urun_adi,urun.* FROM l_urunler as urun LEFT JOIN l_kategori as kat ON urun.urun_kategori_id = kat.kategori_id LEFT JOIN l_uyeler as uye ON uye.uye_id = urun.urun_uye_id").ToList();
}
return(result);
}
catch
{
return(result);
}
}
public List <ent_ADMIN> ListAdmin()
{
List <ent_ADMIN> result = new List <ent_ADMIN>();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_ADMIN>("select * from l_admin").ToList();
}
return(result);
}
catch (Exception)
{
return(result);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
spnStatus.Visible = true;
lblMsg.Visible = false;
string secret_key = "ed70df7a017654499542ff0a5515812824b74142";
string data = "";
string txnId = Request["TxId"];
string txnStatus = Request["TxStatus"];
string amount = Request["amount"];
string pgTxnId = Request["pgTxnNo"];
string issuerRefNo = Request["issuerRefNo"];
string authIdCode = Request["authIdCode"];
string firstName = Request["firstName"];
string lastName = Request["lastName"];
string pgRespCode = Request["pgRespCode"];
string zipCode = Request["addressZip"];
string resSignature = Request["signature"];
bool flag = true;
if (txnId != null)
{
data += txnId;
}
if (txnStatus != null)
{
data += txnStatus;
}
if (amount != null)
{
data += amount;
}
if (pgTxnId != null)
{
data += pgTxnId;
}
if (issuerRefNo != null)
{
data += issuerRefNo;
}
if (authIdCode != null)
{
data += authIdCode;
}
if (firstName != null)
{
data += firstName;
}
if (lastName != null)
{
data += lastName;
}
if (pgRespCode != null)
{
data += pgRespCode;
}
if (zipCode != null)
{
data += zipCode;
}
System.Security.Cryptography.HMACSHA1 myhmacsha1 = new System.Security.Cryptography.HMACSHA1(Encoding.ASCII.GetBytes(secret_key));
System.IO.MemoryStream stream = new System.IO.MemoryStream(Encoding.ASCII.GetBytes(data));
string signature = BitConverter.ToString(myhmacsha1.ComputeHash(stream)).Replace("-", "").ToLower();
if (resSignature != null && !signature.Equals(resSignature))
{
flag = false;
}
if (flag == true)
{
//Response.Write("Thank You for using citrus payment Your Unique Transaction Status:" + Convert.ToString(txnStatus));
if (Session["Bed"] != null || Session["Surgery"] != null || Session["AppointmentDetail"] != null || Session["HealthCheck-upComprehensive"] != null || Session["OutstandingBillPayment"] != null || Session["permenantRegistration"] != null || Session["ConsultationAppointment"] != null)
{
DataAccessEntities sessionData = new DataAccessEntities();
if (Session["Bed"] != null)
{
sessionData = (DataAccessEntities)Session["Bed"];
}
else if (Session["Surgery"] != null)
{
sessionData = (DataAccessEntities)Session["Surgery"];
}
else if (Session["AppointmentDetail"] != null)
{
sessionData = (DataAccessEntities)Session["AppointmentDetail"];
}
else if (Session["HealthCheck-upComprehensive"] != null)
{
sessionData = (DataAccessEntities)Session["HealthCheck-upComprehensive"];
}
else if (Session["OutstandingBillPayment"] != null)
{
sessionData = (DataAccessEntities)Session["OutstandingBillPayment"];
}
else if (Session["permenantRegistration"] != null)
{
sessionData = (DataAccessEntities)Session["permenantRegistration"];
}
else if (Session["ConsultationAppointment"] != null)
{
sessionData = (DataAccessEntities)Session["ConsultationAppointment"];
}
//double Damount = Convert.ToDouble(amount);
sessionData.Tranrefid = Convert.ToString(issuerRefNo);
sessionData.Transtatus = Convert.ToString(txnStatus);
sessionData.Amount = Convert.ToInt32(Session["Amount"]);
sessionData.UserId = user.UserID;
lblUserName.Text = user.DisplayName;
lblMNo.Text = user.Username; //= Convert.ToString(user.UserID);
lblTxtnId.Text = sessionData.Transactionid = Convert.ToString(txnId);
lblPaidAgainst.Text = sessionData.FacilityName;
lblDateTime.Text = Convert.ToString(DateTime.Now.ToString("dd/MM/yyyy"));
lblAmount.Text = Convert.ToString(Session["Amount"]) + ".00 INR";
if (txnStatus != null)
{
PatIndex objDeposit = new PatIndex();
if (Session["Bed"] != null)
{
if (txnStatus == "CANCELED")
{
Session["Bed"] = null;
Response.Redirect("/Bed-Booking");
}
var detaisl = objPatIndex.SaveDeposit(lblTxtnId.Text, lblMNo.Text, Convert.ToDouble(Session["Amount"]), Convert.ToString(DateTime.Now.ToString("dd/MM/yyyy")), sessionData.FacilityName);
if (detaisl != null && !string.IsNullOrEmpty(detaisl.MRNO))
{
sessionData.JeevaStatus = detaisl.MRNO;
}
objBusinessLogic.SavePaymentBedSurgery(sessionData);
ServiceBookingSendEmail(user.DisplayName, user.Email, sessionData.FacilityName, sessionData.Category, lblDateTime.Text, Convert.ToString(Session["Amount"]) + ".00 INR", "BedBookingPayment");
Session["Bed"] = null;
}
else if (Session["Surgery"] != null)
{
if (txnStatus == "CANCELED")
{
Session["Surgery"] = null;
Response.Redirect("/surgery-booking");
}
var detaisl = objPatIndex.SaveDeposit(lblTxtnId.Text, lblMNo.Text, Convert.ToDouble(Session["Amount"]), Convert.ToString(DateTime.Now.ToString("dd/MM/yyyy")), sessionData.FacilityName);
if (detaisl != null && !string.IsNullOrEmpty(detaisl.MRNO))
{
sessionData.JeevaStatus = detaisl.MRNO;
}
objBusinessLogic.SavePaymentBedSurgery(sessionData);
ServiceBookingSendEmail(user.DisplayName, user.Email, sessionData.FacilityName, sessionData.Category, lblDateTime.Text, Convert.ToString(Session["Amount"]) + ".00 INR", "SurgeryBookingPayment");
Session["Surgery"] = null;
}
else if (Session["HealthCheck-upComprehensive"] != null)
{
if (txnStatus == "CANCELED")
{
Session["HealthCheck-upComprehensive"] = null;
Response.Redirect("/health-check-up-comprehensive");
}
var detaisl = objPatIndex.SaveDeposit(lblTxtnId.Text, lblMNo.Text, Convert.ToDouble(Session["Amount"]), Convert.ToString(DateTime.Now.ToString("dd/MM/yyyy")), sessionData.FacilityName);
if (detaisl != null && !string.IsNullOrEmpty(detaisl.MRNO))
{
sessionData.JeevaStatus = detaisl.MRNO;
}
objBusinessLogic.SavePaymentBedSurgery(sessionData);
string _categoryName = sessionData.Category;
if (_categoryName == "Male" || _categoryName == "Female")
{
_categoryName = "Package B (" + sessionData.Category + ")";
}
ServiceBookingSendEmail(user.DisplayName, user.Email, sessionData.FacilityName, _categoryName, lblDateTime.Text, Convert.ToString(Session["Amount"]) + ".00 INR", "HealthCheckPayment");
Session["HealthCheck-upComprehensive"] = null;
}
else if (Session["OutstandingBillPayment"] != null)
{
if (txnStatus == "CANCELED")
{
Session["OutstandingBillPayment"] = null;
Response.Redirect("/outstandingbillpayment");
}
var detaisl = objPatIndex.SaveDeposit(lblTxtnId.Text, lblMNo.Text, Convert.ToDouble(Session["Amount"]), Convert.ToString(DateTime.Now.ToString("dd/MM/yyyy")), sessionData.FacilityName);
if (detaisl != null && !string.IsNullOrEmpty(detaisl.MRNO))
{
sessionData.JeevaStatus = detaisl.MRNO;
}
objBusinessLogic.SavePaymentBedSurgery(sessionData);
OutStandingSendEmail(sessionData.FacilityName, Convert.ToString(Session["Amount"]) + ".00 INR", "OutstandingPayment");
Session["OutstandingBillPayment"] = null;
}
else if (Session["permenantRegistration"] != null)
{
if (txnStatus == "CANCELED")
{
Session["permenantRegistration"] = null;
Response.Redirect("/");
}
Session["permenantRegistration"] = null;
lblMsg.Visible = true;
string Gender = user.Profile.GetPropertyValue("Gender");
if (Gender == "Male")
{
Gender = "M";
}
else
{
Gender = "F";
}
string Age = user.Profile.GetPropertyValue("Age");
string Address = user.Profile.GetPropertyValue("Address");
string PhoneNumber = user.Profile.GetPropertyValue("PhoneNumber");
string[] X = PhoneNumber.Split('-');
PhoneNumber = X[1];
string Username;
string Fname;
string Lname;
string Email;
if (user.Username.Length > 20)
{
Username = user.Username.Substring(0, 20);
}
else
{
Username = user.Username;
}
if (user.FirstName.Length > 30)
{
Fname = user.FirstName.Substring(0, 30);
}
else
{
Fname = user.FirstName;
}
if (user.LastName.Length > 30)
{
Lname = user.LastName.Substring(0, 30);
}
else
{
Lname = user.LastName;
}
if (user.Email.Length > 50)
{
Email = user.Email.Substring(0, 50);
}
else
{
Email = user.Email;
}
if (Address.Length > 30)
{
Address = Address.Substring(0, 30);
}
if (PhoneNumber.Length > 12)
{
PhoneNumber = PhoneNumber.Substring(0, 12);
}
var PatientDetails = objPatIndex.UpdateorInsertPatient(user.Username, user.FirstName, user.LastName, Gender, Age, "01/01/2000", Address, Address, Address, PhoneNumber, Email);
if (!string.IsNullOrEmpty(PatientDetails.WEBPWD))
{
DataSet ds = objBusinessLogic.IsExistMRNumber(PatientDetails.MRNO);
if (ds.Tables[0].Rows.Count > 0)
{
Clear();
lblMsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#FF0000");
lblMsg.Text = "You Are Allready Registered As A permanent User!";
}
else
{
bool IsUserExist = objBusinessLogic.IsUserExist(PatientDetails.MRNO);
if (!IsUserExist)
{
if (PatientDetails.PatSex == "M")
{
PatientDetails.PatSex = "Male";
}
else
{
PatientDetails.PatSex = "Female";
}
DataSet dsVal = InsertUpdateUserDetails(PatientDetails.MRNO, PatientDetails.PatFName, PatientDetails.PatLName, PatientDetails.PatEmail, PatientDetails.WEBPWD, PatientDetails.PatMobile, PatientDetails.PatSex, PatientDetails.PatAddr1, PatientDetails.PatAge);
lblMNo.Text = PatientDetails.MRNO;
var detaisl = objPatIndex.SaveDeposit(lblTxtnId.Text, lblMNo.Text, Convert.ToDouble(Session["Amount"]), Convert.ToString(DateTime.Now.ToString("dd/MM/yyyy")), sessionData.FacilityName);
if (detaisl != null && !string.IsNullOrEmpty(detaisl.MRNO))
{
sessionData.JeevaStatus = detaisl.MRNO;
}
objBusinessLogic.SavePaymentBedSurgery(sessionData);
if (dsVal.Tables[0].Rows.Count > 0)
{
// SendMail & MSG
try
{
PermanentUserSendEmail(PatientDetails.PatFName, PatientDetails.PatEmail, PatientDetails.MRNO, PatientDetails.WEBPWD, PhoneNumber, "PermanentRegistration");
lblMsg.Text = "You are now the permanent user! Please login with your MR Number that has been sent to your registered mobile number";
lblMsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#008000");
}
catch (Exception ex)
{
lblMsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#FF0000");
lblMsg.Text = "SMS Service is stoped Due to technical problem!";
}
UserController.DeleteUser(ref user, false, false);
UserController.RemoveUser(user);
if (user.UserID != -1)
{
secure.SignOut();
}
}
}
else
{
Clear();
lblMsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#FF0000");
lblMsg.Text = "UserName allready exist!";
}
}
}
else
{
Clear();
lblMsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#FF0000");
lblMsg.Text = "You are already register as a permanent user, Please login with MR Number";
}
}
else if (Session["ConsultationAppointment"] != null || Session["AppointmentDetail"] != null)
{
if (txnStatus == "CANCELED")
{
Session["ConsultationAppointment"] = null;
Session["AppointmentDetail"] = null;
Response.Redirect("/");
}
sessionData.FacilityName = "Appointment";
var detaisl = objPatIndex.SaveDeposit(lblTxtnId.Text, lblMNo.Text, Convert.ToDouble(Session["Amount"]), Convert.ToString(DateTime.Now.ToString("dd/MM/yyyy")), sessionData.FacilityName);
if (detaisl != null && !string.IsNullOrEmpty(detaisl.MRNO))
{
sessionData.JeevaStatus = detaisl.MRNO;
}
sessionData.FacilityName = "Consultation Appointment";
objBusinessLogic.SavePaymentBookAppointment(sessionData);
AppointmentSendEmail(Convert.ToString(sessionData.PhoneNo), Convert.ToString(sessionData.MobileNo), Convert.ToString(sessionData.Location), Convert.ToString(sessionData.Address), Convert.ToString(sessionData.TimeDate), Convert.ToString(Session["Amount"]) + ".00 INR", Convert.ToString(sessionData.Description), sessionData.dName, "ConsultationAppointment");
Session["ConsultationAppointment"] = null;
Session["AppointmentDetail"] = null;
}
}
else
{
plcDivSucces.Visible = false;
plcDivError.Visible = true;
spnStatus.Attributes["Class"] = "highlight";
spnStatus.InnerText = "Payment Fail !";
}
Session["Amount"] = null;
}
else
{
plcDivSucces.Visible = false;
plcDivError.Visible = true;
spnStatus.Attributes["Class"] = "highlight";
spnStatus.InnerText = "Payment Fail !";
}
}
else
{
Response.Write("Citrus Response Signature and Our (Merchant)Signature Mis - Match");
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
