public TaxCalculationMaster objGetTaxCalculationMaster(string EmployeeId) { TaxCalculationMaster argTaxCalculationMaster = new TaxCalculationMaster(); DataSet DataSetToFill = new DataSet(); if (EmployeeId.ToString().Trim() == "") { goto ErrorHandlers; } DataSetToFill = this.GetTaxCalculationMaster4ID(EmployeeId.ToString().Trim()); if (DataSetToFill.Tables[0].Rows.Count <= 0) { goto Finish; } argTaxCalculationMaster = this.objCreteTaxCalculationMaster((DataRow)DataSetToFill.Tables[0].Rows[0]); goto Finish; ErrorHandlers: Finish: DataSetToFill = null; return(argTaxCalculationMaster); }
private TaxCalculationMaster objCreteTaxCalculationMaster(DataRow dr) { TaxCalculationMaster tTaxCalculationMaster = new TaxCalculationMaster(); tTaxCalculationMaster.SetObjectInfo(dr); return(tTaxCalculationMaster); }
public void InsertTaxCalculationMaster(TaxCalculationMaster argTaxCalculationMaster, DataAccess da, List <ErrorHandlerClass> lstErr) { da.Open_Connection(); SqlParameter[] param = new SqlParameter[10]; param[0] = new SqlParameter("@EmployeeId", argTaxCalculationMaster.EmployeeId); param[1] = new SqlParameter("@TDSNo", argTaxCalculationMaster.TDSNo); param[2] = new SqlParameter("@ItemNo", argTaxCalculationMaster.ItemNo); param[3] = new SqlParameter("@TaxableAllowance", argTaxCalculationMaster.TaxableAllowance); param[4] = new SqlParameter("@TaxableAmount", argTaxCalculationMaster.TaxableAmount); param[5] = new SqlParameter("@CreatedBy", argTaxCalculationMaster.CreatedBy); param[6] = new SqlParameter("@ModifiedBy", argTaxCalculationMaster.ModifiedBy); param[7] = new SqlParameter("@Type", SqlDbType.Char); param[7].Size = 1; param[7].Direction = ParameterDirection.Output; param[8] = new SqlParameter("@Message", SqlDbType.VarChar); param[8].Size = 255; param[8].Direction = ParameterDirection.Output; param[9] = new SqlParameter("@returnvalue", SqlDbType.VarChar); param[9].Size = 20; param[9].Direction = ParameterDirection.Output; int i = da.NExecuteNonQuery("Proc_InsertTDS4Earning", param); string strMessage = Convert.ToString(param[8].Value); string strType = Convert.ToString(param[7].Value); string strRetValue = Convert.ToString(param[9].Value); objErrorHandlerClass.Type = strType; objErrorHandlerClass.MsgId = 0; objErrorHandlerClass.Message = strMessage.ToString(); objErrorHandlerClass.RowNo = 0; objErrorHandlerClass.FieldName = ""; objErrorHandlerClass.LogCode = ""; objErrorHandlerClass.ReturnValue = strRetValue; lstErr.Add(objErrorHandlerClass); //return i; }