public DataTable PopulateCluster_dal(Transaction_Prop transacprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_Transaction_PopCluster", new object[] { transacprop.UserName }).Tables[0]);
}
catch (Exception Ex)
{
throw Ex;
}
}
public DataTable PopulateCluster_dal(Transaction_Prop transacprop)
{
try
{
transactiondal = new transaction_dal();
return(transactiondal.PopulateCluster_dal(transacprop));
}
catch (Exception Ex)
{
ErrMessage = Ex.Message;
return(null);
}
}
public string TransactionInsert(Transaction_Prop transacprop)
{
try
{
transactiondal = new transaction_dal();
string strMsg = transactiondal.TransactionInsert(transacprop);
return(strMsg);
}
catch (Exception e)
{
ErrMessage = e.Message;
return("");
}
}
public string TransactionInsert(Transaction_Prop transacprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_MonthlyRFD_Insert", new object[] {
transacprop.ClusterID
, transacprop.Capacity
, transacprop.ExposureVisit
, transacprop.MarketPromotion
, transacprop.ArtisansBenefited
, transacprop.NoOFCFC
, transacprop.CFCArtisan
, transacprop.SHG
, transacprop.SHGMembers
, transacprop.ReplacementCharkhas
, transacprop.ReplacementLooms
, transacprop.ReplacementTools
, transacprop.FundCluster
, transacprop.FundSODO
, transacprop.FundIA
, transacprop.FundTools
, transacprop.FundCFC
, transacprop.FundPDDI
, transacprop.FundMPA
, transacprop.FundCBM
, transacprop.FundCostIA
, transacprop.FundCDE
, transacprop.FundTA
, transacprop.Production
, transacprop.Prod_ArtisanBenefited
, transacprop.PerCapitaProduction
, transacprop.SC_Male
, transacprop.SC_Female
, transacprop.ST_Male
, transacprop.ST_Female
, transacprop.OBC_Male
, transacprop.OBC_Female
, transacprop.Minority_Male
, transacprop.Minority_Female
, transacprop.Others_Male
, transacprop.Others_Female
, transacprop.AvgWagesSpinners
, transacprop.AvgWagesArtisan
, transacprop.AvgWagesWeavers
, transacprop.AvgEarningSpinners
, transacprop.AvgEarningArtisan
, transacprop.AvgEarningWeavers
, transacprop.Sales
, transacprop.NoOfCDCGMeeting
, transacprop.NoOfTAVisit
, transacprop.NoOfClusterMeeting
, transacprop.NoOfVisitNodalOfficer
, transacprop.NoOfStateMeeting
, transacprop.NoOfZonalMeeting
, transacprop.NoOfReviewMeeting
, transacprop.NoOfVisitVIP
, transacprop.Achievements
, transacprop.MajorLinkages
, transacprop.OtherIssues
}).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}
