public int InsertUpdateProjectBudgetDetail(ProjectBudgetDetailBO objProjectBudgetDetail)
{
int i = 0;
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("PKG_PROJECT_BARSIK_KARYEKRAM.PR_PROJECT_BUDGET_DETAIL");
db.AddInParameter(cmd, "V_MODE", DbType.String, objProjectBudgetDetail.Mode);
db.AddInParameter(cmd, "V_BUDG_BADFAD_ID", DbType.Decimal, objProjectBudgetDetail.BudgBadfadId);
db.AddInParameter(cmd, "V_BADFAD_ID", DbType.Decimal, objProjectBudgetDetail.BadfadId);
db.AddInParameter(cmd, "V_FIRST_T_RAKAM", DbType.Decimal, objProjectBudgetDetail.FirstTRakam);
db.AddInParameter(cmd, "V_SECOND_T_RAKAM", DbType.Decimal, objProjectBudgetDetail.SecondTRakam);
db.AddInParameter(cmd, "V_THIRD_C_RAKAM", DbType.Decimal, objProjectBudgetDetail.ThirdCRakam);
db.AddInParameter(cmd, "V_FIRST_P_RAKAM", DbType.Decimal, objProjectBudgetDetail.FirstPRakam);
db.AddInParameter(cmd, "V_SECOND_P_RAKAM", DbType.Decimal, objProjectBudgetDetail.SecondPRakam);
db.AddInParameter(cmd, "V_THIRD_P_RAKAM", DbType.Decimal, objProjectBudgetDetail.ThirdPRakam);
db.AddInParameter(cmd, "V_FISCAL_YEAR_ID", DbType.Decimal, objProjectBudgetDetail.FiscalYearId);
db.AddInParameter(cmd, "V_S_BH_MAG_GARNE_F", DbType.Decimal, objProjectBudgetDetail.SBhMagGarneF);
db.AddInParameter(cmd, "V_S_BH_MAG_GARNE_S", DbType.Decimal, objProjectBudgetDetail.SBhMagGarneS);
db.AddInParameter(cmd, "V_S_BH_MAG_GARNE_T", DbType.Decimal, objProjectBudgetDetail.SBhMagGarneT);
db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_MAG_F", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaMagF);
db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_MAG_S", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaMagS);
db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_MAG_T", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaMagT);
db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_PRAPTA_F", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaPraptaF);
db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_PRAPTA_S", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaPraptaS);
db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_PRAPTA_T", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaPraptaT);
return(db.ExecuteNonQuery(cmd));
}
public DataTable PopulateBudgDetail(ProjectBudgetDetailBO objProjectBudgetDetail)
{
// db = DatabaseFactory.CreateDatabase("connStr");
DataSet ds = null;
DataTable dt = null;
ds = db.ExecuteDataSet("PKG_PROJECT_BARSIK_KARYEKRAM.PR_POPULATE_BUDGET_BADFAD", objProjectBudgetDetail.ProjectId, objProjectBudgetDetail.FiscalYearId, OracleDbType.RefCursor);
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
protected void PopulateDonarAmountDetails()
{
ProjectBudgetDetailBO objPBudgBO = new ProjectBudgetDetailBO();
//objProjectBO.BudgetHeadId = ddlBudgetHeadId;
objPBudgBO.ProjectId = Session["projectId"].ToInt32();//change after
objPBudgBO.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32();
objBarsikService = new BarsikKaryekramService();
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
DataTable dtShrotgatAayojanBadfad = objBarsikService.PopulateBudgDetail(objPBudgBO);
dtA = dtShrotgatAayojanBadfad;
if (dtShrotgatAayojanBadfad != null && dtShrotgatAayojanBadfad.Rows.Count > 0)
{
rptAayojanaBadfad.DataSource = dtShrotgatAayojanBadfad;
rptAayojanaBadfad.DataBind();
}
}
public DataTable PopulateBarsikThekaParamarsa(ProjectBudgetDetailBO objProjectBudgetDetail)
{
// db = DatabaseFactory.CreateDatabase("connStr");
DataSet ds = null;
DataTable dt = null;
/*ds = db.ExecuteDataSet("PKG_PROJECT_BARSIK_KARYEKRAM.PR_POPULATE_PARAMARSA_BIBARAN",
* objProjectBudgetDetail.ProjectId, objProjectBudgetDetail.FiscalYearId,
* OracleDbType.RefCursor);*/
ds = db.ExecuteDataSet("PKG_PROJECT_BARSIK_KARYEKRAM.PR_POPULATE_PARAMARSA_THEKKA",
objProjectBudgetDetail.ProjectId, objProjectBudgetDetail.FiscalYearId,
OracleDbType.RefCursor);
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
protected void PopulaterThekaParamarsaDetail()
{
ProjectBudgetDetailBO objPBudgBO = new ProjectBudgetDetailBO();
DataTable dt = null;
objPBudgBO.ProjectId = Session["projectId"].ToInt32();//change after
objPBudgBO.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32();
objBarsikService = new BarsikKaryekramService();
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
dt = objBarsikService.PopulateBarsikThekaParamarsa(objPBudgBO);
if (dt != null && dt.Rows.Count > 0)
{
txtPSBNo.Text = dt.Rows[0]["SWADESHI"].ToString();
txtPSBRakam.Text = dt.Rows[0]["RAKAM_SWADESHI"].ToString();
txtPSFirstTNo.Text = dt.Rows[0]["P_F_T_SWADESHI_NO"].ToString();
txtPSFirstTRakam.Text = dt.Rows[0]["P_F_T_SWADESHI_RAKAM"].ToString();
txtPSSecondTNo.Text = dt.Rows[0]["P_S_T_SWADESHI_NO"].ToString();
txtPSSSecondTRakam.Text = dt.Rows[0]["P_S_T_SWADESI_RAKAM"].ToString();
txtPSThirdTNo.Text = dt.Rows[0]["P_T_T_SWADESHI_NO"].ToString();
txtPSThirdTRakam.Text = dt.Rows[0]["P_T_T_SWADESHI_RAKAM"].ToString();
txtPBBNo.Text = dt.Rows[0]["BIDESHI"].ToString();
txtPBBRakam.Text = dt.Rows[0]["RAKAM_BIDESHI"].ToString();
txtPBFirstTNo.Text = dt.Rows[0]["P_F_T_BIDESHI_NO"].ToString();
txtPBFirstTRakam.Text = dt.Rows[0]["P_F_T_BIDESHI_RAKAM"].ToString();
txtPBSecondTNo.Text = dt.Rows[0]["P_S_T_BIDESHI_NO"].ToString();
txtPBSecondTRakam.Text = dt.Rows[0]["P_S_T_BIDESHI_RAKAM"].ToString();
txtPBThirdTNo.Text = dt.Rows[0]["P_T_T_BIDESHI_NO"].ToString();
txtPBThirdTRakam.Text = dt.Rows[0]["P_T_T_BIDESHI_RAKAM"].ToString();
txtThekaBNo.Text = dt.Rows[0]["THEKKA_SANKHYA"].ToString();
txtThekaBRakam.Text = dt.Rows[0]["THEKKA_RAKAM"].ToString();
txtThekaFirstTNo.Text = dt.Rows[0]["THEKA_F_T_NO"].ToString();
txtThekaFirstTRakam.Text = dt.Rows[0]["THEKA_F_T_RAKAM"].ToString();
txtThekaSecondTNO.Text = dt.Rows[0]["THEKA_S_T_NO"].ToString();
txtThekaSecondTRakam.Text = dt.Rows[0]["THEKA_S_T_RAKAM"].ToString();
txtThekaThirdTNo.Text = dt.Rows[0]["THEKA_T_T_NO"].ToString();
txtThekaThirdTRakam.Text = dt.Rows[0]["THEKA_T_T_RAKAM"].ToString();
lblModification.Text = dt.Rows[0]["MODIFIED_DATE"].ToDateTime().ToString("D");
lblModifiedBy.Text = dt.Rows[0]["MODIFIED_BY"].ToString();
hidThekaParamarsaId.Value = dt.Rows[0]["BARSIK_THEKA_P_ID"].ToString();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
ProjectBudgetDetailBO objBudgProject = new ProjectBudgetDetailBO();
DropDownList ddlShrot = new DropDownList();
DropDownList ddlBhuktaniPrakar = new DropDownList();
TextBox txtRakam = new TextBox();
TextBox txtFirstTRakam = new TextBox();
TextBox txtSecondTRakam = new TextBox();
TextBox txtThirdTRakam = new TextBox();
HiddenField hidBadfadId = new HiddenField();
foreach (RepeaterItem rptItem in rptAayojanaBadfad.Items)
{
int k = 0;
ddlShrot = (DropDownList)rptItem.FindControl("ddlShrot");
ddlBhuktaniPrakar = (DropDownList)rptItem.FindControl("ddlBhuktaniPrakar");
txtRakam = (TextBox)rptItem.FindControl("txtRakam");
txtFirstTRakam = (TextBox)rptItem.FindControl("txtFirstTRakam");
txtSecondTRakam = (TextBox)rptItem.FindControl("txtSecondTRakam");
txtThirdTRakam = (TextBox)rptItem.FindControl("txtThirdTRakam");
hidBadfadId = (HiddenField)rptItem.FindControl("hidBadfadId");
objBudgProject.BadfadId = hidBadfadId.Value.ToDecimal();
objBudgProject.FirstTRakam = txtFirstTRakam.Text.ToDecimal();
objBudgProject.SecondTRakam = txtSecondTRakam.Text.ToDecimal();
objBudgProject.ThirdCRakam = txtThirdTRakam.Text.ToDecimal();
objBudgProject.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32();
objBudgProject.Mode = "I";
objBarsikService = new BarsikKaryekramService();
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
objBarsikService.InsertUpdateProjectBudgDetail(objBudgProject);
}
ProjectBarsikThekaParamarsaBO objThekaParamarsa = new ProjectBarsikThekaParamarsaBO();
//barshikAnya
ProjectBarshikAnyaBO objBarshikAnyaBo = new ProjectBarshikAnyaBO();
objBarshikAnyaBo.ProjectId = Session["projectId"].ToInt32();
objBarshikAnyaBo.FiscalYearId = Session["fiscal_year_id"].ToInt32();
objBarshikAnyaBo.FirstRakamAnya = txtAnyaFirst.Text.ToDecimal();
objBarshikAnyaBo.SecondRakamAnya = txtAnyaSecond.Text.ToDecimal();
objBarshikAnyaBo.ThirdRakamAnya = txtAnyaThird.Text.ToDecimal();
objBarshikAnyaBo.RemarksAnya = txtAnyaRemarks.Text;
objBarsikService = new BarsikKaryekramService();
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
if (hidBarshikAnyaId.Value == "")
{
objBarshikAnyaBo.Mode = "I";
}
else
{
objBarshikAnyaBo.Mode = "U";
objBarshikAnyaBo.BarshikAnyaID = hidBarshikAnyaId.Value.ToInt32();
}
//barshikBharit
BarsikBharitBo objBarsikBharitBo = new BarsikBharitBo();
objBarsikBharitBo.ProjectId = Session["projectId"].ToInt32();
objBarsikBharitBo.FiscalYearId = Session["fiscal_year_id"].ToInt32();
objBarsikBharitBo.BarshikBharitLakshya = txtBarshik.Text.ToDecimal();
objBarsikBharitBo.FirstBharitLakshya = txtFirstBharit.Text.ToDecimal();
objBarsikBharitBo.SecondBharitLakshya = txtSecondBharit.Text.ToDecimal();
objBarsikBharitBo.ThirdBharitLakshya = txtThirdBharit.Text.ToDecimal();
if (hidBarshikBharitId.Value == "")
{
objBarsikBharitBo.Mode = "I";
}
else
{
objBarsikBharitBo.Mode = "U";
}
if (hidThekaParamarsaId.Value == "")
{
objThekaParamarsa.Mode = "I";
}
else
{
objThekaParamarsa.Mode = "U";
objThekaParamarsa.BarsikThekaPId = hidThekaParamarsaId.Value.ToDecimal();
}
//paramarsa swadeshi
objThekaParamarsa.PFTSwadeshiNo = txtPSFirstTNo.Text.ToDecimal();
objThekaParamarsa.PFTSwadeshiRakam = txtPSFirstTRakam.Text.ToDecimal();
objThekaParamarsa.PSTSwadeshiNo = txtPSSecondTNo.Text.ToDecimal();
objThekaParamarsa.PSTSwadesiRakam = txtPSSSecondTRakam.Text.ToDecimal();
objThekaParamarsa.PTTSwadeshiNo = txtPSThirdTNo.Text.ToDecimal();
objThekaParamarsa.PTTSwadeshiRakam = txtPSThirdTRakam.Text.ToDecimal();
//pragati
objThekaParamarsa.PFPSwadeshiNo = 0;
objThekaParamarsa.PFPSwadeshiRakam = 0;
objThekaParamarsa.PSPSwadeshiNo = 0;
objThekaParamarsa.PSPSwadesiRakam = 0;
objThekaParamarsa.PTPSwadeshiNo = 0;
objThekaParamarsa.PTPSwadeshiRakam = 0;
//end
//paramarsadata bideshi
objThekaParamarsa.PFTBideshiNo = txtPBFirstTNo.Text.ToDecimal();
objThekaParamarsa.PFTBideshiRakam = txtPBFirstTRakam.Text.ToDecimal();
objThekaParamarsa.PSTBideshiNo = txtPBSecondTNo.Text.ToDecimal();
objThekaParamarsa.PSTBideshiRakam = txtPBSecondTRakam.Text.ToDecimal();
objThekaParamarsa.PTTBideshiNo = txtPBThirdTNo.Text.ToDecimal();
objThekaParamarsa.PTTBideshiRakam = txtPBThirdTRakam.Text.ToDecimal();
//pragati
objThekaParamarsa.PFPBideshiNo = 0;
objThekaParamarsa.PFPBideshiRakam = 0;
objThekaParamarsa.PSPBideshiNo = 0;
objThekaParamarsa.PSPBideshiRakam = 0;
objThekaParamarsa.PTPBideshiNo = 0;
objThekaParamarsa.PTPBideshiRakam = 0;
//end
//
//theka details//
objThekaParamarsa.ThekaFTNo = txtThekaFirstTNo.Text.ToDecimal();
objThekaParamarsa.ThekaFTRakam = txtThekaFirstTRakam.Text.ToDecimal();
objThekaParamarsa.ThekaSTNo = txtThekaSecondTNO.Text.ToDecimal();
objThekaParamarsa.ThekaSTRakam = txtThekaSecondTRakam.Text.ToDecimal();
objThekaParamarsa.ThekaTTNo = txtThekaThirdTNo.Text.ToDecimal();
objThekaParamarsa.ThekaTTRakam = txtThekaThirdTRakam.Text.ToDecimal();
//pragati
objThekaParamarsa.ThekaFPNo = 0;
objThekaParamarsa.ThekaFPRakam = 0;
objThekaParamarsa.ThekaSPNo = 0;
objThekaParamarsa.ThekaSPRakam = 0;
objThekaParamarsa.ThekaTPNo = 0;
objThekaParamarsa.ThekaTPRakam = 0;
//end
objThekaParamarsa.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32();
objThekaParamarsa.ProjectId = Session["projectId"].ToInt32();
objThekaParamarsa.ModifiedBy = Session["username"].ToString();
objThekaParamarsa.ModifiedDate = DateTime.Now;
objBarsikService.InsertUpdateProjectBarsikThekaParamarsa(objThekaParamarsa);
//upload multiple files
ProjectBarsikThekaParamarsaBO objBo = new ProjectBarsikThekaParamarsaBO();
objBarsikService = new BarsikKaryekramService();
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
//insert barshik anya
int a = objBarsikService.InsertUpdateBarshikAnya(objBarshikAnyaBo);
int b = objBarsikService.InsertUpdateBarshikBharit(objBarsikBharitBo);
objBo.FiscalYearId = Session["fiscal_year_id"].ToInt32();
objBo.ProjectId = Session["projectId"].ToInt32();
string allFiles = "";
///// file upload remains
if (FileBarshikUpload.HasFile) // CHECK IF ANY FILE HAS BEEN SELECTED.
{
HttpFileCollection hfc = Request.Files;
for (int f = 0; f <= hfc.Count - 1; f++)
{
HttpPostedFile hpf = hfc[f];
if (hpf.ContentLength > 0)
{
string fileName;
fileName = DateTime.Now + hpf.FileName;
string ext = System.IO.Path.GetExtension(hpf.FileName);
var splitseparator = new string[] { ext };
var result = Splitstring(fileName, splitseparator);
String source = result[0];
string str = source + ext;
str = Regex.Replace(str, @"/", "_");
str = Regex.Replace(str, @":", "_");
str = Regex.Replace(str, @" ", "_");
str = Regex.Replace(str, @",", "_");
String newfolder = Server.MapPath("~") + @"BarshikFiles\";
String path = newfolder + str;
hpf.SaveAs(path);
allFiles += str + ",";
}
}
objBo.BarshikFileName = allFiles;
}
else
{
DataTable BarshikFile = (DataTable)Session["dtBarshikFile"];
if (BarshikFile != null && BarshikFile.Rows.Count > 0)
{
//update case
objBo.BarshikFileName = Session["existingFilename"].ToString();
}
else
{
//insert case
objBo.BarshikFileName = "";
}
}
wbs = new ProjectService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject();
int j = objBarsikService.InsertUpdateBarshikFile(objBo);
Response.Redirect(Constants.ConstantAppPath + "/Modules/BarsikKaryekram/BarsikKaryekram.aspx");
/*if (FileBarshik.HasFile)
* {
* ProjectBarsikThekaParamarsaBO objBo = new ProjectBarsikThekaParamarsaBO();
* objBarsikService = new BarsikKaryekramService();
* objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
* //lblImage.Text = DateTime.Now + FileBarshik.FileName;
* string ext = System.IO.Path.GetExtension(this.FileBarshik.PostedFile.FileName);
* var splitseparator = new string[] { ext };
* var result = Splitstring(DateTime.Now + FileBarshik.FileName, splitseparator);
* String source = result[0];
* string str = source + ext;
* str = Regex.Replace(str, @"/", "_");
* str = Regex.Replace(str, @":", "_");
* objBo.BarshikFileName = str;
* objBo.FiscalYearId = Session["fiscal_year_id"].ToInt32();
* objBo.ProjectId = Session["projectId"].ToInt32();
* UploadFile(FileBarshik, str);
* int i=objBarsikService.InsertUpdateBarshikFile(objBo);
*
* }*/
}
public DataTable PopulateBarsikThekaParamarsa(ProjectBudgetDetailBO objProjectBudgetDetail)
{
Authentication();
return(objBarsikDal.PopulateBarsikThekaParamarsa(objProjectBudgetDetail));
}
public DataTable PopulateBudgDetail(ProjectBudgetDetailBO objProjectBudgetDetail)
{
Authentication();
return(objBarsikDal.PopulateBudgDetail(objProjectBudgetDetail));
}
public int InsertUpdateProjectBudgDetail(ProjectBudgetDetailBO objProjectDetail)
{
Authentication();
return(objBarsikDal.InsertUpdateProjectBudgetDetail(objProjectDetail));
}
