public static int Insert(clsActive objProxy) { ValidationException x = new ValidationException(); //if (string.IsNullOrEmpty(objProxy.SActive_name)) // x.AgregarError("Ingrese el nombre del Activo"); //if (x.Cantidad > 0) // throw x; DAOActive daoProxy = new DAOActive(); return daoProxy.Insert(objProxy.SActive_name, objProxy.ISubFamily_id.ISubFamily_id, objProxy.IProvider_id.IProvider_id, objProxy.SActive_desc, objProxy.SBarCode, objProxy.DRegister_time, objProxy.IUtilTime, objProxy.SBrand, objProxy.SModel, objProxy.SForm, objProxy.SSerialNumber, objProxy.SColor, objProxy.SCapacity, objProxy.SMaterial, objProxy.IHeihgt, objProxy.IWidth, objProxy.IWide, objProxy.IDiameter, objProxy.SUnit, objProxy.IDivNumber, objProxy.SAsign_Type, objProxy.SAquisition_Type, objProxy.DtBuy_time, objProxy.IBuy_price, objProxy.SStatus); }
protected void btGuardar_Click(object sender, EventArgs e) { clsActive active = new clsActive(); active.SActive_name = txtsActive_name.Text; RN.Entidades.clsSubFamilies sub = CSubFamilies.SelectRow(Convert.ToInt32(ddSubFamilia.SelectedValue)); active.ISubFamily_id = sub; RN.Entidades.Proveedor pro = CProveedor.TraerXId(Convert.ToInt32(ddlProveedor.SelectedValue)); active.IProvider_id = pro; active.SActive_desc = txtsActive_desc.Text; active.SBarCode = txtsBarcode.Text; ///----------fecha actual txtdRegister_time.Text = DateTime.Now.ToShortDateString(); active.DRegister_time = Convert.ToDateTime(txtdRegister_time.Text); ///-------------------- RN.Entidades.clsSubFamilies idsf = CSubFamilies.SelectRow(Convert.ToInt32(ddSubFamilia.SelectedValue)); RN.Entidades.clsFamilies idf = idsf.IFamily_id; int xz = idf.IDepreciation_time; //DateTime.Now.AddMonths(x).ToLongDateString(); //active.IUtilTime =Convert.ToDateTime(); //esta bien colocarlo active.IUtilTime = Convert.ToDateTime(txtiUtilTime.Text); active.SBrand = txtsBrand.Text; active.SModel = txtsModel.Text; active.SForm = txtsForm.Text; active.SSerialNumber = txtsSerialNumber.Text; active.SColor = txtsColor.Text; active.SCapacity = txtsCapacity.Text; active.SMaterial = txtsMaterial.Text; //------------heihgt string sh = (txtiHeihgt.Text); double val = Convert.ToDouble(sh, CultureInfo.CreateSpecificCulture("en-US")); decimal x = Convert.ToDecimal(val); active.IHeihgt = (x); ///--------------width string sw = (txtiWidth.Text); double val1 = Convert.ToDouble(sw, CultureInfo.CreateSpecificCulture("en-US")); decimal vw = Convert.ToDecimal(val1); active.IWidth = (vw); ///---------------wide string sd = (txtiWide.Text); double val2 = Convert.ToDouble(sd, CultureInfo.CreateSpecificCulture("en-US")); decimal x2 = Convert.ToDecimal(val2); active.IWide = (x2); ///-------------diameter string di = (txtiDiameter.Text); double val3 = Convert.ToDouble(di, CultureInfo.CreateSpecificCulture("en-US")); decimal x3 = Convert.ToDecimal(val3); active.IDiameter = (x3); ///------------price string pr = (txtiBuy_price.Text); double val4 = Convert.ToDouble(pr, CultureInfo.CreateSpecificCulture("en-US")); decimal x4 = Convert.ToDecimal(val4); active.IBuy_price = (x4); /// active.SUnit = txtsUnit.Text; int division = Convert.ToInt32(txtiDivNumber.Text); active.IDivNumber = division; active.SAsign_Type = txtsAsign_type.Text; active.SAquisition_Type = txtsAdquisition_type.Text; active.DtBuy_time = Convert.ToDateTime(txtdtBuy_time.Text); int ss = Convert.ToInt32(ddlEstado.SelectedValue.ToString()); active.SStatus = Convert.ToBoolean(ss); //-------------------------------- DateTime desde = Convert.ToDateTime(txtdRegister_time.Text); //desde //DateTime hasta = Convert.ToDateTime(txtiUtilTime.Text); // hasta ///////si la registro es mayor a la fecha limite //if (Convert.ToInt32(desde) > Convert.ToInt32(hasta)) //{ // this.txtiUtilTime.Text = ""; //} /// si la compra la compra es mayor que el registro limpiar el campo //DateTime compra = Convert.ToDateTime(txtdtBuy_time.Text); //if (Convert.ToInt32(desde) <= Convert.ToInt32(compra)) //{ // this.txtdtBuy_time.Text = ""; //} ///------------------- if (string.IsNullOrEmpty(txtCodigo.Text)) { int iActive = CActive.Insert(active); txtCodigo.Text = iActive.ToString(); limpiar(); //pnlBuscar.Visible = true; //pnlNuevo.Visible = true; //grdActives.Enabled = true; LoadActives(); } else { active.IActive_id = Convert.ToInt32(txtCodigo.Text); CActive.Update(active); pnlBuscar.Visible = true; pnlNuevo.Visible = false; LoadActives(); } }
private static clsActive Load(DataRow fila) { clsActive objProxy = new clsActive(); objProxy.IActive_id = Convert.ToInt32(fila["iActive_id"]); objProxy.SActive_name = fila["sActive_name"].ToString(); RN.Entidades.clsSubFamilies sf = CSubFamilies.SelectRow(Convert.ToInt32(fila["iSubFamily_id"])); RN.Entidades.Proveedor pro = CProveedor.TraerXId(Convert.ToInt32(fila["iProvider_id"])); objProxy.ISubFamily_id= sf; objProxy.IProvider_id= pro; objProxy.SActive_desc = fila["sActive_desc"].ToString(); objProxy.SBarCode = fila["sBarCode"].ToString(); objProxy.DRegister_time = Convert.ToDateTime(fila["dRegister_time"]); objProxy.IUtilTime = Convert.ToDateTime(fila["iUtilTime"]); objProxy.SBrand = fila["sBrand"].ToString(); objProxy.SModel = fila["sModel"].ToString(); objProxy.SForm = fila["sForm"].ToString(); objProxy.SSerialNumber = fila["sSerialNumber"].ToString(); objProxy.SColor = fila["sColor"].ToString(); objProxy.SCapacity = fila["sCapacity"].ToString(); objProxy.SMaterial = fila["sMaterial"].ToString(); objProxy.IHeihgt = Convert.ToDecimal(fila["iHeihgt"]); objProxy.IWidth = Convert.ToDecimal(fila["iWidth"]); objProxy.IWide = Convert.ToDecimal(fila["iWide"]); objProxy.IDiameter = Convert.ToDecimal(fila["iDiameter"]); objProxy.SUnit = fila["sUnit"].ToString(); objProxy.IDivNumber = Convert.ToInt32(fila["iDivNumber"]); objProxy.SAsign_Type = fila["sAsign_type"].ToString(); objProxy.SAquisition_Type = fila["sAcquisition_Type"].ToString(); objProxy.DtBuy_time = Convert.ToDateTime(fila["dtBuy_time"]); objProxy.IBuy_price = Convert.ToDecimal(fila["iBuy_price"]); objProxy.SStatus = Convert.ToBoolean(fila["sStatus"]); return objProxy; }