//
public int InsertUpdateBarshikFile(ProjectBarsikThekaParamarsaBO obj)
{
int i = 0;
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("PKG_PROJECT_BARSIK_KARYEKRAM.PR_INSERT_BARSHIK_FILE");
db.AddInParameter(cmd, "V_BARSHIK_FILE_NAME", DbType.String, obj.BarshikFileName);
db.AddInParameter(cmd, "V_FISCAL_YEAR_ID", DbType.Int32, obj.FiscalYearId);
db.AddInParameter(cmd, "V_PROJECT_ID", DbType.Int32, obj.ProjectId);
return(db.ExecuteNonQuery(cmd));
}
public DataTable PopulateChaumasikFile(ProjectBarsikThekaParamarsaBO obj)
{
DbCommand cmd = db.GetStoredProcCommand("PKG_PROJECT_BARSIK_KARYEKRAM.PR_POPULATE_CHAUMASIK_FILE", obj.ProjectId, obj.FiscalYearId, obj.ChaumasikId, OracleDbType.RefCursor);
DataSet ds = null;
DataTable dt = null;
ds = db.ExecuteDataSet(cmd);
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
public int InsertUpdateProjectBarsikThekaParamarsa(ProjectBarsikThekaParamarsaBO objProjectBarsikThekaParamarsa)
{
int i = 0;
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("PKG_PROJECT_BARSIK_KARYEKRAM.PR_PRJ_BARSIK_THEKA_PARAMARSA");
db.AddInParameter(cmd, "V_MODE", DbType.String, objProjectBarsikThekaParamarsa.Mode);
db.AddInParameter(cmd, "V_BARSIK_THEKA_P_ID", DbType.Decimal, objProjectBarsikThekaParamarsa.BarsikThekaPId);
db.AddInParameter(cmd, "V_THEKA_F_T_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaFTNo);
db.AddInParameter(cmd, "V_THEKA_F_T_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaFTRakam);
db.AddInParameter(cmd, "V_P_F_T_SWADESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PFTSwadeshiNo);
db.AddInParameter(cmd, "V_P_F_T_BIDESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PFTBideshiNo);
db.AddInParameter(cmd, "V_P_F_T_SWADESHI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PFTSwadeshiRakam);
db.AddInParameter(cmd, "V_P_F_T_BIDESHI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PFTBideshiRakam);
db.AddInParameter(cmd, "V_FISCAL_YEAR_ID", DbType.Decimal, objProjectBarsikThekaParamarsa.FiscalYearId);
db.AddInParameter(cmd, "V_PROJECT_ID", DbType.Decimal, objProjectBarsikThekaParamarsa.ProjectId);
db.AddInParameter(cmd, "V_THEKA_S_T_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaSTNo);
db.AddInParameter(cmd, "V_THEKA_S_T_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaSTRakam);
db.AddInParameter(cmd, "V_THEKA_T_T_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaTTNo);
db.AddInParameter(cmd, "V_THEKA_T_T_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaTTRakam);
db.AddInParameter(cmd, "V_P_S_T_SWADESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PSTSwadeshiNo);
db.AddInParameter(cmd, "V_P_S_T_SWADESI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PSTSwadesiRakam);
db.AddInParameter(cmd, "V_P_S_T_BIDESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PSTBideshiNo);
db.AddInParameter(cmd, "V_P_S_T_BIDESHI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PSTBideshiRakam);
db.AddInParameter(cmd, "V_P_T_T_SWADESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PTTSwadeshiNo);
db.AddInParameter(cmd, "V_P_T_T_SWADESHI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PTTSwadeshiRakam);
db.AddInParameter(cmd, "V_P_T_T_BIDESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PTTBideshiNo);
db.AddInParameter(cmd, "V_P_T_T_BIDESHI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PTTBideshiRakam);
db.AddInParameter(cmd, "V_THEKA_F_P_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaFPNo);
db.AddInParameter(cmd, "V_THEKA_F_P_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaFPRakam);
db.AddInParameter(cmd, "V_P_F_P_SWADESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PFPSwadeshiNo);
db.AddInParameter(cmd, "V_P_F_P_BIDESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PFPBideshiNo);
db.AddInParameter(cmd, "V_P_F_P_SWADESHI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PFPSwadeshiRakam);
db.AddInParameter(cmd, "V_P_F_P_BIDESHI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PFPBideshiRakam);
db.AddInParameter(cmd, "V_THEKA_S_P_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaSPNo);
db.AddInParameter(cmd, "V_THEKA_S_P_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaSPRakam);
db.AddInParameter(cmd, "V_THEKA_T_P_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaTPNo);
db.AddInParameter(cmd, "V_THEKA_T_P_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.ThekaTPRakam);
db.AddInParameter(cmd, "V_P_S_P_SWADESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PSPSwadeshiNo);
db.AddInParameter(cmd, "V_P_S_P_SWADESI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PSPSwadesiRakam);
db.AddInParameter(cmd, "V_P_S_P_BIDESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PSPBideshiNo);
db.AddInParameter(cmd, "V_P_S_P_BIDESHI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PSPBideshiRakam);
db.AddInParameter(cmd, "V_P_T_P_SWADESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PTPSwadeshiNo);
db.AddInParameter(cmd, "V_P_T_P_SWADESHI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PTPSwadeshiRakam);
db.AddInParameter(cmd, "V_P_T_P_BIDESHI_NO", DbType.Decimal, objProjectBarsikThekaParamarsa.PTPBideshiNo);
db.AddInParameter(cmd, "V_P_T_P_BIDESHI_RAKAM", DbType.Decimal, objProjectBarsikThekaParamarsa.PTPBideshiRakam);
db.AddInParameter(cmd, "V_MODIFIED_DATE", DbType.DateTime, objProjectBarsikThekaParamarsa.ModifiedDate);
db.AddInParameter(cmd, "V_MODIFIED_BY", DbType.String, objProjectBarsikThekaParamarsa.ModifiedBy);
return(db.ExecuteNonQuery(cmd));
}
protected void PopulateBarshikFile()
{
/*aBarshikFile.InnerHtml = "";
* aBarshikFile.HRef = null;*/
ProjectBarsikThekaParamarsaBO objBo = new ProjectBarsikThekaParamarsaBO();
objBarsikService = new BarsikKaryekramService();
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
objBo.ProjectId = Session["projectId"].ToInt32();//change after
objBo.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32();
DataTable dtBarshikFile = objBarsikService.PopulateBarshikFile(objBo);
Session["dtBarshikFile"] = objBarsikService.PopulateBarshikFile(objBo);
if (dtBarshikFile != null && dtBarshikFile.Rows.Count > 0)
{
if (dtBarshikFile.Rows[0]["FILE_NAME"].ToString() != "")
{
lblFileWarning.Visible = true;
grdUploadedFiles.Visible = true;
string fileName = "";
Session["existingFilename"] = fileName = dtBarshikFile.Rows[0]["FILE_NAME"].ToString();
DataTable dtFile = new DataTable();
dtFile.Columns.Add("FILE_NAME");
List <string> fileList = fileName.Split(new char[] { ',' }).ToList <string>();
for (int j = 0; j < fileList.Count - 1; j++)
{
DataRow dr = dtFile.NewRow();
dr[0] = fileList[j];
dtFile.Rows.Add(dr);
}
grdUploadedFiles.DataSource = dtFile;
grdUploadedFiles.DataBind();
}
else
{
Session["existingFilename"] = "";
}
}
}
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 int InsertUpdateProjectBarsikThekaParamarsa(ProjectBarsikThekaParamarsaBO objProjectBarsikThekaParamarsa)
{
Authentication();
return(objBarsikDal.InsertUpdateProjectBarsikThekaParamarsa(objProjectBarsikThekaParamarsa));
}
public DataTable PopulateChaumasikFile(ProjectBarsikThekaParamarsaBO obj)
{
Authentication();
return(objBarsikDal.PopulateChaumasikFile(obj));
}
public int InsertUpdateChaumasikFile(ProjectBarsikThekaParamarsaBO obj)
{
Authentication();
return(objBarsikDal.InsertUpdateChaumasikFile(obj));
}
