public string GetCustomerDetails(CustomerObj cusObj)
{
try
{
dynamic obj = new JObject();
string agentID = ConfigurationManager.AppSettings["agentID"];
string agentKey = ConfigurationManager.AppSettings["agentKey"];
var MerchantFk = cusObj.MerchantFk;
var MeterType = cusObj.MeterType;
obj.agentkey = agentKey;
obj.agentID = agentID;
obj.customerId = cusObj.CustomerID;
obj.MerchantFK = MerchantFk;
obj.accountType = MeterType;
var plainText = (agentID + agentKey + obj.customerId);
var builder = new StringBuilder();
builder.Append(agentID).Append(agentKey).Append(obj.customerId);
var hash = new CryptographyManager().ComputeHash(builder.ToString(), HashName.SHA256);
obj.hashValue = hash;
var json = obj.ToString();
var PostUrl = ConfigurationManager.AppSettings["ValidateCustomerID"];
var data = Utility.DoPosts(json, $"{PostUrl}");
return(data);
}
catch (Exception ex)
{
WebLog.Log(ex.Message.ToString());
return(null);
}
}
public string SaveCustomer(CustomerObj id)
{
UserManager userManager = new UserManager();
return(userManager.SaveCustomer(id));
}
public async Task <ActionResult <CustomerObjRespObj> > UpdateCustomer(CustomerObj model)
{
try
{
var response = _customer.UpdateCustomer(model);
return(new CustomerObjRespObj
{
Status = new ApiResponseStatus {
IsSuccessful = response ? true : false, Message = new APIResponseMessage {
FriendlyMessage = response ? "Successful" : "Unsuccessful"
}
}
});
}
catch (Exception ex)
{
return(new CustomerObjRespObj
{
Status = new ApiResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage {
FriendlyMessage = "Error Occurred", TechnicalMessage = ex?.Message
}
}
});
}
}
public UserDetails RegisterCustmer(CustomerObj id)
{
UserManager userManager = new UserManager();
return(userManager.RegisterCustmer(id));
}
protected void Page_Load(object sender, EventArgs e)
{
CustomerObj currentCustomer = (CustomerObj)Session["currentCustomer"];
string email = currentCustomer.getEmailAddress();
DisplayTransactions(email);
}
public static string PostBuySubcriptionJson(CustomerObj cusObj)
{
try
{
string agentID = ConfigurationManager.AppSettings["agentID"];
string agentKey = ConfigurationManager.AppSettings["agentKey"];
dynamic obj = new JObject();
string valueTime = DateTime.Now.ToString("Hmmss");
obj.refNumber = "Agent" + DateTime.Now.ToString("yyyyMMdd") + valueTime;
obj.customername = cusObj.CustomerName;
obj.amount = cusObj.Amount;
obj.agentkey = agentKey;
obj.agentID = agentID;
obj.customerId = cusObj.CustomerID;
obj.MerchantFK = cusObj.MerchantFk;
obj.accountType = cusObj.MeterType;
var plainText = (agentID + agentKey + obj.customerId);
var builder = new StringBuilder();
builder.Append(agentID).Append(agentKey).Append(obj.customerId);
var hash = new CryptographyManager().ComputeHash(builder.ToString(), HashName.SHA256);
obj.hashValue = hash;
var json = obj.ToString();
var PostUrl = ConfigurationManager.AppSettings["Buypower"];
var data = Utility.DoPosts(json, $"{PostUrl}");
return(data);
}
catch (Exception ex)
{
WebLog.Log(ex.Message.ToString());
//Label1.Text = ex.Message.ToString();
return(null);
}
}
public void CreateOrder(float orderPrice)
{
CustomerObj currentCustomer = (CustomerObj)Session["currentCustomer"];
name = currentCustomer.getName();
email = currentCustomer.getEmailAddress();
objCommand.Parameters.Clear();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "Tp_NewOrder";
DateTime date = DateTime.Today;
SqlParameter inputName = new SqlParameter("@OrderName", name);
SqlParameter inputEmail = new SqlParameter("@UserEmail", email);
SqlParameter inputRestEmail = new SqlParameter("@RestaurantEmail", restaurantID);
SqlParameter inputCost = new SqlParameter("@OrderCost", orderPrice);
SqlParameter outputID = new SqlParameter("@OrderID", 1);
outputID.Direction = ParameterDirection.Output;
outputID.SqlDbType = SqlDbType.Int;
objCommand.Parameters.Add(inputName);
objCommand.Parameters.Add(inputEmail);
objCommand.Parameters.Add(inputRestEmail);
objCommand.Parameters.Add(inputCost);
objCommand.Parameters.Add(outputID);
db.DoUpdateUsingCmdObj(objCommand);
orderID = int.Parse(objCommand.Parameters["@OrderID"].Value.ToString());
Session["OrderID"] = orderID;
}
public string GetCustomerInfo(CustomerObj _cobj)
{
try
{
dynamic payObj = new JObject();
string payerPwd = new CryptographyManager().ComputeHash(Plaincode, HashName.MD5);
TransactionNo = payerId + TransactionNumb() + SerialNum();//"420020181227072633oNl8R";
payObj.CustomerID = _cobj.CustomerID;
//"02146506386";
payObj.ServiceAmt = _cobj.Amount;
payObj.Service = _cobj.Service;
payObj.Bouquet = _cobj.Bouquet;
var smartCardCode = _cobj.CustomerID;
string methodName = ConfigurationManager.AppSettings["querySubscriberInfo"];
WebLog.Log("method Name :" + methodName.ToString());
HttpWebRequest request = CreateWebRequest(methodName);
WebLog.Log("request Url :" + request.RequestUri + request.ServerCertificateValidationCallback);
XmlDocument soapEnvelopeXml = new XmlDocument();
var xmlObject = File.ReadAllText(HttpContext.Current.Server.MapPath("/Xmlfiles/StattimeGetCustomerInfo.xml"));
xmlObject = xmlObject.Replace("$payerID", payerId);
xmlObject = xmlObject.Replace("$payerPwd", payerPwd);
xmlObject = xmlObject.Replace("$smartCardCode", smartCardCode);
xmlObject = xmlObject.Replace("$transactionNo", TransactionNo);
soapEnvelopeXml.LoadXml(xmlObject);
WebLog.Log("xmlObject:" + xmlObject);
using (Stream stream = request.GetRequestStream())
{
WebLog.Log("stream:" + stream);
soapEnvelopeXml.Save(stream);
WebLog.Log("stream:" + stream);
}
using (WebResponse response = request.GetResponse())
{
WebLog.Log("response:" + response);
using (StreamReader rd = new StreamReader(response.GetResponseStream()))
{
WebLog.Log("soapResult:" + soapResult);
soapResult = rd.ReadToEnd();
returnMsg = soapResult;
WebLog.Log("soapResult:" + soapResult);
WebLog.Log("returnMsg:" + returnMsg);
}
}
return(returnMsg);
}
catch (Exception ex)
{
WebLog.Log(ex.Message.ToString());
Error = ex.Message;
return(Error);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CustomerObj currentCustomer = (CustomerObj)Session["currentCustomer"];
txtId.Text = currentCustomer.getCustomerId();
txtPassword.Text = currentCustomer.getPassword();
txtEmail.Text = currentCustomer.getEmailAddress();
txtBillingAddress.Text = currentCustomer.getBillingAddress();
txtDeliveryAddress.Text = currentCustomer.getDeliveryAddress();
txtName.Text = currentCustomer.getName();
}
}
public static string GetCustomerDetails(CustomerObj cusObj)
{
try
{
dynamic obj = new JObject();
dynamic headervalues = new JObject();
string agentid = ConfigurationManager.AppSettings["agentID"];
string agentKey = ConfigurationManager.AppSettings["agentKey"];
var MerchantFk = cusObj.MerchantFk;
var MeterType = cusObj.MeterType;
var email = ConfigurationManager.AppSettings["agentEmail"];
obj.agentkey = agentKey;
// obj.agentID = agentID;
obj.customerId = cusObj.CustomerID;
obj.MerchantFK = MerchantFk;
obj.accountType = MeterType;
/* var plainText = (agentID + agentKey + obj.customerId);*/
var builder = new StringBuilder();
builder.Append(agentid).Append(agentKey).Append(obj.customerId);
var hash = new CryptographyManager().ComputeHash(builder.ToString(), HashName.SHA512);
// For The Signature
string customerId = obj.customerId;
var signaturetext = new StringBuilder();
signaturetext.Append(agentid).Append(agentKey).Append(email);
var signature = new CryptographyManager().ComputeHash(signaturetext.ToString(), HashName.SHA512);
obj.hashValue = hash;
var json = obj.ToString();
WebLog.Log("json::" + json);
string sessionID = GetSessionID();
WebLog.Log("SessionID" + sessionID);
var PostUrl = ConfigurationManager.AppSettings["ValidateCustomerIDnew"];
// var data = Utility.DoPosts1(json, $"{PostUrl}",agentID,agentKey,signature,sessionID);
var data = Utility.DoPosts1(json, $"{PostUrl}", agentid, agentKey, signature, sessionID);
WebLog.Log("PostUrl" + PostUrl + agentid + agentKey);
return(data);
}
catch (Exception ex)
{
WebLog.Log(ex.Message.ToString());
return(null);
}
}
public bool UpdateCustomer(CustomerObj entity)
{
try
{
if (entity == null)
{
return(false);
}
if (entity.CustomerId > 0)
{
var itemExist = _context.Customers.FirstOrDefault(x => x.CustomerId == entity.CustomerId);
if (itemExist != null)
{
itemExist.FullName = entity.FullName;
itemExist.Address = entity.Address;
itemExist.Email = entity.Email;
itemExist.PhoneContact = entity.PhoneContact;
itemExist.Active = true;
itemExist.Deleted = false;
itemExist.UpdatedBy = entity.CreatedBy;
itemExist.UpdatedOn = DateTime.Now;
}
}
else
{
var item = new Customers
{
FullName = entity.FullName,
Address = entity.Address,
Email = entity.Email,
PhoneContact = entity.PhoneContact,
Active = true,
Deleted = false,
CreatedBy = entity.CreatedBy,
CreatedOn = DateTime.Now,
};
_context.Customers.Add(item);
}
var response = _context.SaveChanges() > 0;
return(response);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
CustomerObj currentCustomer = (CustomerObj)Session["currentCustomer"];
lblWelcome.Text = "<h1>Welcome " + currentCustomer.getName() + "!</h1>";
if (!IsPostBack)
{
objCommand.Parameters.Clear();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "TP_GetRestaurants";
dsRest = db.GetDataSetUsingCmdObj(objCommand);
rptRest.DataSource = dsRest;
rptRest.DataBind();
}
}
public ActionResult Edit(int id, FormCollection collection)
{
CustomerObj instance = Service.Get(id);
TryUpdateModel(instance);
if (ModelState.IsValid)
{
Service.Update(instance);
return(RedirectToAction("Index"));
}
else
{
}
return(View());
}
public ActionResult Create(FormCollection collection)
{
CustomerObj customer = Service.GetNew();
TryUpdateModel(customer);
if (ModelState.IsValid)
{
Service.Insert(customer);
return(RedirectToAction("Index"));
}
else
{
}
return(View());
}
public CustomerCollection GetAllCustomers()
{
CustomerCollection customers = null;
if (this.TryConnection())
{
DatabaseParameters keyParameters = new DatabaseParameters();
DataTable table = this.QueryData(keyParameters, this.DataStructrure.Tables.MasterCustomer.ActualTableName);
if (table == null)
{
return(customers);
}
customers = new CustomerCollection();
foreach (DataRow row in table.Rows)
{
CustomerObj obj2 = new CustomerObj(row[this.DataStructrure.Tables.MasterCustomer.CustomerID.ActualFieldName].ToString())
{
Name1 = row[this.DataStructrure.Tables.MasterCustomer.Name1.ActualFieldName].ToString(),
Name2 = row[this.DataStructrure.Tables.MasterCustomer.Name2.ActualFieldName].ToString(),
City = row[this.DataStructrure.Tables.MasterCustomer.City.ActualFieldName].ToString(),
Country = new CountryObj(row[this.DataStructrure.Tables.MasterCustomer.Country.ActualFieldName].ToString()),
Currency = row[this.DataStructrure.Tables.MasterCustomer.Currency.ActualFieldName].ToString(),
DistrChannel = row[this.DataStructrure.Tables.MasterCustomer.DistrChannel.ActualFieldName].ToString(),
Division = row[this.DataStructrure.Tables.MasterCustomer.DistrChannel.ActualFieldName].ToString(),
Fax = row[this.DataStructrure.Tables.MasterCustomer.Fax.ActualFieldName].ToString(),
Incoterms1 = new IncotermsObj(row[this.DataStructrure.Tables.MasterCustomer.Incoterms.ActualFieldName].ToString()),
Incoterms2 = row[this.DataStructrure.Tables.MasterCustomer.Incoterms2.ActualFieldName].ToString(),
PaymentTerm = new TermOfPaymentObj(row[this.DataStructrure.Tables.MasterCustomer.PaymentTerms.ActualFieldName].ToString()),
PO = row[this.DataStructrure.Tables.MasterCustomer.PO.ActualFieldName].ToString(),
Region = new RegionObj(row[this.DataStructrure.Tables.MasterCustomer.Region.ActualFieldName].ToString()),
SalesOrg = row[this.DataStructrure.Tables.MasterCustomer.SalesOrg.ActualFieldName].ToString(),
Street = row[this.DataStructrure.Tables.MasterCustomer.Street.ActualFieldName].ToString(),
Tel1 = row[this.DataStructrure.Tables.MasterCustomer.Tel.ActualFieldName].ToString()
};
customers.Add(obj2);
}
}
return(customers);
}
public bool UpdateCustomer(CustomerObj NewCustomer)
{
bool flag = true;
if (this.TryConnection())
{
DatabaseParameters values = new DatabaseParameters();
DatabaseParameters keys = new DatabaseParameters();
keys.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.CustomerID.ActualFieldName, NewCustomer.InternalID));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Incoterms.ActualFieldName, NewCustomer.Incoterms1.InternalID));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Incoterms2.ActualFieldName, NewCustomer.Incoterms2.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.City.ActualFieldName, NewCustomer.City.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Country.ActualFieldName, NewCustomer.Country.InternalID));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Currency.ActualFieldName, NewCustomer.Currency.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.DistrChannel.ActualFieldName, NewCustomer.DistrChannel.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Division.ActualFieldName, NewCustomer.Division.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Fax.ActualFieldName, NewCustomer.Fax.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Name1.ActualFieldName, NewCustomer.Name1.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Name2.ActualFieldName, NewCustomer.Name2.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.PaymentTerms.ActualFieldName, NewCustomer.PaymentTerm.InternalID));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.PO.ActualFieldName, NewCustomer.PO.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Region.ActualFieldName, NewCustomer.Region.InternalID));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.SalesOrg.ActualFieldName, NewCustomer.SalesOrg.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Street.ActualFieldName, NewCustomer.Street.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCustomer.Tel.ActualFieldName, NewCustomer.Tel1.ToString()));
base.CurSQLFactory.UpdateCommand(keys, values, this.DataStructrure.Tables.MasterCustomer.ActualTableName);
if (!(flag = base.CurDBEngine.ExecuteQuery(base.CurSQLFactory.SQL)))
{
base.error_occured = true;
string errMsg = base.ErrMsg;
base.ErrMsg = errMsg + "[CustomerManager] : UpdateCustomer : " + base.CurSQLFactory.SQL + " : " + base.CurDBEngine.ErrorMessage;
}
return(flag);
}
base.error_occured = true;
base.ErrMsg = base.ErrMsg + "[CustomerManager] : UpdateCustomer : " + base.ErrMsg;
return(flag);
}
public string ValidateCableTVRequest(CustomerObj cusObj)
{
try
{
dynamic obj = new JObject();
string agentID = ConfigurationManager.AppSettings["agentID"];
string agentKey = ConfigurationManager.AppSettings["agentKey"];
string email = ConfigurationManager.AppSettings["agentEmail"];
var MerchantFk = cusObj.MerchantFk;
var MeterType = cusObj.MeterType;
obj.beneficiary = cusObj.CustomerID;
obj.MerchantFK = MerchantFk;
var plainText = (agentID + agentKey + obj.customerId);
var signaturetext = new StringBuilder();
signaturetext.Append(agentID).Append(agentKey).Append(email);
var signature = new CryptographyManager().ComputeHash(signaturetext.ToString(), HashName.SHA512);
//obj.hashValue = hash;
var json = obj.ToString();
WebLog.Log("json::" + json);
string sessionID = GetSessionID();
var PostUrl = ConfigurationManager.AppSettings["ValidateCableTVRequest"];
var data = Utility.DoPosts1(json, $"{PostUrl}", agentID, agentKey, signature, sessionID);
return(data);
}
catch (Exception ex)
{
WebLog.Log(ex.Message.ToString());
return(null);
}
}
protected void Login_Click(object sender, EventArgs e)
{
if (cbRememberLogin.Checked)
{
HttpCookie myCookie = new HttpCookie("myCookie");
myCookie["Username"] = txtUsrname.Text;
myCookie["Password"] = txtPssword.Text;
myCookie.Expires = new DateTime(2025, 1, 1);
Response.Cookies.Add(myCookie);
}
int num = dbm.GetAccountTypeById(txtUsrname.Text);
switch (num)
{
case 0:
lblNoAccount.Visible = true;
break;
case 1:
DataSet custData = dbm.GetCustomerByIdAndPassword(txtUsrname.Text, txtPssword.Text);
try
{
DataRow dRow = custData.Tables[0].Rows[0];
String customerId = dRow.ItemArray.GetValue(0).ToString();
String password = dRow.ItemArray.GetValue(1).ToString();
String deliveryAddress = dRow.ItemArray.GetValue(2).ToString();
String billingAddress = dRow.ItemArray.GetValue(3).ToString();
String emailAddress = dRow.ItemArray.GetValue(4).ToString();
String name = dRow.ItemArray.GetValue(5).ToString();
CustomerObj customer = new CustomerObj(customerId, password, deliveryAddress, billingAddress, emailAddress, name);
Session["currentCustomer"] = customer;
Response.Redirect("../Customer/CustomerDashboard.aspx");
}
catch (Exception)
{
Response.Write("error transferring data");
}
break;
case -1:
DataSet restData = dbm.GetRestaurantByIdAndPassword(txtUsrname.Text, txtPssword.Text);
try
{
DataRow dRow = restData.Tables[0].Rows[0];
String restaurantId = dRow.ItemArray.GetValue(0).ToString();
String password = dRow.ItemArray.GetValue(1).ToString();
String email = dRow.ItemArray.GetValue(2).ToString();
String address = dRow.ItemArray.GetValue(3).ToString();
String logo = dRow.ItemArray.GetValue(4).ToString();
String phone = dRow.ItemArray.GetValue(5).ToString();
String restaurantName = dRow.ItemArray.GetValue(6).ToString();
RestaurantObj restaurant = new RestaurantObj(restaurantId, password, email, address, logo, phone, restaurantName);
Session["currentRestaurant"] = restaurant;
Response.Redirect("../Restaurant/RestaurantMain.aspx");
}
catch (Exception)
{
Response.Write("error transferring data");
}
break;
}
}
// GET: Customer/Edit/5
public ActionResult Edit(int id)
{
CustomerObj instance = Service.Get(id);
return(View(instance));
}
public void Update(CustomerObj customer)
{
Repository.Update(customer.Data);
Repository.Save();
}
public void Insert(CustomerObj customer)
{
Repository.Insert(customer.Data);
Repository.Save();
}
// GET: Customer/Details/5
public ActionResult Details(int id)
{
CustomerObj customer = Service.Get(id);
return(View(customer));
}
