private List <AmountDivisionModel> SplitAllAccountSchema(int[] acctSchema, List <AmountDivisionModel> dimensionLine)
{
List <AmountDivisionModel> splitDimensionLine = new List <AmountDivisionModel>();
if (dimensionLine.Exists(x => x.AcctSchema == 0))
{
for (int i = 0; i < acctSchema.Length; i++)
{
foreach (AmountDivisionModel amt in dimensionLine)
{
AmountDivisionModel obj = new AmountDivisionModel();
obj.AcctSchema = acctSchema[i];
obj.DimensionType = amt.DimensionType;
obj.DimensionName = amt.DimensionName;
obj.DimensionValueAmount = amt.DimensionValueAmount;
obj.DimensionTypeVal = amt.DimensionTypeVal;
obj.DimensionNameVal = amt.DimensionNameVal;
obj.ElementID = amt.ElementID;
obj.lineAmountID = amt.lineAmountID;
splitDimensionLine.Add(obj);
}
}
return(splitDimensionLine);
}
else
{
return(dimensionLine);
}
}
//public int InsertDimensionAmount(int[] acctSchema, string[] elementType, decimal amount, List<AmountDivisionModel> dimensionLine, Ctx ctx, int DimAmtId)
//{
// bool checkTran = true;
// int DimAcctTypeId = 0;
// int RecordID = -1;
// string Sql = "";
// Trx trx = Trx.Get("trxDim" + DateTime.Now.Millisecond);
// try
// {
// dimensionLine = splitAllAccountSchema(acctSchema, dimensionLine);
// X_C_DimAmt objDimAmt = new X_C_DimAmt(ctx, DimAmtId, trx);
// objDimAmt.SetAmount(amount);
// if (!objDimAmt.Save(trx))
// {
// checkTran = false;
// RecordID = -1;
// return RecordID;
// }
// RecordID = objDimAmt.GetC_DimAmt_ID();
// List<AmountDivisionModel> oldDimensionLine = GetDimensionLine(DimAmtId);
// //Check For Value in oldDimensionLine List against DimensionType and Accounting Schema...............
// foreach (AmountDivisionModel obj in oldDimensionLine)
// {
// var abc = dimensionLine.Where(x => x.DimensionTypeVal == obj.DimensionTypeVal && x.AcctSchema == obj.AcctSchema);
// if (abc == null)
// {
// //if Value does not exist in dimension Line than delete from C_DimamtAcctType Table against DimensionType and AccountSchema
// //and corresponding Dimension Line Will be deleted.................(cascade).
// Sql = "delete from c_dimamtaccttype where c_dimamt_id=" + DimAmtId + " and elementtype='" + obj.DimensionTypeVal + "' and c_acctschema_id=" + obj.AcctSchema;
// DB.ExecuteQuery(Sql, null, trx);
// oldDimensionLine.RemoveAll(x => x.DimensionTypeVal == obj.DimensionTypeVal && x.AcctSchema == obj.AcctSchema);
// }
// }
// //string sql1 = "delete from c_dimamtline where c_dimamt_id=" + objDimAmt.GetC_DimAmt_ID();
// //DB.ExecuteQuery(sql1, null, trx);
// for (int i = 0; i < acctSchema.Length; i++)
// {
// if (DimAmtId != 0)
// {
// //if User Change Dimension Type Value from Accounting Schema Element against Accounting Schema............
// //When user update Record against that Value than delete old Value From C_DimAmtAcctType............
// Sql = "select nvl(c_dimamtaccttype_ID,0) from c_dimamtaccttype where c_dimamt_id=" + objDimAmt.GetC_DimAmt_ID() + " and c_acctschema_ID=" + acctSchema[i] + "";
// DimAcctTypeId = Convert.ToInt32(DB.ExecuteScalar(Sql));
// Sql = "select elementType from c_dimamtaccttype where c_dimamtAcctType_id=" + DimAcctTypeId;
// string oldElement = Convert.ToString(DB.ExecuteScalar(Sql));
// if (oldElement != elementType[i])
// {
// Sql = "delete from c_dimamtaccttype where c_dimamtAcctType_id=" + DimAcctTypeId;
// DB.ExecuteQuery(Sql, null, trx);
// DimAcctTypeId = 0;
// }
// }
// X_C_DimAmtAcctType objDimAcctType = new X_C_DimAmtAcctType(ctx, DimAcctTypeId, trx);
// objDimAcctType.SetC_DimAmt_ID(objDimAmt.GetC_DimAmt_ID());
// objDimAcctType.SetC_AcctSchema_ID(acctSchema[i]);
// objDimAcctType.SetElementType(elementType[i]);
// if (DimAcctTypeId == 0)
// {
// if (!objDimAcctType.Save(trx))
// {
// checkTran = false;
// RecordID = -1;
// return RecordID;
// }
// }
// List<AmountDivisionModel> accountDimensionLine = dimensionLine.FindAll(x => x.AcctSchema == acctSchema[i]);//Find Value against Accounting Schema in New List..........
// List<AmountDivisionModel> oldAccountDimensionLine = oldDimensionLine.FindAll(x => x.AcctSchema == acctSchema[i]);//Find Value against Accounting Schema in Old List...............
// foreach (AmountDivisionModel mod in accountDimensionLine)
// {
// List<AmountDivisionModel> oldTempDim = new List<AmountDivisionModel>();
// //Find New List Value in old List............
// //if All Value Matches than Do Nothing..........
// //if Amount Changes in New List than update against that Line ID.....
// if (oldAccountDimensionLine.Count > 0)
// {
// oldTempDim = oldAccountDimensionLine.FindAll(x => x.DimensionNameVal == mod.DimensionNameVal && x.DimensionTypeVal == mod.DimensionTypeVal && x.DiemensionValueAmount == mod.DiemensionValueAmount);
// }
// if (oldTempDim.Count == 0)
// {
// int dimAmtLineId = 0;
// oldTempDim = oldAccountDimensionLine.FindAll(x => x.DimensionNameVal == mod.DimensionNameVal && x.DimensionTypeVal == mod.DimensionTypeVal);
// if (oldTempDim != null)
// {
// Sql = "select c_dimamtline_id from c_dimamtline cl inner join c_dimamtacctType ct on cl.c_dimamt_id=ct.c_dimamt_id and ct.c_dimamtaccttype_id = cl.c_dimamtaccttype_id " +
// " where cl.c_dimamt_id=" + objDimAmt.GetC_DimAmt_ID() + " and cl.c_dimamtacctType_Id=" + DimAcctTypeId;
// if (mod.DimensionTypeVal == "AC")
// {
// Sql += " and cl.c_elementvalue_id=" + mod.DimensionNameVal;
// }//Account
// else if (mod.DimensionTypeVal == "AY") { Sql += " and cl.c_activity_id=" + mod.DimensionNameVal; }//Activity
// else if (mod.DimensionTypeVal == "BP") { Sql += " and cl.c_BPartner_ID=" + mod.DimensionNameVal; }//BPartner
// else if (mod.DimensionTypeVal == "LF" || mod.DimensionTypeVal == "LT") { Sql += " and cl.c_location_ID=" + mod.DimensionNameVal; }//Location From//Location To
// else if (mod.DimensionTypeVal == "MC") { Sql += " and cl.c_Campaign_ID=" + mod.DimensionNameVal; }//Campaign
// else if (mod.DimensionTypeVal == "OO" || mod.DimensionTypeVal == "OT") { Sql += " and cl.Org_ID=" + mod.DimensionNameVal; }//Organization//Org Trx
// else if (mod.DimensionTypeVal == "PJ") { Sql += " and cl.c_Project_id=" + mod.DimensionNameVal; }//Project
// else if (mod.DimensionTypeVal == "PR") { Sql += " and cl.M_Product_Id=" + mod.DimensionNameVal; }//Product
// else if (mod.DimensionTypeVal == "SR") { Sql += " and cl.c_SalesRegion_Id=" + mod.DimensionNameVal; }//Sales Region
// else if (mod.DimensionTypeVal == "U1" || mod.DimensionTypeVal == "U2")
// {
// Sql += " and cl.c_elementvalue_id=" + mod.DimensionNameVal;
// }//User List 1//User List 2
// else if (mod.DimensionTypeVal == "X1" || mod.DimensionTypeVal == "X2" || mod.DimensionTypeVal == "X3" || mod.DimensionTypeVal == "X4" || mod.DimensionTypeVal == "X5" || mod.DimensionTypeVal == "X6" ||
// mod.DimensionTypeVal == "X7" || mod.DimensionTypeVal == "X8" || mod.DimensionTypeVal == "X9") { Sql += " and cl.AD_Column_ID=" + mod.DimensionNameVal; }//User Element 1 to User Element 9
// dimAmtLineId = Convert.ToInt32(DB.ExecuteScalar(Sql));
// }
// else
// {
// dimAmtLineId = 0;
// }
// X_C_DimAmtLine objDimAmtLine = new X_C_DimAmtLine(ctx, dimAmtLineId, trx);
// objDimAmtLine.SetC_DimAmt_ID(objDimAmt.GetC_DimAmt_ID());
// objDimAmtLine.SetC_DimAmtAcctType_ID(objDimAcctType.GetC_DimAmtAcctType_ID());
// objDimAmtLine.SetAmount(mod.DiemensionValueAmount);
// if (elementType[i] == "AC")
// {
// objDimAmtLine.SetC_Element_ID(mod.ElementID);
// objDimAmtLine.SetC_ElementValue_ID(mod.DimensionNameVal);
// }//Account
// else if (elementType[i] == "AY") { objDimAmtLine.SetC_Activity_ID(mod.DimensionNameVal); }//Activity
// else if (elementType[i] == "BP") { objDimAmtLine.SetC_BPartner_ID(mod.DimensionNameVal); }//BPartner
// else if (elementType[i] == "LF" || elementType[i] == "LT") { objDimAmtLine.SetC_Location_ID(mod.DimensionNameVal); }//Location From//Location To
// else if (elementType[i] == "MC") { objDimAmtLine.SetC_Campaign_ID(mod.DimensionNameVal); }//Campaign
// else if (elementType[i] == "OO" || elementType[i] == "OT") { objDimAmtLine.SetOrg_ID(mod.DimensionNameVal); }//Organization//Org Trx
// else if (elementType[i] == "PJ") { objDimAmtLine.SetC_Project_ID(mod.DimensionNameVal); }//Project
// else if (elementType[i] == "PR") { objDimAmtLine.SetM_Product_ID(mod.DimensionNameVal); }//Product
// else if (elementType[i] == "SA") { }//Sub Account
// else if (elementType[i] == "SR") { objDimAmtLine.SetC_SalesRegion_ID(mod.DimensionNameVal); }//Sales Region
// else if (elementType[i] == "U1" || elementType[i] == "U2")
// {
// objDimAmtLine.SetC_Element_ID(mod.ElementID);
// objDimAmtLine.SetC_ElementValue_ID(mod.DimensionNameVal);
// }//User List 1//User List 2
// else if (elementType[i] == "X1" || elementType[i] == "X2" || elementType[i] == "X3" || elementType[i] == "X4" || elementType[i] == "X5" || elementType[i] == "X6" ||
// elementType[i] == "X7" || elementType[i] == "X8" || elementType[i] == "X9") { objDimAmtLine.SetAD_Column_ID(mod.DimensionNameVal); }//User Element 1 to User Element 9
// if (!objDimAmtLine.Save(trx))
// {
// checkTran = false;
// RecordID = -1;
// //return RecordID;
// break;
// }
// //Remove Value From old List After that value is passed or Updated............
// oldAccountDimensionLine.Remove(oldAccountDimensionLine.Find(a => a.AcctSchema == mod.AcctSchema && a.DimensionTypeVal == mod.DimensionTypeVal && a.DimensionNameVal == mod.DimensionNameVal));
// }
// else
// {
// oldAccountDimensionLine.Remove(oldAccountDimensionLine.Find(a => a.AcctSchema == mod.AcctSchema && a.DimensionTypeVal == mod.DimensionTypeVal && a.DimensionNameVal == mod.DimensionNameVal));
// }
// }
// foreach (AmountDivisionModel oldMod in oldAccountDimensionLine)
// {
// //Delete Remaing Value Which are in old List and from C_dimAmtLine Table....................
// Sql = "delete from c_dimamtline where c_dimamtline_id=" + oldMod.AmtLineID;
// DB.ExecuteQuery(Sql, null, trx);
// }
// }
// }
// catch (Exception e)
// {
// checkTran = false;
// RecordID = -1;
// }
// finally
// {
// if (!checkTran)
// {
// trx.Rollback();
// log.Warning("Some error occured while saving Dimension");
// }
// else
// {
// trx.Commit();
// }
// }
// return RecordID;
//}
public List <AmountDivisionModel> GetDimensionLine(Ctx ctx, int[] accountingSchema, int dimensionID, int DimensionLineID = 0, int pageNo = 0, int pSize = 0)
{
int tempRecid = pSize * (pageNo - 1);
List <AmountDivisionModel> objAmtdimModel = new List <AmountDivisionModel>();
foreach (int acctId in accountingSchema)
{
string uElementTable = "";
string uElementColumn = "";
if (objAmtdimModel.Count != 0)
{
break;
}
int tempDimensionID = Convert.ToInt32(DB.ExecuteScalar("select nvl(c_dimamt_id,0) as DimID from c_dimamtline where c_dimamt_id=" + dimensionID + ""));
if (tempDimensionID != 0)
{
string uQuery = "select main.TableName,listagg(TO_CHAR(('ac.'||main.Colname)),'||''_''||') WITHIN GROUP(order by main.ColId) ColName from " +
"(select distinct tab.tableName as TableName,col2.columnName as Colname,col2.ad_column_id as ColId from c_dimamtaccttype ct " +
"inner join c_dimamtline cl on cl.c_dimamt_id=ct.c_dimamt_id and cl.c_dimamtaccttype_id=ct.c_dimamtaccttype_id " +
"inner join c_acctschema_element se on se.c_acctschema_id=ct.c_acctschema_id and se.elementtype=ct.elementtype " +
"inner join ad_column col1 on col1.ad_column_id=se.ad_column_id " +
"inner join ad_table tab on tab.ad_table_id=col1.ad_table_id " +
"inner join ad_column col2 on col2.ad_table_id=tab.ad_table_id and col2.isidentifier='Y' " +
"where ct.c_dimamt_id=" + dimensionID + " and ct.c_acctschema_id=" + acctId + " order by col2.ad_column_id) main " +
"group by main.TableName";
DataSet dsUelement = DB.ExecuteDataset(uQuery);
if (dsUelement != null && dsUelement.Tables[0].Rows.Count > 0)
{
uElementTable = Convert.ToString(dsUelement.Tables[0].Rows[0][0]);
uElementColumn = Convert.ToString(dsUelement.Tables[0].Rows[0][1]);
}
string sql = "SELECT distinct COALESCE(cl.ad_column_id,cl.c_activity_id,cl.C_BPARTNER_ID,cl.C_CAMPAIGN_ID,cl.C_ELEMENTVALUE_ID,cl.C_LOCATION_ID,cl.C_PROJECT_ID ,cl.C_SALESREGION_ID,cl.M_PRODUCT_ID,cl.ORG_ID) AS DimensionValue," +
" cl.amount,ct.c_acctschema_id,ct.elementtype,adref.Name as DimensionType, " +
" COALESCE(o.name ";
if (uElementColumn != "")
{
sql += " ,(" + uElementColumn + ") ";
}
sql += " ,act.Name,cb.Name,cc.Name,cloc.address1,cpr.Name,cs.Name,mp.NAME,cel.Name) AS DimensionName ,nvl(cl.C_ELEMENT_ID,0) as ElementID,cl.c_dimamtline_id as LineID " +
" from c_dimamt cdm ";
//{
// sql += " left join c_dimamtaccttype ct on cdm.c_dimamt_id=ct.c_dimamt_id " +
// " Left join c_dimamtline cl ON cl.c_dimAmt_ID=ct.c_dimAmt_ID and cl.c_dimamtaccttype_id=ct.c_dimamtaccttype_id" +
// " left JOIN c_acctschema_element rl ON ct.elementtype =rl.elementtype AND ct.c_acctschema_id=rl.c_Acctschema_ID " +
// " left join ad_ref_list adref on adref.value=ct.elementtype " +
// " left join ad_column adc on adc.AD_Reference_Value_ID=adref.AD_Reference_ID and adc.export_id='VIS_2663'";
//}
//else
//{
sql += " inner join c_dimamtaccttype ct on cdm.c_dimamt_id=ct.c_dimamt_id " +
" inner join c_dimamtline cl ON cl.c_dimAmt_ID=ct.c_dimAmt_ID and cl.c_dimamtaccttype_id=ct.c_dimamtaccttype_id" +
" inner JOIN c_acctschema_element rl ON ct.elementtype =rl.elementtype AND ct.c_acctschema_id=rl.c_Acctschema_ID " +
" inner join ad_ref_list adref on adref.value=ct.elementtype " +
" inner join ad_column adc on adc.AD_Reference_Value_ID=adref.AD_Reference_ID and adc.export_id='VIS_2663'";
// }
if (uElementTable != "")
{
sql += " LEFT JOIN " + uElementTable + " ac ON cl.ad_column_ID=ac." + uElementTable + "_ID ";
}
sql +=
" LEFT JOIN c_activity act ON cl.c_activity_id=act.c_activity_id " +
" LEFT JOIN C_BPARTNER cb ON cl.C_BPARTNER_ID=cb.C_BPARTNER_ID " +
" LEFT JOIN C_CAMPAIGN cc ON cl.C_CAMPAIGN_ID=cc.C_CAMPAIGN_ID " +
" LEFT JOIN C_ELEMENTVALUE cel ON cl.C_ELEMENTVALUE_ID=cel.C_ELEMENTVALUE_ID " +
" LEFT JOIN C_ELEMENT el ON cl.C_ELEMENT_ID=el.C_ELEMENT_ID " +
" LEFT JOIN C_LOCATION cloc ON cl.C_LOCATION_ID=cloc.C_LOCATION_ID " +
" LEFT JOIN C_PROJECT cpr ON cl.C_PROJECT_ID=cpr.C_PROJECT_ID " +
" LEFT JOIN C_SALESREGION cs ON cl.C_SALESREGION_ID=cs.C_SALESREGION_ID " +
" LEFT JOIN M_PRODUCT mp ON cl.M_PRODUCT_ID=mp.M_PRODUCT_ID " +
" LEFT JOIN AD_org o ON cl.org_id=o.AD_org_id " +
" WHERE cdm.c_dimamt_ID=" + dimensionID + " and ct.c_acctschema_id=" + acctId;
if (DimensionLineID != 0)
{
sql += " and cl.c_dimamtline_id=" + DimensionLineID;
}
sql += " order by ct.c_acctschema_id";
DataSet ds = new DataSet();
if (pSize == 0 || DimensionLineID != 0)
{
ds = DB.ExecuteDataset(sql);
}
else
{
ds = VIS.DBase.DB.ExecuteDatasetPaging(sql, pageNo, pSize);
}
string sqlcount = "select count(*),sum(lineTotalAmount) as lineTotalAmount from ( " +
" SELECT distinct (cl.Amount) AS LineTotalAmount,cdm.c_dimamt_id,ct.elementtype,cl.c_dimamtline_id from c_dimamt cdm ";
if (tempDimensionID == 0)
{
sqlcount += " left join c_dimamtaccttype ct on cdm.c_dimamt_id=ct.c_dimamt_id " +
" Left join c_dimamtline cl ON cl.c_dimAmt_ID=ct.c_dimAmt_ID and cl.c_dimamtaccttype_id=ct.c_dimamtaccttype_id" +
" left JOIN c_acctschema_element rl ON ct.elementtype =rl.elementtype AND ct.c_acctschema_id=rl.c_Acctschema_ID " +
" left join ad_ref_list adref on adref.value=ct.elementtype " +
" left join ad_column adc on adc.AD_Reference_Value_ID=adref.AD_Reference_ID and adc.export_id='VIS_2663'";
}
else
{
sqlcount += " inner join c_dimamtaccttype ct on cdm.c_dimamt_id=ct.c_dimamt_id " +
" inner join c_dimamtline cl ON cl.c_dimAmt_ID=ct.c_dimAmt_ID and cl.c_dimamtaccttype_id=ct.c_dimamtaccttype_id" +
" inner JOIN c_acctschema_element rl ON ct.elementtype =rl.elementtype AND ct.c_acctschema_id=rl.c_Acctschema_ID " +
" inner join ad_ref_list adref on adref.value=ct.elementtype " +
" inner join ad_column adc on adc.AD_Reference_Value_ID=adref.AD_Reference_ID and adc.export_id='VIS_2663'";
}
sqlcount += " LEFT JOIN ad_column ac ON cl.ad_column_ID=ac.ad_column_ID " +
" LEFT JOIN c_activity act ON cl.c_activity_id=act.c_activity_id " +
" LEFT JOIN C_BPARTNER cb ON cl.C_BPARTNER_ID=cb.C_BPARTNER_ID " +
" LEFT JOIN C_CAMPAIGN cc ON cl.C_CAMPAIGN_ID=cc.C_CAMPAIGN_ID " +
" LEFT JOIN C_ELEMENTVALUE cel ON cl.C_ELEMENTVALUE_ID=cel.C_ELEMENTVALUE_ID " +
" LEFT JOIN C_ELEMENT el ON cl.C_ELEMENT_ID=el.C_ELEMENT_ID " +
" LEFT JOIN C_LOCATION cloc ON cl.C_LOCATION_ID=cloc.C_LOCATION_ID " +
" LEFT JOIN C_PROJECT cpr ON cl.C_PROJECT_ID=cpr.C_PROJECT_ID " +
" LEFT JOIN C_SALESREGION cs ON cl.C_SALESREGION_ID=cs.C_SALESREGION_ID " +
" LEFT JOIN M_PRODUCT mp ON cl.M_PRODUCT_ID=mp.M_PRODUCT_ID " +
" LEFT JOIN AD_org o ON cl.org_id=o.AD_org_id " +
" WHERE cdm.c_dimamt_ID=" + dimensionID + " and ct.c_acctschema_id=" + acctId + " order by ct.c_acctschema_id ) main";
DataSet Record = DB.ExecuteDataset(sqlcount);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
AmountDivisionModel obj = new AmountDivisionModel();
obj.recid = tempRecid + (i + 1);
obj.AcctSchema = Convert.ToInt32(ds.Tables[0].Rows[i]["c_acctschema_id"]);
if (ds.Tables[0].Rows[i]["amount"] != DBNull.Value)
{
obj.DimensionValueAmount = DisplayType.GetNumberFormat(DisplayType.Amount).GetFormatedValue(Convert.ToDecimal(ds.Tables[0].Rows[i]["amount"]));
obj.CalculateDimValAmt = Convert.ToDecimal(ds.Tables[0].Rows[i]["amount"]);
}
else
{
obj.DimensionValueAmount = DisplayType.GetNumberFormat(DisplayType.Amount).GetFormatedValue(0);
obj.CalculateDimValAmt = 0;
}
obj.DimensionName = Convert.ToString(ds.Tables[0].Rows[i]["DimensionName"]);
if (ds.Tables[0].Rows[i]["DimensionValue"] != DBNull.Value)
{
obj.DimensionNameVal = Convert.ToInt32(ds.Tables[0].Rows[i]["DimensionValue"]);
}
else
{
obj.DimensionNameVal = 0;
}
obj.DimensionType = Convert.ToString(ds.Tables[0].Rows[i]["DimensionType"]);
obj.DimensionTypeVal = Convert.ToString(ds.Tables[0].Rows[i]["elementtype"]);
if (obj.DimensionTypeVal == "LF" || obj.DimensionTypeVal == "LT")
{
MLocation objMLocation = new MLocation(ctx, obj.DimensionNameVal, null);
obj.DimensionName = objMLocation.ToString();
}
obj.ElementID = Convert.ToInt32(ds.Tables[0].Rows[i]["ElementID"]);
if (ds.Tables[0].Rows[i]["LineID"] != DBNull.Value)
{
obj.lineAmountID = Convert.ToString(ds.Tables[0].Rows[i]["LineID"]);
}
else
{
obj.lineAmountID = "0";
}
if (Record != null && Record.Tables[0].Rows.Count > 0)
{
if (Record.Tables[0].Rows[0][0] != DBNull.Value)
{
obj.TotalRecord = Convert.ToInt32(Record.Tables[0].Rows[0][0]);
}
else
{
obj.TotalRecord = 0;
}
if (Record.Tables[0].Rows[0][1] != DBNull.Value)
{
obj.TotalLineAmount = Convert.ToDecimal(Record.Tables[0].Rows[0][1]);
}
else
{
obj.TotalLineAmount = 0;
}
}
else
{
obj.TotalRecord = 0;
obj.TotalLineAmount = 0;
}
objAmtdimModel.Add(obj);
}
}
}
}
return(objAmtdimModel);
}