public int Save(ServiceProvider entity)
{
ValidationResultInfo vri = Validate(entity);
if (!vri.IsValid)
{
throw new DomainValidationException(vri, "Product Details provided not valid");
}
DateTime date = DateTime.Now;
tblServiceProvider tbl = _ctx.tblServiceProvider.FirstOrDefault(s => s.Id == entity.Id);
if (tbl == null)
{
tbl = new tblServiceProvider ();
tbl.IM_DateCreated = date;
tbl.IM_IsActive = true;
_ctx.tblServiceProvider.Add(tbl);
}
tbl.IM_DateUpdated = date;
tbl.AllowOverPayment= entity.AllowOverPayment;
tbl.AllowPartialPayment = entity.AllowPartialPayment;
tbl.Currecy = entity.Currency;
tbl.SDP_APP_ID = entity.SdpAppId;
tbl.SDP_Password = entity.SdpPassword;
tbl.SPCode = entity.Code;
tbl.SPId = entity.Sid;
tbl.SPName = entity.Name;
tbl.SubscriberId = entity.SubscriberId;
tbl.SmsShortCode = entity.SmsShortCode;
_ctx.SaveChanges();
_cacheProvider.Put(_cacheListKey, _ctx.tblServiceProvider.Where(x => x.IM_IsActive).Select(s => s.Id).ToList());
_cacheProvider.Remove(string.Format(_cacheKey, tbl.Id));
return tbl.Id;
}
protected void btnnext_Click(object sender, EventArgs e)
{
try {
var dc = new DataClassesDataContext();
if (FileUpload1.HasFile)
{
var path = Server.MapPath("~/ServiceProvider/Upload/");
FileUpload1.SaveAs(path + "/" + FileUpload1.FileName);
tblImage objimg = new tblImage();
objimg.Name = FileUpload1.FileName;
objimg.AlbumID = 2;
objimg.IsActive = true;
objimg.IsDefault = false;
objimg.CreatedOn = DateTime.Now;
dc.tblImages.InsertOnSubmit(objimg);
dc.SubmitChanges();
}
Session["pass"] = txtpass.Text;
if (txtpass.Text == txtconpass.Text)
{
panel1.Visible = false;
panel2.Visible = true;
var check = (from us in dc.tblServiceProviders
where us.Email == txtmail.Text
select us.ServiceProviderID).Count();
var st1 = (from us in dc.tblServiceProviders
where us.Email == txtmail.Text
select us).FirstOrDefault();
if (check > 0)
{
Session["ServiceProviderID"] = st1.ServiceProviderID;
tblServiceProvider result = (from u in dc.tblServiceProviders
where u.ServiceProviderID == Convert.ToInt32(Session["ServiceProviderID"].ToString())
select u).Single();
result.Password = txtpass.Text;
dc.SubmitChanges();
}
}
else
{
lblerrorPwd.Visible = true;
}
}
catch (Exception ex)
{
//int session = Convert.ToInt32(Session["UserID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "User", 0, 0, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
protected void btnsub_Click(object sender, EventArgs e)
{
try
{
var dc = new DataClassesDataContext();
var check = (from user in dc.tblServiceProviders
where user.Email == txteid.Text
select user.ServiceProviderID).Count();
var st1 = (from user in dc.tblServiceProviders
where user.Email == txteid.Text
select user).FirstOrDefault();
var check1 = (from ob in dc.tblClients
where ob.Email == txteid.Text
select ob.ClientID).Count();
var cl1 = (from ob in dc.tblClients
where ob.Email == txteid.Text
select ob).FirstOrDefault();
if (check > 0)
{
Session["ServiceProviderID"] = st1.ServiceProviderID;
tblServiceProvider result = (from u in dc.tblServiceProviders
where u.ServiceProviderID == Convert.ToInt32(Session["ServiceProviderID"].ToString())
select u).Single();
result.Password = txtnepass.Text;
dc.SubmitChanges();
Response.Redirect("ServiceLogin.aspx");
}
else if (check1 > 0)
{
Session["CheID"] = cl1.ClientID;
tblClient result = (from u in dc.tblClients
where u.ClientID == Convert.ToInt32(Session["CheID"].ToString())
select u).Single();
result.Password = txtnepass.Text;
dc.SubmitChanges();
Response.Redirect("ServiceLogin.aspx");
}
}
catch (Exception ex)
{
//int session = Convert.ToInt32(Session["UserID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "User", 0, 0, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
protected void rptVerifyEmployee_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try {
var DC = new DataClassesDataContext();
if (e.CommandName == "Email")
{
tblServiceProvider EmpVerify = (from obj in DC.tblServiceProviders
where obj.ServiceProviderID == Convert.ToInt32(e.CommandArgument)
select obj).Single();
string vc;
DateTime now = DateTime.Now;
vc = now.ToString();
vc = vc.GetHashCode().ToString().Trim('-');
MailMessage Msg = new MailMessage("*****@*****.**", EmpVerify.Email);
Msg.Subject = "Email Verification";
Msg.Body = "<html><head></head><body><table><tr><td>Your E-Mail :</td><td>" + EmpVerify.Email + "</td></tr><tr><td>Your Code :</td><td>" + vc + "</td></tr></table></body></html>";
Msg.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.EnableSsl = true;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
NetworkCredential MyCredentials = new NetworkCredential("*****@*****.**", "lunchbox2017");
smtp.Credentials = MyCredentials;
smtp.Send(Msg);
EmpVerify.VerifyCode = vc;
EmpVerify.IsVerifyByAdmin = true;
DC.SubmitChanges();
}
BindVerifyEmployee();
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var DC = new DataClassesDataContext();
//if (Session["ServiceProviderID"] == null)
//{
// Response.Redirect("ServiceLogin.aspx");
//}
try
{
string[] merc_hash_vars_seq;
string merc_hash_string = string.Empty;
string merc_hash = string.Empty;
string order_id = string.Empty;
string hash_seq = "key|txnid|amount|productinfo|firstname|email|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10";
if (Request.Form["status"] == "success")
{
merc_hash_vars_seq = hash_seq.Split('|');
Array.Reverse(merc_hash_vars_seq);
merc_hash_string = ConfigurationManager.AppSettings["SALT"] + "|" + Request.Form["status"];
foreach (string merc_hash_var in merc_hash_vars_seq)
{
merc_hash_string += "|";
merc_hash_string = merc_hash_string + (Request.Form[merc_hash_var] != null ? Request.Form[merc_hash_var] : "");
}
merc_hash = Generatehash512(merc_hash_string).ToLower();
if (merc_hash != Request.Form["hash"])
{
//Value didn't match that means some paramter value change between transaction
lblFail2.Text = "Hash value did not matched.";
lblSuccess.Visible = false;
lblSuccess2.Visible = false;
lblFail2.Visible = true;
lblFail.Visible = true;
}
else
{
//if hash value match for before transaction data and after transaction data
//that means success full transaction , see more in response
order_id = Request.Form["txnid"];
string prod_info = Request.Form["productinfo"];
lblSuccess2.Text = "value matched" + order_id + "<br/>" + "Product :" + prod_info;
lblSuccess.Visible = true;
lblSuccess2.Visible = true;
lblFail2.Visible = false;
lblFail.Visible = false;
if (Session["ClientID"] != null)
{
var ClientData = (from obj in DC.tblClients
where obj.ClientID == Convert.ToInt32(Session["ClientID"])
select obj).Single();
lblClientName.Text = ClientData.FirstName + " " + ClientData.LastName;
lblClientEmail.Text = ClientData.Email;
lblClientContectNo.Text = ClientData.ContactNo;
tblOrder OrderData = (from obj in DC.tblOrders
where obj.ClientID == Convert.ToInt32(Session["ClientID"]) && (obj.IsActive == false || obj.IsActive == null)
select obj).First();
lblBillAddress.Text = OrderData.BillingAddress;
lblShippingAddress.Text = OrderData.ShippingAddress;
var str = from obj in DC.tblOrders
where obj.MACAddress == GetMACAddress() && obj.ClientID == Convert.ToInt32(Session["ClientID"]) && (obj.IsActive == false || obj.IsActive == null) && obj.ItemID != null
select new
{
CN = (from ob in DC.tblitems
where ob.ItemID == obj.ItemID
select new
{
Data = ob.ItemName,
}).Take(1).SingleOrDefault().Data,
CNN = (from ob in DC.tblitems
where ob.ItemID == obj.ItemID
select new
{
Data = Convert.ToInt32(ob.ItemPrice).ToString(),
}).Take(1).SingleOrDefault().Data,
obj.Date,
obj.OrderID,
obj.Qty,
Total = (Convert.ToInt32((from ob in DC.tblitems
where ob.ItemID == obj.ItemID
select new
{
Data = Convert.ToInt32(ob.ItemPrice).ToString(),
}).Take(1).SingleOrDefault().Data) * obj.Qty),
};
Repeater1.DataSource = str;
Repeater1.DataBind();
var str1 = from obj in DC.tblOrders
where obj.MACAddress == GetMACAddress() && obj.ClientID == Convert.ToInt32(Session["ClientID"]) && (obj.IsActive == false || obj.IsActive == null) && obj.MealID != null
select new
{
CN = (from ob in DC.tblMealPlans
where ob.MealID == obj.MealID
select new
{
Data = ob.MealName,
}).Take(1).SingleOrDefault().Data,
CNN = (from ob in DC.tblMealPlans
where ob.MealID == obj.MealID
select new
{
Data = Convert.ToInt32(ob.MealPrice).ToString(),
}).Take(1).SingleOrDefault().Data,
obj.Date,
obj.OrderID,
obj.Qty,
Total = (Convert.ToInt32((from ob in DC.tblMealPlans
where ob.MealID == obj.MealID
select new
{
Data = Convert.ToInt32(ob.MealPrice).ToString(),
}).Take(1).SingleOrDefault().Data) * obj.Qty),
};
Repeater2.DataSource = str1;
Repeater2.DataBind();
foreach (RepeaterItem item in Repeater1.Items)
{
HiddenField hdnOrder = (HiddenField)item.FindControl("hdnOrder");
tblOrder Data = DC.tblOrders.Single(ob => ob.OrderID == Convert.ToInt32(hdnOrder.Value));
Data.IsActive = true;
DC.SubmitChanges();
}
foreach (RepeaterItem item in Repeater2.Items)
{
HiddenField hdnOrder = (HiddenField)item.FindControl("hdnOrder");
tblOrder Data = DC.tblOrders.Single(ob => ob.OrderID == Convert.ToInt32(hdnOrder.Value));
Data.IsActive = true;
DC.SubmitChanges();
}
//lnkPDF.Visible = true;
PanelClient.Visible = true;
}
if (Session["ServiceProviderID"] != null)
{
tblServiceProvider SP = (from obj in DC.tblServiceProviders
where obj.ServiceProviderID == Convert.ToInt32(Session["ServiceProviderID"])
select obj).Single();
lblSPName.Text = SP.FirstName + " " + SP.LastName;
lblSPEmail.Text = SP.Email;
lblSPContectNumber.Text = SP.ContactNo;
tblPackage Package = (from obj in DC.tblPackages
join obj2 in DC.tblSPPackages
on obj.PackagesID equals obj2.PackagesId
where obj2.ServiceProviderID == Convert.ToInt32(Session["ServiceProviderID"]) && obj2.IsActive == false
orderby obj.PackagesID descending
select obj).First();
lblPackageName.Text = Package.Name;
lblPackagePrice.Text = Package.Price.ToString();
//lnkSPPDF.Visible = true;
PanelSP.Visible = true;
}
}
}
else
{
lblFail2.Text = "Hash value did not matched.";
lblSuccess.Visible = false;
lblSuccess2.Visible = false;
lblFail2.Visible = true;
lblFail.Visible = true;
// osc_redirect(osc_href_link(FILENAME_CHECKOUT, 'payment' , 'SSL', null, null,true));
}
}
catch (Exception ex)
{
Response.Write("<span style='color:red'>" + ex.Message + "</span>");
}
}
private ServiceProvider Map(tblServiceProvider tbl)
{
return new ServiceProvider
{
Id = tbl.Id,
IsActive = tbl.IM_IsActive,
DateCreated = tbl.IM_DateCreated,
DateUpdated = tbl.IM_DateUpdated,
SubscriberId=tbl.SubscriberId,
Sid=tbl.SPId,
SdpPassword=tbl.SDP_Password,
SdpAppId=tbl.SDP_APP_ID,
Name=tbl.SPName,
Currency=tbl.Currecy,
Code=tbl.SPCode,
AllowPartialPayment=tbl.AllowPartialPayment,
AllowOverPayment=tbl.AllowOverPayment,
SmsShortCode = tbl.SmsShortCode,
};
}
protected void btnsub_Click(object sender, EventArgs e)
{
try {
panel1.Visible = true;
var dc = new DataClassesDataContext();
using (DataClassesDataContext data = new DataClassesDataContext())
{
tblAddress add = new tblAddress()
{
Address = txtadd.Text,
Area = txtarea.Text,
Landmark = txtlm.Text,
PincodeNo = txtpinno.Text,
CityID = ddlcity.SelectedIndex
};
data.tblAddresses.InsertOnSubmit(add);
data.SubmitChanges();
string chk;
if (radveg.Checked)
{
chk = "veg";
}
else if (radnonveg.Checked)
{
chk = "Non-Veg";
}
else
{
chk = "Both";
}
var img = (from im in dc.tblImages
orderby im.ImagesID descending
select im).FirstOrDefault();
tblServiceProvider user = new tblServiceProvider()
{
AddressID = add.AddressID,
Password = Session["pass"].ToString(),
FirstName = txtfnm.Text,
LastName = txtlnm.Text,
Email = txtmail.Text,
ImageID = Convert.ToInt32(img.ImagesID),
Veg_NonVeg = chk,
VerifyBy = 1,
CreatedOn = DateTime.Now,
ContactNo = txtphno.Text,
CompanyName = txtcompnm.Text
};
data.tblServiceProviders.InsertOnSubmit(user);
data.SubmitChanges();
using (DataClassesDataContext des = new DataClassesDataContext())
{
tblNotification str = new tblNotification();
str.Title = "ServiceProvider Registered";
str.Description = "You have new ServiceProvider registered";
str.CreatedOn = DateTime.Now;
str.CreatedBy = Convert.ToInt32(Session["ServiceProviderID"]);
des.tblNotifications.InsertOnSubmit(str);
des.SubmitChanges();
tblNotificationDetail strr = new tblNotificationDetail();
strr.NotificationID = str.NotificationID;
strr.IsRead = false;
strr.IsNotify = false;
des.tblNotificationDetails.InsertOnSubmit(strr);
des.SubmitChanges();
}
Response.Redirect("Profile_SP.aspx");
}
}
catch (Exception ex)
{
//int session = Convert.ToInt32(Session["UserID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "User", 0, 0, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
protected void rptSPprovider_ItemCommand1(object source, RepeaterCommandEventArgs e)
{
try {
var DC = new DataClassesDataContext();
int ID = Convert.ToInt32(e.CommandArgument);
if (e.CommandName == "Active")
{
tblServiceProvider result = (from u in DC.tblServiceProviders
where u.ServiceProviderID == ID
select u).Single();
if (result.IsActive == true)
{
result.IsActive = false;
}
else
{
result.IsActive = true;
}
DC.SubmitChanges();
}
else if (e.CommandName == "View")
{
//var Data = from obj in DC.tblServiceProviders
// where obj.ServiceProviderID == Convert.ToInt32(e.CommandArgument)
// select obj;
//rptViewDetail.DataSource = Data;
//rptViewDetail.DataBind();
//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal({backdrop:'static', keyboard: false});", true);
// upModal.Update();
//Response.Write(e.CommandArgument);
var Data = from obj in DC.tblServiceProviders
where obj.ServiceProviderID == Convert.ToInt32(e.CommandArgument)
select new
{
CBy = (from ob in DC.tblAdmins
where ob.AdminID == obj.VerifyBy
select new
{
Data = ob.FirstName + " " + ob.LastName
}).Take(1).SingleOrDefault().Data,
Add = (from obj1 in DC.tblAddresses
where obj1.AddressID == obj.AddressID
select new
{
Data = obj1.Address
}).Take(1).SingleOrDefault().Data,
img = (from o1 in DC.tblImages
where o1.ImagesID == obj.ImageID
select new
{
str = o1.Name
}).Take(1).SingleOrDefault().str,
str1 = obj.FirstName + " " + obj.LastName,
obj.FirstName,
obj.ServiceProviderID,
obj.LastName,
obj.Email,
obj.ContactNo,
obj.Veg_NonVeg,
obj.CompanyName,
obj.CreatedOn,
obj.IsActive
};
rptViewDetail.DataSource = Data;
rptViewDetail.DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal({backdrop:'static', keyboard: false});", true);
// upModal.Update();
}
bindata();
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
protected void cheking_Click(object sender, EventArgs e)
{
try
{
// Panel2.Visible = false;
/// Panel6.Visible = true;
if (Session["VCode"].ToString() == txtcodd.Text)
{
panel5.Visible = true;
//panel5.Visible = false;
Panel2.Visible = false;
Panel3.Visible = true;
var DC = new DataClassesDataContext();
int cntClient = (from obj in DC.tblClients
where obj.Email == txtSpmail.Text && obj.IsActive == false
select obj).Count();
int cntSP = (from obj in DC.tblServiceProviders
where obj.Email == txtSpmail.Text && (obj.IsVerify == null || obj.IsVerify == false)
select obj).Count();
if (cntClient > 0)
{
tblClient ClientData = (from obj in DC.tblClients
where obj.Email == txtSpmail.Text && obj.IsActive == false
select obj).Single();
ClientData.IsActive = true;
DC.SubmitChanges();
Session["ClientID"] = ClientData.ClientID;
if (Session["FromOrder"] != null)
{
Session["FromOrder"] = null;
Response.Redirect("OrderDetail.aspx");
}
else
{
Response.Redirect("Default.aspx");
}
}
else if (cntSP > 0)
{
tblServiceProvider SPData = (from obj in DC.tblServiceProviders
where obj.Email == txtSpmail.Text && (obj.IsVerify == null || obj.IsVerify == false)
select obj).Single();
SPData.IsVerify = true;
DC.SubmitChanges();
Session["ServiceProviderID"] = SPData.ServiceProviderID;
Response.Redirect("Profile_SP.aspx");
}
}
else
{
errorCode.Visible = true;
}
}
catch (Exception ex)
{
//int session = Convert.ToInt32(Session["UserID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "User", 0, 0, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
