protected void Page_Load(object sender, EventArgs e)
{
maDH = Guid.NewGuid().ToString();
Session["info"] = new object();
dt = (DataTable)Session["Giohang"];
if (Session["TaiKhoan"] != null)
{
hoten = Session["TaiKhoan"].ToString();
DataTable Tk = XLDL.GetData("select * from KhachHang where TaiKhoan = '" + hoten + "'");
if (!IsPostBack)
{
txtDC.Value = Tk.Rows[0]["DiaChi"].ToString();
txtEM.Value = Tk.Rows[0]["Email"].ToString();
txtSDT.Value = Tk.Rows[0]["SodienThoai"].ToString();
txtHT.Value = hoten.ToString();
}
id_DN.Visible = false;
}
else
{
id_DN.Visible = true;
}
if (Session["Giohang"] != null)
{
dt_Cart.DataSource = dt;
dt_Cart.DataBind();
XuLyDonHang.getCart(dt, ref TongThanhTien);
lbTongCong.Text = String.Format("{0:0,00}₫", int.Parse(TongThanhTien.ToString()));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GioHang"] == null)
{
Response.Redirect("~/GioHang.aspx");
}
if (Session["TenDN"] == null)
{
Response.Redirect("~/Default.aspx");
}
loaddata();
if (Session["GioHang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.Decimal tongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["Thanhtien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["Dongia"]);
tongThanhTien += Convert.ToDecimal(r["Thanhtien"]);
lbTongTien.Text = tongThanhTien.ToString();
}
gvGioHang.DataSource = dt;
gvGioHang.DataBind();
tt = int.Parse(tongThanhTien.ToString());
}
}
public string CurrencyName(string Code,
string DecPrecise
)
{
string Name = "";
if (Code != "")
{
//不需要加入小數位判斷(DecPrecise) 因為SLP已有屬性控制
Decimal d = new Decimal();
if (Decimal.TryParse(Code, out d))
{
string tempStr = "";
string[] d2 = d.ToString().Split('.');
string _NT = "NT$";
for (int i = 0; i < d2.Length; i++)
{
switch (i)
{
case 0:
_NT += d.ToString("n").Split('.')[0];
break;
case 1:
_NT += d.ToString("#." + tempStr.PadRight(int.Parse(DecPrecise), '0')).Split('.')[1];
break;
default:
break;
}
Name = _NT;
}
}
}
return Name;
}
public ActionResult AddTransaction(string CardCode, Decimal bp)
{
RKCRM.Transaction model = new RKCRM.Transaction();
model.transaction = new RKCRM.Transaction.TransactionInfo();
model.transaction.External_ID = "159357";
model.transaction.External_Index = "951357";
model.transaction.Amount = bp.ToString();
model.transaction.Transaction_Time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + " +10:00";
model.transaction.External_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.transaction.Card_Code = CardCode;
model.transaction.Account_Type_ID = "16";
if (bp >= 0)
{
model.transaction.Remarks = "Ручное начисление средств через Вегу пользователем " + User.Identity.Name.ToString();
}
else
{
model.transaction.Remarks = "Ручное списание средств через Вегу пользователем " + User.Identity.Name.ToString();
}
if (model.AddTransaction())
{
if (bp >= 0)
ViewBag.ErrorMessage += "Начислено " + bp.ToString() + " б.";
else
ViewBag.ErrorMessage += "Списано " + bp.ToString() + " б.";
}
else
ViewBag.ErrorMessage += model.LastResult;
return View("Notification/DefaultNotification");
}
public String ActualizarFechaPeriodo(Decimal ID_EMPRESA, String PERIODOSPROCESO, DateTime FECHA)
{
Conexion conexion = new Conexion(Empresa);
conexion.IniciarTransaccion();
Boolean ejecutar = true;
String sql = null;
String informacion = null;
String actualizado = "N";
tools fecha = new tools();
sql = "usp_actualizar_fecha_memorando ";
#region validaciones
if (ID_EMPRESA > 0)
{
sql += ID_EMPRESA.ToString() + ", ";
informacion += "ID_EMPRESA= '" + ID_EMPRESA.ToString() + ", ";
}
else
{
MensajeError = "El campo ID_EMPRESA es requerido para la consulta.";
ejecutar = false;
}
sql += "'" + PERIODOSPROCESO.ToString() + "', ";
informacion += "PERIODOSPROCESO = '" + PERIODOSPROCESO.ToString() + "', ";
sql += "'" + fecha.obtenerStringConFormatoFechaSQLServer(FECHA) + "', ";
informacion += "FECHA = '" + FECHA.ToString() + "', ";
sql += "'" + Usuario.ToString() + "'";
informacion += "USU_MOD = '" + Usuario.ToString() + "'";
#endregion
if (ejecutar)
{
try
{
conexion.ExecuteNonQuery(sql);
actualizado = "S";
#region auditoria
auditoria _auditoria = new auditoria(Empresa);
_auditoria.Adicionar(Usuario, tabla.NOM_PERIODO, tabla.ACCION_LIQUIDAR, sql, informacion, conexion);
#endregion auditoria
conexion.AceptarTransaccion();
}
catch (Exception e)
{
MensajeError = e.Message;
conexion.DeshacerTransaccion();
}
finally
{
conexion.Desconectar();
}
}
return actualizado;
}
string InsertString_TIMES()
{
if (isNull_TIMES)
{
return(" null ");
}
else
{
return(" '" + db_TIMES.ToString().Replace("'", "") + "' ");
}
}
public static String ConvertDecimalToString(Decimal value)
{
CultureInfo cultureInfo = CultureInfo.GetCultureInfo("vi-VN"); // try with "en-US"
if (value.ToString().Equals(null) || value.ToString().Equals(String.Empty) || value.Equals(Decimal.Zero))
{
return AppConstraints.ZERO + AppConstraints.VND;
}
return (Decimal.Parse(value.ToString()).ToString("#,###.##", cultureInfo.NumberFormat)) + AppConstraints.VND;
}
public Decimal Adicionar(Decimal ID_EMPRESA, String DESCRIPCION_RIESGO, Conexion conexion)
{
String sql = null;
String idRecuperado = null;
String informacion = null;
Boolean ejecutar = true;
sql = "usp_ven_empresas_riesgos_adicionar ";
if (ID_EMPRESA != 0)
{
sql += ID_EMPRESA.ToString() + ", ";
informacion += "ID_EMPRESA = '" + ID_EMPRESA.ToString() + "', ";
}
else
{
MensajeError += "El campo ID_EMPRESA no puede ser nulo\n";
ejecutar = false;
}
if (!(String.IsNullOrEmpty(DESCRIPCION_RIESGO)))
{
sql += "'" + DESCRIPCION_RIESGO + "', ";
informacion += "DESCRIPCION_RIESGO = '" + DESCRIPCION_RIESGO + "', ";
}
else
{
MensajeError += "El campo DESCRIPCION_RIESGO no puede ser nulo\n";
ejecutar = false;
}
sql += "'" + Usuario + "' ";
informacion += "USU_CRE = '" + Usuario + "'";
if (ejecutar)
{
try
{
idRecuperado = conexion.ExecuteScalar(sql);
#region auditoria
auditoria _auditoria = new auditoria(Empresa);
_auditoria.Adicionar(Usuario, tabla.VEN_EMPRESAS_RIESGOS, tabla.ACCION_ADICIONAR, sql, informacion, conexion);
#endregion auditoria
}
catch (Exception e)
{
MensajeError = e.Message;
}
}
if (!(String.IsNullOrEmpty(idRecuperado))) return Convert.ToDecimal(idRecuperado);
else return 0;
}
string InsertString_DIFF_QTY2()
{
if (isNull_DIFF_QTY2)
{
return(" null ");
}
else
{
return(" '" + db_DIFF_QTY2.ToString().Replace("'", "") + "' ");
}
}
string InsertString_HISTORY_HAND_QTY()
{
if (isNull_HISTORY_HAND_QTY)
{
return(" null ");
}
else
{
return(" '" + db_HISTORY_HAND_QTY.ToString().Replace("'", "") + "' ");
}
}
string InsertString_MRB_QTY()
{
if (isNull_MRB_QTY)
{
return(" null ");
}
else
{
return(" '" + db_MRB_QTY.ToString().Replace("'", "") + "' ");
}
}
public Uri Buy(string customerId, string prodId, Decimal paymentAmount)
{
string paymentAmountStr = paymentAmount.ToString("F", NumberFormatInfo.InvariantInfo);
string returnUrl = Settings.Default.PayPalApiReturn;
string cancelUrl = Settings.Default.PayPalApiCancel;
var paymentAction = PaymentActionCodeType.Sale;
var currencyCode = CurrencyCodeType.USD;
var ppResponse = this.ECSetExpressCheckoutCode(paymentAmountStr, returnUrl, cancelUrl, paymentAction, currencyCode);
if (ppResponse.Ack == AckCodeType.Success)
{
// save and redirect
SavePayPalTransactionBegin(customerId, prodId, ppResponse);
string payPalServer = Settings.Default.PayPalApiServer;
string payPalCheckoutCmd = "/webscr?cmd=_express-checkout&token=" + ppResponse.Token;
return new Uri(payPalServer + payPalCheckoutCmd);
}
else
{
// save and show error
SavePayPalTransactionBeginError(customerId, prodId, ppResponse);
throw new ApplicationException("PayPal returned error: " + ppResponse.Errors[0].LongMessage);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["Ms"] != null)
{
int MaHoa = int.Parse(Request.QueryString["Ms"]);
DataTable dt = x.GetData("SELECT TenHoa,DonGia From HOA WHERE MaHoa=" + MaHoa);
String TenHoa = dt.Rows[0][0].ToString();
float DonGia = float.Parse(dt.Rows[0][1].ToString());
int SoLuong = 1;
ThemVaoGioHang(MaHoa, TenHoa, DonGia, SoLuong);
}
if (Session["Giohang"] != null)
{
DataTable dt = (DataTable)Session["Giohang"];
System.Decimal TongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["DonGia"]);
TongThanhTien += Convert.ToDecimal(r["Thanhtien"]);
lbTongThanhTien.Text = TongThanhTien.ToString();
}
gvGioHang.DataSource = dt;
gvGioHang.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["quyen"] != null)
{
if (Session["quyen"].ToString() == "1")
{
Response.Redirect("~/AdminFood.aspx");
}
else if (Session["quyen"].ToString() == "2")
{
Response.Redirect("~/AdminKH.aspx");
}
else
{
Response.Redirect("~/AdminAD.aspx");
}
}
}
if (Session["TenDN"] == null)
{
Response.Redirect("~/Dangnhap.aspx");
}
if (Session["GioHang"] == null)
{
Response.Redirect("~/Giohang.aspx");
}
if (Session["TenDN"] != null)
{
string s = "SELECT MAKH,HOTENKH,DIACHIKH,DIENTHOAIKH,EMAIL FROM KHACHHANG WHERE TENDN='" + Session["TenDN"].ToString() + "'";
DataTable dt = X.GetData(s);
if (dt.Rows.Count > 0)
{
MAKH = int.Parse(dt.Rows[0][0].ToString());
lbHoTen.Text = dt.Rows[0][1].ToString();
lbDiaChi.Text = dt.Rows[0][2].ToString();
lbDienThoai.Text = dt.Rows[0][3].ToString();
lbEmail.Text = dt.Rows[0][4].ToString();
}
}
if (Session["Giohang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.Decimal TongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["DonGia"]);
TongThanhTien += Convert.ToDecimal(r["ThanhTien"]);
lbTongTien.Text = TongThanhTien.ToString();
}
gvGioHang.DataSource = dt;
gvGioHang.DataBind();
}
if (!IsPostBack)
{
cldNgayGiao.SelectedDate = DateTime.Today;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["MaGiay"] != null)
{
//string MaSach = Request.QueryString["MaGiay"];
int MaSach = int.Parse(Request.QueryString["MaGiay"]);
DataTable dt = phong.GetData("select TenGiay,DonGia from CHITIETGIAY where MaGiay=" + MaSach);
string TenSach = dt.Rows[0][0].ToString();
float DonGia = float.Parse(dt.Rows[0][1].ToString());
int SoLuong = 1;
ThemVaoGioHang(MaSach, TenSach, DonGia, SoLuong);
//dt = (DataTable)Session["GioHang"];
//gvGiohang.DataSource = dt;
//gvGiohang.DataBind();
}
if (Session["GioHang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.Decimal TongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["DonGia"]);
TongThanhTien += Convert.ToDecimal(r["ThanhTien"]);
lbTongThanhTIen.Text = TongThanhTien.ToString();
}
gvGiohang.DataSource = dt;
gvGiohang.DataBind();
}
}
public LeviedDetailForList(string levydesc, Decimal rate, Decimal basis, Decimal levied)
{
this.basis = basis.ToString();
this.rate = rate.ToString("#.000000");
this.levyDescription = levydesc;
this.levied = levied.ToString("C");
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack != true)
{
if (Request.QueryString["MaBai"] != null)/*xảy ra trường hợp 1*/
{
int MaBai = int.Parse(Request.QueryString["MaBai"]);
DataTable dt = XLDL.GetData("SELECT TieuDe,DonGia from BaiDang WHERE MaBai = " + MaBai);
String TieuDe = dt.Rows[0][0].ToString();
double DonGia = double.Parse(dt.Rows[0][1].ToString());
int SoLuong = 1;
ThemVaoGioHang(MaBai, TieuDe, DonGia, SoLuong);
}
if (Session["GioHang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.Decimal TongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDouble(r["DonGia"]);
TongThanhTien += Convert.ToDecimal(r["ThanhTien"]);
lbTongThanhTien.Text = TongThanhTien.ToString();
}
gvGioHang.DataSource = dt;
gvGioHang.DataBind();
}
}
}
public bool PosTest1()
{
bool retVal = true;
const string c_TEST_DESC = "PosTest1:Verify the param is a random UInt64 ";
const string c_TEST_ID = "P001";
System.UInt64 uint64Value = Convert.ToUInt64(TestLibrary.Generator.GetInt64(-55));
TestLibrary.TestFramework.BeginScenario(c_TEST_DESC);
try
{
Decimal decimalValue = new Decimal(uint64Value);
if (decimalValue != Convert.ToDecimal(uint64Value))
{
string errorDesc = "Value is not " + Convert.ToDecimal(uint64Value).ToString() + " as expected: param is " + decimalValue.ToString();
TestLibrary.TestFramework.LogError("001" + " TestId-" + c_TEST_ID, errorDesc);
retVal = false;
}
}
catch (Exception e)
{
TestLibrary.TestFramework.LogError("002" + " TestId-" + c_TEST_ID + " TestId-" + c_TEST_ID, "Unexpected exception: " + e);
retVal = false;
}
return retVal;
}
public MainForm(Decimal versionNumber)
{
InitializeComponent();
Text = String.Format("Plutus (v{0})", versionNumber.ToString());
_dam = new DataAccessManager(); //also loads all data from .XML files
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString ["MaSach"] != null)
{
int MaSach = int.Parse(Request.QueryString["MaSach"]);
DataTable dt = xddl.getdata("SELECT TenSach, DonGia FROM SACH WHERE MaSach='" + MaSach + "'");
string TenSach = dt.Rows[0][0].ToString();
float DonGia = float.Parse(dt.Rows[0][1].ToString());
int SoLuong = 1;
ThemVaoGioHang(MaSach, TenSach, DonGia, SoLuong);
}
if (Session["GioHang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.Decimal TongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["DonGia"]);
TongThanhTien += Convert.ToDecimal(r["ThanhTien"]);
lbTongThanhTien.Text = TongThanhTien.ToString();
}
gvgiohang.DataSource = dt;
gvgiohang.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["MaKH"] == null)
{
Response.Redirect("DangNhap.aspx");
}
if (!IsPostBack)
{
if (Request.QueryString["MaHoa"] != null)
{
int SPham = int.Parse(Request.QueryString["MaHoa"]);
DataTable dt = Connect.DocTable("Select TenHoa,Gia From SanPhamHoa where MaHoa=" + SPham);
String TenSP = dt.Rows[0][0].ToString();
int Gia = int.Parse(dt.Rows[0][1].ToString());
int Soluong = 1;
//lblTenDN.Text = Session["tbTenDN"].ToString();
ThemVaoGioHang(SPham, TenSP, Gia, Soluong);
}
if (Session["giohang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["giohang"];
System.Decimal tongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["Gia"]);
tongThanhTien += Convert.ToDecimal(r["ThanhTien"]);
lblTongTien.Text = tongThanhTien.ToString();
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
public DataTable ObtenerInformacionParaSemaforoPrincipal(Decimal ID_EMPRESA)
{
Conexion conexion = new Conexion(Empresa);
DataSet _dataSet = new DataSet();
DataView _dataView = new DataView();
DataTable _dataTable = new DataTable();
String sql = null;
Boolean ejecutar = true;
sql = "usp_nom_empleados_obtenerSemaforoPrincipalGestionHumana ";
sql += ID_EMPRESA.ToString();
if (ejecutar)
{
try
{
_dataSet = conexion.ExecuteReader(sql);
_dataView = _dataSet.Tables[0].DefaultView;
_dataTable = _dataView.Table;
}
catch (Exception e)
{
MensajeError = e.Message;
}
finally
{
conexion.Desconectar();
}
}
return _dataTable;
}
private void AfterConstruct(MainF xMF)
{
xMainF = xMF;
xNSI = xMF.xNSI;
nDocType = (int)(xMF.xDLLAPars[0]);
//DataRow drP = (DataRow)(xMF.xDLLAPars[1]);
//drParent = drP;
// BD_DOUTD
drParent = (DataRow)(xMF.xDLLAPars[1]);
//
dvB = xNSI.dsM.Relations[NSI.REL2BRK].ChildTable.DefaultView;
dvB.RowFilter = String.Format("SYSN={0} AND ID={1}", drParent["SYSN"], drParent["ID"]);
lHeadB.Text = "Брак (" + drParent["KRKMC"].ToString() + ")";
tNameProdB.Text = (string)drParent["SNM"];
// Мест и единиц по накладной
nMaxMest = (int)drParent["KOLM"];
fMaxEd = (FRACT)drParent["KOLE"];
fEmk = (FRACT)drParent["EMK"];
EvalTotal();
lMaxM.Text = nMaxMest.ToString();
lMaxE.Text = fMaxEd.ToString();
SetBindBrak(drParent);
// Настройки грида
dgBrak.SuspendLayout();
dgBrak.DataSource = bsB;
BrakStyle(dgBrak);
dgBrak.ResumeLayout();
// Включить TouchScreen
xMainF.xBCScanner.TouchScr(true);
if (bsB.Count == 0)
{
CreateNew();
if (nDocType == AppC.TYPD_BRK)
{
// Мест
tKolMB.Text = lMaxM.Text;
tKolMB.DataBindings[0].WriteValue();
// Единиц
tKolEB.Text = lMaxE.Text;
tKolEB.DataBindings[0].WriteValue();
}
BeginEditB();
}
else
{
dgBrak.Enabled = true;
dgBrak.Focus();
bsB.ResetBindings(false);
}
}
public DataTable ObtenerNominasHojaTrabajo(Decimal ID_EMPRESA, String ID_EMPRESAS, String ANALISTA)
{
Conexion conexion = new Conexion(Empresa);
DataSet _dataSet = new DataSet();
DataView _dataView = new DataView();
DataTable _dataTable = new DataTable();
String sql = null;
Boolean ejecutar = true;
sql = "usp_obtener_nomina_proceso_hoja_trabajo ";
#region validaciones
if (ID_EMPRESA > 0)
{
sql += ID_EMPRESA.ToString() + " ";
}
else
{
sql += "0" + " ";
}
if (!(String.IsNullOrEmpty(ID_EMPRESAS)))
{
sql += ", '" + ID_EMPRESAS.ToString() + "'";
}
else
{
sql += ",''";
}
if (!(String.IsNullOrEmpty(ANALISTA)))
{
sql += ", '" + ANALISTA.ToString() + "'";
}
else
{
sql += ",''";
}
#endregion
if (ejecutar == true)
{
try
{
_dataSet = conexion.ExecuteReader(sql);
_dataView = _dataSet.Tables[0].DefaultView;
_dataTable = _dataView.Table;
}
catch (Exception e)
{
MensajeError = e.Message;
}
finally
{
conexion.Desconectar();
}
}
return _dataTable;
}
public bool PosTest1()
{
bool retVal = true;
const string c_TEST_DESC = "PosTest1:Verify the param is a random float ";
const string c_TEST_ID = "P001";
float dValue = TestLibrary.Generator.GetSingle(-55);
while (dValue > Convert.ToSingle(Decimal.MaxValue) || dValue < Convert.ToSingle(Decimal.MinValue))
{
dValue = TestLibrary.Generator.GetSingle(-55);
}
TestLibrary.TestFramework.BeginScenario(c_TEST_DESC);
try
{
Decimal decimalValue = new Decimal(dValue);
if (decimalValue != Convert.ToDecimal(dValue))
{
string errorDesc = "Value is not " + decimalValue.ToString() + " as expected: param is " + dValue.ToString();
TestLibrary.TestFramework.LogError("001" + " TestId-" + c_TEST_ID, errorDesc);
retVal = false;
}
}
catch (Exception e)
{
TestLibrary.TestFramework.LogError("002" + " TestId-" + c_TEST_ID + " TestId-" + c_TEST_ID, "Unexpected exception: " + e);
retVal = false;
}
return retVal;
}
public static bool TryFormat(this System.Decimal value, Span <char> destination, out int charsWritten, ReadOnlySpan <char> format = default)
{
var f = GetFormat(format);
var span = ((f == null) ? value.ToString() : value.ToString(f)).AsSpan();
if (span.TryCopyTo(destination))
{
charsWritten = span.Length;
return(true);
}
else
{
charsWritten = 0;
return(false);
}
}
public void loaddata()
{
try
{
if (Request.QueryString["MSP"] != null)
{
string MaSP = Request.QueryString["MSP"].ToString();
DataTable dt = XL.Docbang("Select TenSP,TienSP from SANPHAM Where MaSP=" + MaSP);
string TenSP = dt.Rows[0][0].ToString();
int DonGia = int.Parse(dt.Rows[0][1].ToString());
int SoLuong = 1;
ThemVaoGioHang(MaSP, TenSP, DonGia, SoLuong);
}
if (Session["Giohang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.Decimal tongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["Thanhtien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["Dongia"]);
tongThanhTien += Convert.ToDecimal(r["Thanhtien"]);
lbTongThanhTien.Text = tongThanhTien.ToString();
}
gvGioHang.DataSource = dt;
gvGioHang.DataBind();
}
angiohang();
}
catch
{
}
}
public bool PosTest2()
{
bool retVal = true;
const string c_TEST_DESC = "PosTest2:Verify the param is UInt64.MinValue(0) ";
const string c_TEST_ID = "P002";
UInt64 dValue = UInt64.MinValue;
Decimal resValue = 0m;
TestLibrary.TestFramework.BeginScenario(c_TEST_DESC);
try
{
Decimal decimalValue = new Decimal(dValue);
if (decimalValue != resValue)
{
string errorDesc = "Value is not " + resValue.ToString() + " as expected: param is " + decimalValue.ToString();
TestLibrary.TestFramework.LogError("003" + " TestId-" + c_TEST_ID, errorDesc);
retVal = false;
}
}
catch (Exception e)
{
TestLibrary.TestFramework.LogError("004" + " TestId-" + c_TEST_ID + " TestId-" + c_TEST_ID, "Unexpected exception: " + e);
retVal = false;
}
return retVal;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["idSP"] != null)
{
int idSP = int.Parse(Request.QueryString["idSP"]);
DataTable dt = x.GetData("SELECT TenSP,DonGia FROM dbo.SANPHAM WHERE Type = 2 AND idSP = " + idSP);
String TenSP = dt.Rows[0][0].ToString();
float DonGia = float.Parse(dt.Rows[0][1].ToString());
int SoLuong = 1;
ThemVaoGioHang(idSP, TenSP, DonGia, SoLuong);
}
if (Session["Giohang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["Giohang"];
System.Decimal TongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["DonGia"]);
TongThanhTien += Convert.ToDecimal(r["Thanhtien"]);
lbTongThanhTien.Text = TongThanhTien.ToString();
}
gvgiohang.DataSource = dt;
gvgiohang.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack != true)
{
if (Request.QueryString["MaChim"] != null)
{
int MaChim = int.Parse(Request.QueryString["MaChim"]);
DataTable dt = CSDLBANCHIM.GetData("SELECT Tengoi,DonGia From CHIM WHERE MaChim = " + MaChim);
String Tengoi = dt.Rows[0][0].ToString();
float DonGia = float.Parse(dt.Rows[0][1].ToString());
int SoLuong = 1;
ThemVaoGioHang(MaChim, Tengoi, DonGia, SoLuong);
}
if (Session["GioHang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.Decimal TongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDouble(r["DonGia"]);
TongThanhTien += Convert.ToDecimal(r["ThanhTien"]);
lbTongThanhTien.Text = TongThanhTien.ToString();
}
gvGioHang.DataSource = dt;
gvGioHang.DataBind();
}
}
}
public void ToDecimalTestCase1()
{
var expected = new Decimal( 100.12 );
var value = expected.ToString( CultureInfo.InvariantCulture );
var actual = ObjectEx.ToDecimal( value, CultureInfo.InvariantCulture );
Assert.AreEqual( expected, actual );
}
public void SaveToDecimalTestCase6()
{
var expected = new Decimal( RandomValueEx.GetRandomInt32() + 0.1523 );
var actual = expected.ToString( CultureInfo.InvariantCulture )
.SaveToDecimal( NumberStyles.Any, CultureInfo.InvariantCulture, Decimal.MinValue );
Assert.AreEqual( expected, actual );
}
public string decimalAstring(Decimal des)
{
var final = des.ToString();
var x = final.Replace(",", ".");
return x;
}
public static System.String ToStringAbsolute(System.Decimal AValue)
{
if (AValue < 0)
{
AValue = -AValue;
}
return(AValue.ToString(FORMAT_DECIMAL));
}
public void SaveToDecimalTestCase4()
{
var expected = new Decimal( RandomValueEx.GetRandomInt32() + 0.123 );
var actual = expected.ToString( CultureInfo.InvariantCulture )
.SaveToDecimal( Decimal.MaxValue );
Assert.AreEqual( expected, actual );
}
public void ToDecimalTestCase1()
{
var culture = new CultureInfo( "en-US" );
var value = new Decimal( 1123123.12 );
var actual = value.ToString( culture )
.ToDecimal( culture );
Assert.AreEqual( value, actual );
}
public Boolean ActualizarAfpDeNomEmpleadosPorIdEmpleado(Decimal ID_EMPLEADO, Decimal ID_F_PENSIONES, Conexion conexion)
{
Int32 cantidadRegistrosActualizados = 0;
String sql = null;
String informacion = null;
Boolean ejecutar = true;
tools _tools = new tools();
sql = "usp_nom_empleados_actualizar_afp_por_idEmpleado ";
#region validaciones
if (ID_EMPLEADO != 0)
{
sql += ID_EMPLEADO + ", ";
informacion += "ID_EMPLEADO = '" + ID_EMPLEADO.ToString() + "', ";
}
else
{
MensajeError += "El campo ID_EMPLEADO no puede ser nulo\n";
ejecutar = false;
}
if (ID_F_PENSIONES != 0)
{
sql += ID_F_PENSIONES + ", ";
informacion += "ID_F_PENSIONES = '" + ID_F_PENSIONES.ToString() + "', ";
}
else
{
MensajeError += "El campo ID_F_PENSIONES no puede ser nulo\n";
ejecutar = false;
}
sql += "'" + Usuario + "'";
informacion += "USU_MOD = '" + Usuario.ToString() + "'";
#endregion validaciones
if (ejecutar)
{
try
{
cantidadRegistrosActualizados = conexion.ExecuteNonQuery(sql);
#region auditoria
auditoria _auditoria = new auditoria(Empresa);
_auditoria.Adicionar(Usuario, tabla.CON_REG_CONTRATOS, tabla.ACCION_ACTUALIZAR, sql, informacion, conexion);
#endregion auditoria
}
catch (Exception e)
{
MensajeError = e.Message;
}
}
if (cantidadRegistrosActualizados > 0) return true;
else return false;
}
public void ToDecimalTestCase()
{
Thread.CurrentThread.CurrentCulture = new CultureInfo( "en-US" );
var expected = new Decimal( 100.12 );
var value = expected.ToString( Thread.CurrentThread.CurrentCulture );
var actual = ObjectEx.ToDecimal( value );
Assert.AreEqual( expected, actual );
}
public void ToDecimalTestCase()
{
var value = new Decimal( 100.120 );
var actual = value.ToString( CultureInfo.CurrentCulture )
.Replace( ",", "." )
.ToDecimal();
Assert.AreEqual( value, actual );
}
string SelectString_HISTORY_HAND_QTY()
{
if (isNull_old_HISTORY_HAND_QTY)
{
return(" HISTORY_HAND_QTY is null ");
}
else
{
return(" HISTORY_HAND_QTY = '" + db_old_HISTORY_HAND_QTY.ToString().Replace("'", "") + "' ");
}
}
string SelectString_TIMES()
{
if (isNull_old_TIMES)
{
return(" TIMES is null ");
}
else
{
return(" TIMES = '" + db_old_TIMES.ToString().Replace("'", "") + "' ");
}
}
string SelectString_MRB_QTY()
{
if (isNull_old_MRB_QTY)
{
return(" MRB_QTY is null ");
}
else
{
return(" MRB_QTY = '" + db_old_MRB_QTY.ToString().Replace("'", "") + "' ");
}
}
string SelectString_DIFF_QTY2()
{
if (isNull_old_DIFF_QTY2)
{
return(" DIFF_QTY2 is null ");
}
else
{
return(" DIFF_QTY2 = '" + db_old_DIFF_QTY2.ToString().Replace("'", "") + "' ");
}
}
public static System.String ToStringEmpty(System.Decimal AValue)
{
if (AValue < 0)
{
return("");
}
else
{
return(AValue.ToString(FORMAT_DECIMAL));
}
}
public void TryParsDecimalTestCase()
{
var expected = new Decimal( 100.123123 );
var result = new Decimal( 100 );
;
var actual = expected.ToString( CultureInfo.InvariantCulture )
.TryParsDecimal( out result );
Assert.AreEqual( expected, result );
Assert.IsTrue( actual );
}
public Form6(Decimal[] values,int kiralamaID)
{
InitializeComponent();
this.Values = values;
this.KiralamaID = kiralamaID;
KiraTB.Text = "1";
Gecikme = values[0];
GecikmeTB.Text = Gecikme.ToString();
Hasar = values[1];
HasarTB.Text = Hasar.ToString();
ToplamTB.Text = values[2].ToString();
OdemeCB.DataSource = KiralamaIslemleri.getPayTypes();
}
protected void Button3_Click(object sender, EventArgs e)
{
subsections();
subhall();
using (SqlConnection con = new SqlConnection(conObj))
{
con.Open();
string query = "Select CONVERT(varchar, convert (Money,Fees),1) AS Fees from Hall WHERE Residence = @sub22";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(new SqlParameter("@sub22", sub22));
SqlDataReader readr = cmd.ExecuteReader();
string firstlog = "";
while (readr.Read())
{
firstlog = readr[0].ToString();
totfees = firstlog;
b = Convert.ToDecimal(totfees);
}
con.Close();
}
System.Decimal subtotal = System.Decimal.Add(a, b);
using (SqlConnection con = new SqlConnection(conObj))
{
con.Open();
string query = "update batch18 SET totalfees = @subtotal ,Registeredstatus=@yes WHERE Username = @username";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(new SqlParameter("@Username", username));
cmd.Parameters.Add(new SqlParameter("@subtotal", subtotal));
cmd.Parameters.Add(new SqlParameter("@yes", yes));
SqlDataReader readr = cmd.ExecuteReader();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
subtotallabel.Text = subtotal.ToString();
con.Close();
}
show1.Visible = false;
show2.Visible = false;
show3.Visible = false;
show4.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["giohang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["gioHang"];
System.Decimal tongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["thanhtien"] = Convert.ToInt32(r["soluong"]) * Convert.ToDecimal(r["Gia"]);
tongThanhTien += Convert.ToDecimal(r["thanhtien"]);
lblTongTien.Text = "Tổng tiền là:" + tongThanhTien.ToString();
}
}
}
private void btnReport_Click(object sender, EventArgs e)
{
Customer customer = (Customer)this.cbCustomers.SelectedItem;
DateTime startDate = new DateTime(1980, 1, 1);
DateTime endDate = new DateTime(2079, 1, 1);
if (this.cUseDate.Checked)
{
startDate = this.dtpStart.Value.Date;
endDate = this.dtpEnd.Value.Date;
}
Product product = (Product)this.cbProducts.SelectedItem;
DataTable dataTable1 = ReportClass.reportFormNew(customer.ID, startDate, endDate, product.ID);
this.gvOrder.DataSource = (object)dataTable1;
DataTable dataTable2 = ReportClass.reportFormDoneNew(customer.ID, startDate, endDate, product.ID);
this.gvOrderDone.DataSource = (object)dataTable2;
Decimal num1 = new Decimal(0);
Decimal num2 = new Decimal(0);
int num3 = 0;
int num4 = 0;
for (int index1 = 0; index1 < dataTable1.Rows.Count; ++index1)
{
for (int index2 = 1; index2 < dataTable1.Columns.Count; ++index2)
{
if (dataTable1.Columns.Count - 1 != index2 && dataTable1.Rows[index1][index2] != DBNull.Value)
{
num3 += (int)Convert.ToInt16(dataTable1.Rows[index1][index2].ToString());
num1 += Convert.ToDecimal(dataTable1.Rows[index1][index2 + 1].ToString()) * Convert.ToDecimal(dataTable1.Rows[index1][index2].ToString());
++index2;
}
}
}
for (int index1 = 0; index1 < dataTable2.Rows.Count; ++index1)
{
for (int index2 = 1; index2 < dataTable2.Columns.Count; ++index2)
{
if (dataTable2.Columns.Count - 1 != index2 && dataTable2.Rows[index1][index2] != DBNull.Value)
{
num4 += (int)Convert.ToInt16(dataTable2.Rows[index1][index2].ToString());
num2 += Convert.ToDecimal(dataTable2.Rows[index1][index2 + 1].ToString()) * Convert.ToDecimal(dataTable2.Rows[index1][index2].ToString());
++index2;
}
}
}
this.lblCount.Text = "Yola Çıkan Ürün : " + (object)num3;
this.lblTotal.Text = "Toplam : " + num1.ToString();
this.lblCountDone.Text = "Teslim Edilen : " + (object)num4;
this.lblTotalDone.Text = "Toplam : " + num2.ToString();
}
private void getCart()
{
DataTable dt = new DataTable();
System.Decimal TongThanhTien = 0;
dt = (DataTable)Session["GioHang"];
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["DonGia"]);
TongThanhTien += Convert.ToDecimal(r["ThanhTien"]);
}
lbTongTien.Text = String.Format("{0:0,00}₫", int.Parse(TongThanhTien.ToString()));
gvCart.DataSource = dt;
gvCart.DataBind();
}
//decimal a;
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack != true)
{
if (Session["MaTV"] == null)
{
Response.Redirect("~/Dangnhap.aspx");
}
if (Session["GioHang"] == null)
{
Response.Redirect("~/Giohang.aspx");
}
if (Session["MaTV"] != null)
{
string s = @"select MaTV,TenTV,DiaChi,SDT,Email from ThanhVien where MaTV ='" + Session["MaTV"].ToString() + "'";
DataTable dt = XLDL.GetData(s);
if (dt.Rows.Count > 0)
{
lbHoTen.Text = dt.Rows[0][1].ToString();
lbDiaChi.Text = dt.Rows[0][2].ToString();
lbDienThoai.Text = dt.Rows[0][3].ToString();
lbEmail.Text = dt.Rows[0][4].ToString();
txtNguoiNhan.Text = dt.Rows[0][1].ToString();
txtDiaChi.Text = dt.Rows[0][2].ToString();
txtDienThoai.Text = dt.Rows[0][3].ToString();
}
}
if (Session["GioHang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.Decimal tongthanhtien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["DonGia"]);
tongthanhtien += Convert.ToDecimal(r["Thanhtien"]);
lbTongTien.Text = tongthanhtien.ToString();
//Session["lbtongthanhtien"] = tongthanhtien;
// a = tongthanhtien;
}
gvGioHang.DataSource = dt;
gvGioHang.DataBind();
}
calNgayGiao.SelectedDate = DateTime.Today;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["quyen"] != null)
{
if (Session["quyen"].ToString() == "1")
{
Response.Redirect("~/AdminFood.aspx");
}
else if (Session["quyen"].ToString() == "2")
{
Response.Redirect("~/AdminKH.aspx");
}
else
{
Response.Redirect("~/AdminAD.aspx");
}
}
if (Request.QueryString["msp"] != null)
{
int MaSP = int.Parse(Request.QueryString["msp"]);
DataTable dt = x.GetData("SELECT TENSP,DONGIA FROM SANPHAM WHERE MASP=" + MaSP);
String TenSP = dt.Rows[0][0].ToString();
float DonGia = float.Parse(dt.Rows[0][1].ToString());
int SoLuong = 1;
ThemVaoGioHang(MaSP, TenSP, DonGia, SoLuong);
}
if (Session["GioHang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.Decimal TongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["DonGia"]);
TongThanhTien += Convert.ToDecimal(r["ThanhTien"]);
lbTongThanhTien.Text = TongThanhTien.ToString();
}
gvGioHang.DataSource = dt;
gvGioHang.DataBind();
}
}
}
public Decimal ActualizarInformacionBasicaComercial(String PUESTO, String ACLARACION, Decimal ID_EMPRESA, String SiNo)
{
Conexion conexion = new Conexion(Empresa);
DataSet _dataSet = new DataSet();
Decimal REGISTRO_CONTRATO = 0;
String sql = null;
String informacion = null;
Boolean ejecutar = true;
tools _tools = new tools();
sql = "usp_INFO_BASICA_COMERCIAL_ACTUALIZAR ";
if (ID_EMPRESA != 0)
{
sql += " '" + PUESTO + "', " + " '" + ACLARACION + "', '" + ID_EMPRESA + "', '" + SiNo + "'";
informacion += "ID_EMPRESA = " + ID_EMPRESA.ToString() + ", ";
}
else
{
MensajeError = "El campo ID EMPRESA no puede ser 0.";
ejecutar = false;
}
if (ejecutar)
{
try
{
REGISTRO_CONTRATO = Convert.ToDecimal(conexion.ExecuteScalar(sql));
if (REGISTRO_CONTRATO <= 0)
{
MensajeError = "ERROR: Al intentar ingresar la información del contrato de servicio.";
REGISTRO_CONTRATO = 0;
}
else
{
MensajeError = "ERROR: Al intentar ingresar la auditoria del contrato de servicio.";
}
}
catch (Exception e)
{
MensajeError = e.Message;
REGISTRO_CONTRATO = 0;
}
}
return REGISTRO_CONTRATO;
}
public bool runTest()
{
Console.WriteLine(s_strTFPath + " " + s_strTFName + " , for " + s_strClassMethod + " , Source ver " + s_strDtTmVer);
int iCountErrors = 0;
int iCountTestcases = 0;
String strLoc = "Loc_000oo";
String strValue = String.Empty;
try
{
Decimal dec1, dec2;
UInt64 ui64;
strLoc = "Loc_289hv";
for(long l = 0 ; l < Int32.MaxValue ; l+=1000000)
{
ui64 = Convert.ToUInt64(l);
dec1 = new Decimal(ui64);
iCountTestcases++;
if(dec1 != (Decimal)l)
{
iCountErrors++;
printerr("Error_938fh! Expected=="+l.ToString()+" , got value=="+dec1.ToString());
}
}
strLoc = "Loc_298fy";
dec1 = new Decimal(UInt64.MaxValue);
iCountTestcases++;
if(dec1 != Convert.ToDecimal(UInt64.MaxValue))
{
iCountErrors++;
printerr("Error_28hfd! Expected=="+UInt64.MaxValue.ToString()+", got value=="+dec1.ToString());
}
} catch (Exception exc_general ) {
++iCountErrors;
Console.WriteLine (s_strTFAbbrev + " : Error Err_8888yyy! strLoc=="+ strLoc +", exc_general=="+exc_general.ToString());
}
if ( iCountErrors == 0 )
{
Console.WriteLine( "paSs. "+s_strTFPath +" "+s_strTFName+" ,iCountTestcases=="+iCountTestcases.ToString());
return true;
}
else
{
Console.WriteLine("FAiL! "+s_strTFPath+" "+s_strTFName+" ,iCountErrors=="+iCountErrors.ToString()+" , BugNums?: "+s_strActiveBugNums );
return false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["TenDN"] == null)
{
Response.Redirect("~/Dangnhap.aspx");
}
if (Session["Giohang"] == null)
{
Response.Redirect("~/Giohang.aspx");
}
if (Session["TenDN"] != null)
{
string s = "Select MaKH,HoTenKH,DiaChiKH,DienThoaiKH,Email from KHACHHANG where TenDN='" + Session["TenDN"].ToString() + "'";
DataTable dt = x.GetData(s);
if (dt.Rows.Count > 0)
{
MaKH = int.Parse(dt.Rows[0][0].ToString());
lbHoTen.Text = dt.Rows[0][1].ToString();
lbDiaChi.Text = dt.Rows[0][2].ToString();
lbDienThoai.Text = dt.Rows[0][3].ToString();
lbEmail.Text = dt.Rows[0][4].ToString();
}
}
if (Session["Giohang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.Decimal tongThanhTien = 0;
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["DonGia"]);
tongThanhTien += Convert.ToDecimal(r["ThanhTien"]);
lbTongTien.Text = tongThanhTien.ToString();
}
gvGioHang.DataSource = dt;
gvGioHang.DataBind();
maDonHang = int.Parse(x.GetData("Select max(SoDH) from DONDATHANG").Rows[0][0].ToString()) + 1;
tongTriGia = tongThanhTien;
}
if (!IsPostBack)
{
cldNgayGiaoHang.SelectedDate = DateTime.Today;
}
}
public void ExtractFirstDecimalTestCase()
{
var value0 = new Decimal( 100.2 );
var value1 = new Decimal( 100.212 );
var value2 = new Decimal( -1100.2231232 );
var value3 = new Decimal( 12300 );
var stringValue = "".ConcatAll( value0, "asdasd.)(/)(=+", value1, "a", value2, "asd", value3 )
.Replace( ",", "." );
var actual =
stringValue.ExtractFirstDecimal( stringValue.IndexOf( value1.ToString( CultureInfo.InvariantCulture ),
StringComparison.Ordinal ) );
Assert.AreEqual( value1, actual );
actual = stringValue.ExtractFirstDecimal();
Assert.AreEqual( value0, actual );
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["giohang"] == null)
{
mtvThanhToan.ActiveViewIndex = 1;
}
else
{
mtvThanhToan.ActiveViewIndex = 0;
if (Session["nguoidung"] != null)
{
string tennguoidung = Session["nguoidung"].ToString();
string thongtinkh = "select * from Nguoi_Dung where Ten_Nguoi_Dung='" + tennguoidung + "'";
DataTable thongtin = XLDL.docbang(thongtinkh);
txtTenKhachHang.Text = thongtin.Rows[0]["Ho_Ten"].ToString();
txtDiaChiKH.Text = thongtin.Rows[0]["Dia_Chi"].ToString();
txtDienThoaiKH.Text = thongtin.Rows[0]["SDT"].ToString();
txtSoCMNDKH.Text = thongtin.Rows[0]["CMND"].ToString();
txtEmailKH.Text = thongtin.Rows[0]["Email"].ToString();
txtDiaChiKH.Enabled = false;
txtDienThoaiKH.Enabled = false;
txtEmailKH.Enabled = false;
txtSoCMNDKH.Enabled = false;
txtTenKhachHang.Enabled = false;
}
//hien thi thong tin gio hang len gridview
DataTable dt = (DataTable)Session["giohang"];
System.Decimal tongThanhTien = 0;
foreach (DataRow row in dt.Rows)
{
row["thanhtien"] = Convert.ToInt32(row["soluong"]) * Convert.ToDecimal(row["gia"]);
tongThanhTien += Convert.ToDecimal(row["thanhtien"]);
lblTongTien.Text = tongThanhTien.ToString();
}
GridView1.DataSource = dt;
GridView1.DataBind();
if (!IsPostBack)
{
calNgayNhan.SelectedDate = DateTime.Today;
}
}
}
// GET: Encashment/Create
public ActionResult Create()
{
var currentUser = User.Identity.Name;
var cluser = db.ClientUsers.FirstOrDefault(p => p.Username == currentUser);
// Income
var totincome = db.Transactions.Where(p => p.ClientUserId == cluser.Id).ToList();
var cntIncome = totincome.Aggregate(new Decimal(), (current, clientUser) => current + clientUser.Amount);
ViewBag.Income = cntIncome.ToString("C", MyCulture);
// Withdrawal
var cntwithd = new Decimal();
//decimal cntwithd;
var totwithd = db.Encashment.Where(p => p.username == currentUser && p.status == "paid");
foreach (var ctotwithd in totwithd)
{
cntwithd = cntwithd + ctotwithd.amount;
}
ViewBag.Withd = cntwithd.ToString("C", MyCulture);
var availBal = cntIncome - cntwithd;
ViewBag.AvailBal = availBal.ToString("C", MyCulture);
var RwrdBnx = totincome.Where(p => p.Type == "RwrdBnx" || p.Type == "7x7").Aggregate(0m, (current, item) => current + item.Amount);
var LeadBonus = totincome.Where(p => p.Type == "7x7sponsorship").Aggregate(0m, (current, item) => current + item.Amount);
var RoyaltyBonus = totincome.Where(p => p.Type == "25x25").Aggregate(0m, (current, item) => current + item.Amount);
var OLRMBonus = totincome.Where(p => p.Type == "25x25sponsorship").Aggregate(0m, (current, item) => current + item.Amount);
ViewBag.RwrdBnx = RwrdBnx;
ViewBag.LeadBonus = LeadBonus;
ViewBag.RoyaltyBonus = RoyaltyBonus;
ViewBag.OLRMBonus = OLRMBonus;
TempData["transum"] = totincome;
return View();
}
public static string GetFractionalAmount(Decimal amount)
{
string fractionalAmount = string.Empty;
if (amount == 0.1m) fractionalAmount = "1/10";
else if (amount == 0.125m) fractionalAmount = "1/8";
else if (amount == 0.20m) fractionalAmount = "1/5";
else if (amount == 0.25m) fractionalAmount = "1/4";
else if (amount == 0.33m) fractionalAmount = "1/3";
else if (amount == 0.375m) fractionalAmount = "3/8";
else if (amount == 0.4m) fractionalAmount = "2/5";
else if (amount == 0.5m) fractionalAmount = "1/2";
else if (amount == 0.6m) fractionalAmount = "2/5";
else if (amount == 0.625m) fractionalAmount = "5/8";
else if (amount == 0.66m) fractionalAmount = "2/3";
else if (amount == 0.75m) fractionalAmount = "3/4";
else if (amount == 0.875m) fractionalAmount = "7/8";
else fractionalAmount = amount.ToString("##.##");
return fractionalAmount;
}
public bool PosTest1()
{
bool retVal = true;
string c_TEST_DESC = "PosTest1: Verify value is a random positive Decimal and IFormatProvider is en-US CultureInfo ... ";
string c_TEST_ID = "P001";
Random rand = new Random(-55);
int low = TestLibrary.Generator.GetInt32(-55);
int mid = TestLibrary.Generator.GetInt32(-55);
int hi = TestLibrary.Generator.GetInt32(-55);
bool isNagetive = true;
Byte scale = (byte)rand.Next(0, 27);
Decimal decimalValue = new Decimal(low, mid, hi, isNagetive, scale);
IFormatProvider provider = new CultureInfo("en-US");
String actualValue = decimalValue.ToString(provider);
TestLibrary.TestFramework.BeginScenario(c_TEST_DESC);
try
{
String resValue = Convert.ToString(decimalValue,provider);
if (actualValue != resValue)
{
string errorDesc = "value is not " + resValue.ToString() + " as expected: Actual is " + actualValue.ToString();
errorDesc += "\n decimal value is " + decimalValue ;
TestLibrary.TestFramework.LogError("001" + " TestId-" + c_TEST_ID, errorDesc);
retVal = false;
}
}
catch (Exception e)
{
TestLibrary.TestFramework.LogError("002", "unexpected exception occurs :" + e);
retVal = false;
}
return retVal;
}
