private void Update_Submit(DateTime vFromDate, DateTime vToDate, DateTime vSetDate) { try { var userEntity = (UserEntity)Session["ID"]; ProjectDenominators dc2 = new ProjectDenominators(); string projectname = ddlPROJECT.SelectedValue.ToString(); string multiplydate = GeneralUtility.ConvertSystemDateStringFormat(txtDcDate.Text.Trim()).Substring(0, 6); //decimal multiply = Convert.ToDecimal(txtDcTimes.Text); DBReader <DenoChangeEntity> dr = new DBReader <DenoChangeEntity>(); string DcID = dr.ExcuteScalar("Select ID From DenoChange Where Project = '" + projectname + "' And DCDate = '" + GeneralUtility.ConvertSystemDateStringFormat(vSetDate) + "'", null, ConnectionDAO.Client.ToConnectionString()).ToString(); string DChangeDate = GeneralUtility.ConvertSystemDateStringFormat(txtDcDate.Text.Trim()); System.Nullable <Decimal> probesvalue; System.Nullable <Decimal> pricingprobesvalue; System.Nullable <Decimal> votesvalue; System.Nullable <Decimal> masksvalue; System.Nullable <Decimal> repricingvalue; System.Nullable <Decimal> scenerecogvalue; System.Nullable <Decimal> probesperscenevalue; System.Nullable <Decimal> expertvalue; System.Nullable <Decimal> expertvotingvalue; if (txtProbes.Text != "" && txtProbes.Text != "0") { probesvalue = Convert.ToDecimal(txtProbes.Text); } else { probesvalue = null; } if (txtPricingProbes.Text != "" && txtPricingProbes.Text != "0") { pricingprobesvalue = Convert.ToDecimal(txtPricingProbes.Text); } else { pricingprobesvalue = null; } if (txtVotes.Text != "" && txtVotes.Text != "0") { votesvalue = Convert.ToDecimal(txtVotes.Text); } else { votesvalue = null; } if (txtMasks.Text != "" && txtMasks.Text != "0") { masksvalue = Convert.ToDecimal(txtMasks.Text); } else { masksvalue = null; } if (txtRepricing.Text != "" && txtRepricing.Text != "0") { repricingvalue = Convert.ToDecimal(txtRepricing.Text); } else { repricingvalue = null; } if (txtSceneRecog.Text != "" && txtSceneRecog.Text != "0") { scenerecogvalue = Convert.ToDecimal(txtSceneRecog.Text); } else { scenerecogvalue = null; } if (txtScenes.Text != "" && txtScenes.Text != "0") { probesperscenevalue = Convert.ToDecimal(txtScenes.Text); } else { probesperscenevalue = null; } if (txtCategoryExpert.Text != "" && txtCategoryExpert.Text != "0") { expertvalue = Convert.ToDecimal(txtCategoryExpert.Text); } else { expertvalue = null; } if (txtExpertVoting.Text != "" && txtExpertVoting.Text != "0") { expertvotingvalue = Convert.ToDecimal(txtExpertVoting.Text); } else { expertvotingvalue = null; } while (vSetDate <= vToDate) { new DenoChange { Entity = new DenoChangeEntity { ID = DcID, PROJECT = projectname, DCDate = GeneralUtility.ConvertSystemDateStringFormat(vSetDate), Probes = probesvalue, Pricingprobes = pricingprobesvalue, Votes = votesvalue, Masks = masksvalue, Repricing = repricingvalue, SceneRecog = scenerecogvalue, ProbesperScene = probesperscenevalue, Expert = expertvalue, ExpertVoting = expertvotingvalue, //Probes = Convert.ToDecimal(string.IsNullOrEmpty(txtProbes.Text) ? "0" : txtProbes.Text), //Pricingprobes = Convert.ToDecimal(string.IsNullOrEmpty(txtPricingProbes.Text) ? "0" : txtPricingProbes.Text), //Votes = Convert.ToDecimal(string.IsNullOrEmpty(txtVotes.Text) ? "0" : txtVotes.Text), //Masks = Convert.ToDecimal(string.IsNullOrEmpty(txtMasks.Text) ? "0" : txtMasks.Text), //Repricing = Convert.ToDecimal(string.IsNullOrEmpty(txtRepricing.Text) ? "0" : txtRepricing.Text), //SceneRecog = Convert.ToDecimal(string.IsNullOrEmpty(txtSceneRecog.Text) ? "0" : txtSceneRecog.Text), //ProbesperScene = Convert.ToDecimal(string.IsNullOrEmpty(txtScenes.Text) ? "0" : txtScenes.Text), //Expert = Convert.ToDecimal(string.IsNullOrEmpty(txtCategoryExpert.Text) ? "0" : txtCategoryExpert.Text), Createdby = userEntity.ID, UpdatedBy = userEntity.ID, UpdatedDate = GeneralUtility.ConvertSystemDateStringFormat(System.DateTime.Now), } }.Update(); vSetDate = vSetDate.AddDays(1); } } catch (Exception ex) { throw ex; } }
public object ExcuteScalar(string aSQL, List <System.Data.Common.DbParameter> aPrams, string con) { return(DBReader.ExcuteScalar(aSQL, aPrams, con)); }