private void btSave_FormSubmit(object sender, EventArgs e) { Trace.Write("btSave-UserId", UId.ToString()); Trace.Write("btSave-SelectedValue",ddAssignTo.SelectedValue); SqlParameter[] parameters = { new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId), new SqlParameter("@UID",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,UId), new SqlParameter("@EquipId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId), new SqlParameter("@intAssignedTo",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddAssignTo.SelectedValue), new SqlParameter("@vchNote",SqlDbType.VarChar,250,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbNote.Text) }; DbObject dbobj1 = new DbObject(); dbobj1.intRunProcedure("sp_UpdateEquipAssignedTo",parameters); Response.Redirect(ParentPageURL); }
private void btSave_FormSubmit(object sender, EventArgs e) { EquipId=Convert.ToInt32(Request.QueryString["id"]); bool AddNew=false; if(EquipId==0){ AddNew=true; } DbObject dbobj1 = new DbObject(); SqlParameter[] parameters = { new SqlParameter("@Action",SqlDbType.Char,1,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,"U"), new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId), new SqlParameter("@Id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId), new SqlParameter("@TypeId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddTypeId.SelectedValue), new SqlParameter("@MakeId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddMakeId.SelectedValue), new SqlParameter("@ModelId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddModelId.SelectedValue), new SqlParameter("@DeptId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddDeptId.SelectedValue), new SqlParameter("@LocId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddLocationId.SelectedValue), new SqlParameter("@intYear",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbYear.Text), new SqlParameter("@vchEquipId",SqlDbType.VarChar,25,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbEquipId.Text), new SqlParameter("@vchVinSerial",SqlDbType.VarChar,50,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbVinSerial.Text), new SqlParameter("@vchFuelCode",SqlDbType.VarChar,25,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbFuelCode.Text) }; EquipId = dbobj1.intRunProcedure("sp_EquipEditDetail",parameters); if(ckReassign.Checked | AddNew==true){ Response.Redirect("reassign.aspx?id="+EquipId+""); } else{ Response.Redirect("view.aspx?id="+EquipId+""); } }