/// <summary>
/// 获取客户信息
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public static customer_info getcust_customer(customer_info entity, string where)
{
try
{
SqlParameter[] param =
{
new SqlParameter("@where", where)
};
SqlDataReader reader = SQLHelp.ExecuteReader("getcust_customer", CommandType.StoredProcedure, param);
if (reader.HasRows)
{
PropertyInfo[] pros = entity.GetType().GetProperties();
while (reader.Read())
{
foreach (PropertyInfo item in pros)
{
item.SetValue(entity, reader.IsDBNull(reader.GetOrdinal(item.Name)) ? null : reader[item.Name]);
}
}
}
else
{
entity = null;
}
return(entity);
}
catch (Exception ex)
{
return(null);
}
}
// GET: customer_info/Edit/5
public async Task <ActionResult> Edit(string id)
{
if (!IsLogin())
{
return(RedirectToAction("Index", "Login"));
}
else
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var CurrentCustomer = (customer_info)Session["CurrentCustomer"];
customer_info customer_info = await CurrentCustomer.GetAccountById(id);
if (customer_info == null)
{
return(HttpNotFound());
}
customer_info.ComisionDelPadre = IMPUESTO;
return(View(customer_info));
}
}
public async Task <ErrorHandling> SetAccount(customer_info account)
{
Regex regex = new Regex(@"^(?=(.*[a-zA-Z].*){2,})(?=.*\d.*)(?=.*\W.*)[a-zA-Z0-9\S]{8,17}$");
Match match = regex.Match(account.password);
if (!match.Success)
{
return(new ErrorHandling
{
faul = true,
faultstring = "La contraseña debe contener dígitos, al menos una letra miniscula y una mayuscula y un caracter especial"
});
}
try
{
var now = DateTime.Now;
var YY = now;
var MM = now.Month.ToString();
var DD = now.Day.ToString();
if (MM.Length == 1)
{
MM = "0" + MM;
}
if (DD.Length == 1)
{
DD = "0" + DD;
}
var activationDate = now.Year + "-" + MM + "-" + DD;
account.ComisionDelPadre = IMPUESTO;
//id de la cuenta
account.opening_balance = 0;
account.iso_4217 = "USD";
account.i_distributor = await ID_DISTRIBUIDOR();
account.i_customer_type = 1; //Online customers
account.batch_name = ID_CUENTA + "-di-pinless";
account.billing_model = 1;
account.i_time_zone = 109;
account.i_ui_time_zone = 109;
account.control_number = 1;
account.h323_password = account.password;
account.i_product = 22791;
account.activation_date = activationDate.Trim();
account.phone1 = account.phone1;
account.firstname = account.firstname;
account.name = account.fullname;
account.lastname = account.lastname;
account.email = account.email;
account.login = account.phone1;
account.password = account.password;
account.note = account.note;
}
catch (Exception ex)
{
;
}
var valid = await account.Validar();
if (!valid.faul)
{
var result = await account.Crear();
return(result);
}
else
{
return(valid);
}
}
public async Task <ActionResult> Create(customer_info account)
{
if (!IsLogin())
{
return(RedirectToAction("Index", "Login"));
}
else
{
if (ModelState.IsValid)
{
//validar impuesto..................................
if (account.impuesto < IMPUESTO)
{
account.ErrorHandlingCrearCuenta.faul = true;
account.ErrorHandlingCrearCuenta.faultstring = "El impuesto de la tienda tiene que ser mayor o igual que su impuesto(" + IMPUESTO + "%)";
return(View(account));
}
//validar fondos disponibles
//var fondos = await FONDOS();
//if (account.LimiteCredito > fondos)
//{
// account.ErrorHandlingCrearCuenta.faul = true;
// account.ErrorHandlingCrearCuenta.faultstring = "El credito que desea asignar es mayor que su fondo.";
// return View(account);
//}
account.note = ":DISTRIB: 2:2:" + account.impuesto + ":";
////CALCULAR DIFERENCIA DE SALDO
//var porcionDistrubuidor = account.LimiteCredito;
//var comisionDistribuidor = IMPUESTO;
//var TotalSegunComision = (float)_Global.ReglaDeTres(comisionDistribuidor,0,porcionDistrubuidor);
//var DineroFicticio = (float)_Global.ReglaDeTres(account.impuesto, TotalSegunComision, 0);
//account.credit_limit = DineroFicticio;
// //----------------------------
account.credit_limit = account.LimiteCredito;
var resul = await SetAccount(account);
if (!resul.faul)
{
//((customer_info)Session["CurrentCustomer"]).credit_limit -= account.LimiteCredito;
//await ((customer_info)Session["CurrentCustomer"]).Actualizar();
//Session["CurrentCustomer"] = await ((customer_info)Session["CurrentCustomer"]).Reload();
ShowSuccess(resul.faultstring);
await FONDOS();
return(RedirectToAction("Index"));
}
else
{
account.ErrorHandlingCrearCuenta = resul;
await FONDOS();
return(View(account));
}
}
else
{
return(View(account));
}
}
}
public async Task <ActionResult> Historial()
{
if (!IsLogin())
{
return(RedirectToAction("Index", "Login"));
}
//DateTime dt1 = DateTime.Now;
//DateTime wkStDt = DateTime.MinValue;
//wkStDt = dt1.AddDays(1 - Convert.ToDouble(dt1.DayOfWeek));
//string inicioSemana = wkStDt.Date.ToString("yyyy/MM/dd HH:mm:ss");
//var dt = DateTime.Parse(inicioSemana);
var utc_from = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Parse(_Global.FromDate), "US Eastern Standard Time", "UTC").ToString("yyyy-MM-dd HH:mm:ss");
//string finSemana = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
//var to = DateTime.Parse(finSemana);
var utc_to = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Parse(_Global.ToDate), "US Eastern Standard Time", "UTC").ToString("yyyy-MM-dd HH:mm:ss");
var facturacion = new Facturacion();
Session["HistorialFromDate"] = _Global.FromDate;
Session["HistorialToDate"] = _Global.ToDate;
GetRetailCustomerXDRListResponse XDRListResponse = new GetRetailCustomerXDRListResponse();
var Xdrs = new List <CustomerXDRInfo>();
if ((TipoTienda)Session["TipoTienda"] == TipoTienda.Padre)
{
XDRListResponse = await((customer_info)Session["CurrentCustomer"]).GetCustomerXDR(new GetRetailCustomerXDRListRequest {
from_date = utc_from, to_date = utc_to
});
Xdrs = XDRListResponse.xdr_list.ToList();
}
else
{
var account = ((customer_info)Session["CurrentAccont"]);
var customer = new customer_info
{
i_customer = account.i_customer
};
XDRListResponse = await customer.GetCustomerXDR(new GetRetailCustomerXDRListRequest { from_date = utc_from, to_date = utc_to });
Xdrs = XDRListResponse.xdr_list.ToList().Where(x => x.account_id == account.i_customer.ToString()).ToList();
}
var RecargaNautas = new List <RecargaNauta>();
var listaCuentas = new List <customer_info>();
foreach (var item in Xdrs)
{
if (item.XdrIsMovil())
{
var nombreCuenta = "";
if (item.account_id != null)
{
if (listaCuentas.Where(x => x.i_customer.ToString() == item.XdrIdAsociado().ToString()).Any())
{
nombreCuenta = listaCuentas.Where(x => x.i_customer.ToString() == item.XdrIdAsociado().ToString()).First().firstname;
}
else
{
var accountInfo = await((customer_info)Session["CurrentCustomer"]).GetAccountById(item.XdrIdAsociado().ToString());
if (accountInfo != null)
{
nombreCuenta = accountInfo.fullname;
listaCuentas.Add(accountInfo);
}
}
}
var recarga = new RecargaNauta();
recarga.Numero = item.XdrGetNumero();
recarga.Monto = item.XdrGetMonto();
recarga.CostoXdr = item.XdrGetCosto();
recarga.Fecha = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(item.bill_time, "UTC", "US Eastern Standard Time").ToString("yyyy-MM-dd HH:mm:ss");
recarga.Asociado = nombreCuenta;
RecargaNautas.Add(recarga);
}
}
Session["ListaRecargasNautasHistorial"] = RecargaNautas;
Session["Registros"] = ((List <RecargaNauta>)Session["ListaRecargasNautasHistorial"]).Count;
var total = ((List <RecargaNauta>)Session["ListaRecargasNautasHistorial"]).Sum(x => x.CostoXdr);
Session["Total"] = decimal.Round(Convert.ToDecimal(total), 2);
return(View((List <RecargaNauta>)Session["ListaRecargasNautasHistorial"]));
}
//获取客户信息
public customer_info getcust_customer(customer_info entity, string where)
{
return(DALBaseCommon.getcust_customer(entity, where));
}
public async Task <ErrorHandling> SetAccount(customer_info account)
{
try
{
var now = DateTime.Now;
var YY = now;
var MM = now.Month.ToString();
var DD = now.Day.ToString();
if (MM.Length == 1)
{
MM = "0" + MM;
}
if (DD.Length == 1)
{
DD = "0" + DD;
}
var activationDate = now.Year + "-" + MM + "-" + DD;
account.ComisionDelPadre = IMPUESTO;
//id de la cuenta
account.opening_balance = 0;
account.iso_4217 = "USD";
account.i_distributor = await ID_DISTRIBUIDOR();
account.i_customer_type = 3; //Online customers
account.batch_name = ID_CUENTA + "-di-pinless";
account.billing_model = 1;
account.payment_commission_rate = 100;
account.sale_commission_rate = 100;
account.i_time_zone = 109;
account.i_ui_time_zone = 109;
account.control_number = 1;
account.h323_password = account.password;
// account.i_product = 22791;
account.activation_date = activationDate.Trim();
account.phone1 = account.phone1;
account.firstname = account.firstname;
account.name = account.fullname;
account.lastname = account.lastname;
account.email = account.email;
account.login = account.phone1;
account.password = account.password;
account.note = account.note;
}
catch (Exception ex)
{
;
}
var valid = await account.Validar();
if (!valid.faul)
{
var result = await account.Crear();
return(result);
}
else
{
return(valid);
}
}
