protected void Gridreqinfo_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "edit1")
{
int DocumentId = Convert.ToInt32(e.CommandArgument);
int rst = clsDocument.InsertDocumentLog(DocumentId, Convert.ToInt32(Session["EmployeeId"]), Convert.ToDateTime(System.DateTime.Now), false, false, false, true, false, false, false, false);
string te = "DocumentEditAndView.aspx?id=" + DocumentId + "&&return=3";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", "window.open('" + te + "');", true);
}
if (e.CommandName == "delete1")
{
int DocumentId = Convert.ToInt32(e.CommandArgument);
hdncnfm.Value = DocumentId.ToString();
imgconfirmok_Click(sender, e);
// mdlpopupconfirm.Show();
}
}
protected void imgbtnupdate_Click(object sender, EventArgs e)
{
// Response.Write( ViewState["docId"] + " :: " + Convert.ToDecimal(txtnetamount.Text).ToString());
Int32 rst = clsDocument.UpdateDocumentMaster(Convert.ToInt32(ViewState["docId"]), Convert.ToInt32(ddldoctype.SelectedValue), 2, Convert.ToDateTime(lblUploadDate.Text), ViewState["decname"].ToString(), txtdoctitle.Text, txtdocdscrptn.Text, Convert.ToInt32(ddlpartyname.SelectedValue), txtdocrefnmbr.Text, Convert.ToDecimal(txtnetamount.Text), Convert.ToDateTime(txtDate.Text), ddldt.SelectedValue, txtpartdocrefno.Text);
int rst1 = clsDocument.InsertDocumentLog(Convert.ToInt32(ViewState["docId"]), Convert.ToInt32(Session["EmployeeId"]), Convert.ToDateTime(System.DateTime.Now), false, false, false, true, false, false, false, false);
if (rst > 0)
{
bool fnws = clsDocument.UpdateDocumentDateDetail(Convert.ToInt32(ViewState["docId"]), Convert.ToDateTime(txtDate.Text));
int rst111 = clsDocument.InsertDocumentLog(Convert.ToInt32(ViewState["docId"]), Convert.ToInt32(Session["EmployeeId"]), Convert.ToDateTime(System.DateTime.Now), false, false, false, true, false, false, false, false);
pnlmsg.Visible = true;
lblmsg.Text = "Document Updated Successfully.";
lblmsg.Visible = true;
fillen(true);
btncon.Visible = true;
imgbtnupdate.Visible = false;
}
}
protected void grdDocList_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "edit1")
{
int DocumentId = Convert.ToInt32(e.CommandArgument);
int rst = clsDocument.InsertDocumentLog(DocumentId, Convert.ToInt32(Session["EmployeeId"]), Convert.ToDateTime(System.DateTime.Now), false, false, false, true, false, false, false, false);
Response.Redirect("DocumentEditBeforeAllocateApprove.aspx?id=" + DocumentId + "&&return=1");
}
if (e.CommandName == "delete1")
{
int DocumentId = Convert.ToInt32(e.CommandArgument);
hdncnfm.Value = DocumentId.ToString();
mdlpopupconfirm.Show();
}
}
protected void imgbtnupload_Click(object sender, EventArgs e)
{
try
{
if (ddlpartyname.SelectedIndex > 0)
{
hdbPartyId.Value = (ddlpartyname.SelectedValue.ToString());
}
else
{
hdbPartyId.Value = "0";
}
if (ddldoctype.SelectedIndex > -1)
{
hdbDId.Value = ddldoctype.SelectedValue.ToString();
}
else
{
hdbDId.Value = "0";
}
double mul = 1073741824;
plansize = 1;
double sizeinbytes = mul * plansize;
string str = "";
str = Server.MapPath("~\\Account\\" + Session["comid"] + "\\UploadedDocuments");
string Location22 = Server.MapPath("~//Account//" + Session["comid"] + "//UploadedDocumentsTemp//");
long size = GetFolderSize(str, false);
hdnSIZEofFOLDER.Value = size.ToString();
if (fileuploadocurl.HasFile)
{
double foldsize = Convert.ToDouble(hdnSIZEofFOLDER.Value);
double hasfilesize = Convert.ToDouble(fileuploadocurl.PostedFile.ContentLength.ToString());
double totalsize = foldsize + hasfilesize;
bool access = UserAccess.Usercon("DocumentMaster", "", "DocumentId", "", "", "CID", "DocumentMaster");
if (access == true)
{
//if (totalsize <= sizeinbytes)
//{
string filename = DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + "@" + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + "_" + fileuploadocurl.FileName.Replace(" ", "_");
ViewState["filename"] = filename;
fileuploadocurl.PostedFile.SaveAs(Server.MapPath("~\\Account\\" + Session["comid"] + "\\UploadedDocuments\\") + filename);
flnam = filename;
string path2 = Server.MapPath("~\\Account\\" + Session["comid"] + "\\UploadedDocuments\\" + filename.ToString());
ViewState["filp"] = path2;
string filexten = Path.GetExtension(path2);
Int32 rst = clsDocument.InsertDocumentMaster(Convert.ToInt32(ddldoctype.SelectedValue), 2, Convert.ToDateTime(System.DateTime.Now.ToString()), filename.ToString(), txtdoctitle.Text, txtdocdscrptn.Text, Convert.ToInt32(ddlpartyname.SelectedValue), txtdocrefnmbr.Text, Convert.ToDecimal(txtnetamount.Text), Convert.ToInt32(Session["EmployeeId"]), Convert.ToDateTime(TxtDocDate.Text), filexten);
if (rst > 0)
{
string Location12 = Server.MapPath("~//Account//" + Session["comid"] + "//DocumentImage//");
Array file1;
int nooffile1 = 0;
file1 = Directory.GetFiles(Location12);
nooffile1 = file1.Length;
// Response.Write(nooffile1);
ViewState["rst"] = rst.ToString();
bool st = Chkautoprcss.Checked;
if (st.ToString() == "True")
{
bool dcaprv = true;
//bool indc = clsDocument.insertDocumentProcessingnew(Convert.ToInt32(Session["AdminEmpId"]), rst, dcaprv);
bool indc = clsDocument.insertDocumentProcessingnew(Convert.ToInt32(Session["EmployeeId"]), rst, dcaprv);
}
bool fnws = clsDocument.UpdateDocumentDateDetail(rst, Convert.ToDateTime(TxtDocDate.Text));
lblmsg.Visible = true;
// pnlmsg.Visible = true;
int rsts = clsDocument.InsertDocumentLog(rst, Convert.ToInt32(Session["EmployeeId"]), Convert.ToDateTime(System.DateTime.Now), false, false, true, false, false, false, false, false);
// System.IO.File.Move(str + filename, Location22 + filename);
lblmsg.Text = "Document Uploaded Successfully.";
//string[] ag=new string[0];
//Main(ag);
string Location = Server.MapPath("~//Account//" + Session["comid"] + "//UploadedDocuments//");
string Location2 = Server.MapPath("~//Account//" + Session["comid"] + "//UploadedDocumentsTemp//");
string ss = "", ss1 = "";
//string Location2 = "TestOutput/test2";
sendaccessmail();
System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(Location);
bool cof = false;
foreach (System.IO.FileInfo f in dir.GetFiles("*.pdf"))
{
if (System.IO.File.GetAttributes(Location + f.Name).ToString() != System.IO.FileAttributes.Hidden.ToString())
{
if (flnam != "")
{
if (f.Name.ToString() == flnam)
{
cof = true;
string filepath = Server.MapPath("~//Account//pdftoimage.exe");
System.Diagnostics.ProcessStartInfo pti = new System.Diagnostics.ProcessStartInfo(filepath);
//string flpt = "D:\\Capman.ifilecabinet.com1\\Account\\test.txt";
//pti.FileName = Server.MapPath("~//Account//pdftoimage.exe");
pti.UseShellExecute = false;
//pti.Arguments = "@"+Server.MapPath("~//Account//") + "pdftoimage -i UploadedDocuments//" + f.Name + " " + "-o" + " " + "DocumentImage//";
//pti.Arguments = filepath;
//pti.Arguments += " "+ "-r" + " " + "VNKSURDLWQOVHPGH";
// pti.Arguments += " " + " -i UploadedDocuments//" + f.Name + " " + "-o" + " " + "DocumentImage//";//+ " " + "-r" + "VNKSURDLWQOVHPGH";
pti.Arguments = filepath + " -i UploadedDocuments//" + f.Name + " " + "-o" + " " + "DocumentImage//"; //+ " " + "-r" + "VNKSURDLWQOVHPGH";
//pdftoimage.exe= -r XIWMOMMTAGFCFDMD;
filepath += " " + "-r" + " " + "XIWMOMMTAGFCFDMD";
pti.RedirectStandardOutput = true;
pti.RedirectStandardInput = true;
pti.RedirectStandardError = true;
//pti.WorkingDirectory = "D:\\Capman.ifilecabinet.com1\\Account\\";
pti.WorkingDirectory = Server.MapPath("~//Account//" + Session["comid"] + "//");
System.Diagnostics.Process ps = Process.Start(pti);
if (System.IO.File.Exists(Location + f.Name))
{
}
else
{
System.IO.File.Copy(Location2 + f.Name, Location + f.Name);
}
// System.IO.File.SetAttributes(Location2 + f.Name, System.IO.FileAttributes.Hidden);
}
}
}
}
if (cof == false)
{
if (System.IO.File.Exists(Location2 + flnam))
{
}
else
{
System.IO.File.Copy(Location + flnam, Location2 + flnam);
}
System.IO.File.SetAttributes(Location + flnam, System.IO.FileAttributes.Hidden);
}
if (Chkautoprcss.Checked == false)
{
bool insdata;
DataTable dtt = new DataTable();
DataTable DtMain = new DataTable();
//DtMain = ClsCompany.selectCompanyMaster();
//if (DtMain.Rows.Count > 0)
//{
// bool st1 = Convert.ToBoolean(DtMain.Rows[0]["AutoAllocation"].ToString());
// if (st1.ToString() == "True")
// {
dtt = new DataTable();
dtt = ClsCompany.selectAutoAllocationMaster(ddlbusiness.SelectedValue);
if (dtt.Rows.Count > 0)
{
foreach (DataRow drr in dtt.Rows)
{
Int32 empid = 0;
empid = Convert.ToInt32(drr["EmployeeId"].ToString());
insdata = false;
insdata = clsDocument.insertDocumentProcessing(empid, rst);
}
}
// }
//}
}
if (Request.QueryString["rrspd"] != null)
{
string strc = "Update F1_F2_TaxDedctionTbl Set RRSPDoc='" + rst + "' where Id='" + Request.QueryString["rrspd"] + "'";
SqlCommand cmaq = new SqlCommand(strc, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmaq.ExecuteNonQuery();
con.Close();
}
else if (Request.QueryString["f1d"] != null)
{
string strc = "Update F1_F2_TaxDedctionTbl Set F1Doc='" + rst + "' where Id='" + Request.QueryString["f1d"] + "'";
SqlCommand cmaq = new SqlCommand(strc, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmaq.ExecuteNonQuery();
con.Close();
}
else if (Request.QueryString["f2d"] != null)
{
string strc = "Update F1_F2_TaxDedctionTbl Set F2Doc='" + rst + "' where Id='" + Request.QueryString["f2d"] + "'";
SqlCommand cmaq = new SqlCommand(strc, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmaq.ExecuteNonQuery();
con.Close();
}
clear();
}
/////addede
int ii = 0;
string filepath1 = Server.MapPath("~//Account//" + Session["comid"] + "//UploadedDocuments//" + filename);
using (StreamReader st = new StreamReader(File.OpenRead(filepath1)))
{
Regex regex = new Regex(@"/Type\s*/Page[^s]");
MatchCollection match = regex.Matches(st.ReadToEnd());
ii = match.Count;
}
int length = filename.Length;
string docnameIn = filename.Substring(0, length - 4);
for (int kk = 1; kk <= ii; kk++)
{
string scpf = docnameIn;
if (kk >= 1 && kk < 10)
{
scpf = scpf + "0000" + kk + ".jpg";
}
else if (kk >= 10 && kk < 100)
{
scpf = scpf + "000" + kk + ".jpg";
}
else if (kk >= 100)
{
scpf = scpf + "00" + kk + ".jpg";
}
clsEmployee.InserDocumentImageMaster(rst, scpf);
}
//}
//else
//{
// lblmsg.Visible = true;
// // pnlmsg.Visible = true;
// lblmsg.Text = "Your Storage accede more than limit ";
//}
}
else
{
lblmsg.Visible = true;
// pnlmsg.Visible = true;
lblmsg.Text = "Sorry, You are not permitted for greater record to Priceplan";
}
}
}
catch (Exception es)
{
lblmsg.Visible = true;
// pnlmsg.Visible = true;
lblmsg.Text = "error : " + es.Message;
}
}
protected void imgbtnupdate_Click(object sender, EventArgs e)
{
if (ddlcopyormove.SelectedValue == "0")
{
foreach (GridViewRow grd in GridView2.Rows)
{
string doc = "SELECT * FROM DocumentMaster where DocumentId='" + grd.Cells[0].Text + "'";
SqlDataAdapter adp = new SqlDataAdapter(doc, con);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
bool insdata;
insdata = true;
Int32 rst = clsDocument.InsertDocumentMaster(Convert.ToInt32(ddldoctype.SelectedValue), 2, Convert.ToDateTime(dt.Rows[0]["DocumentUploadDate"]), Convert.ToString(dt.Rows[0]["DocumentName"]), Convert.ToString(dt.Rows[0]["DocumentTitle"]), Convert.ToString(dt.Rows[0]["Description"]), Convert.ToInt32(dt.Rows[0]["PartyId"]), Convert.ToString(dt.Rows[0]["DocumentRefNo"]), Convert.ToDecimal(dt.Rows[0]["DocumentAmount"]), Convert.ToInt32(Session["EmployeeId"]), Convert.ToDateTime(dt.Rows[0]["DocumentDate"]), Convert.ToString(ViewState["fileext"]), Convert.ToString(dt.Rows[0]["DocumentTypenmId"]), Convert.ToString(dt.Rows[0]["PartyDocrefno"]));
if (rst > 0)
{
//bool dcaprv = true;
//bool indc = clsDocument.insertDocumentProcessingnew(Convert.ToInt32(Session["EmployeeId"]), rst, dcaprv);
int accesslevel = 0;
string strdesig = " select DesignationMaster.* from EmployeeMaster inner join DesignationMaster ON EmployeeMaster.DesignationMasterID = DesignationMaster.DesignationMasterID where EmployeeMaster.EmployeeMasterID='" + Convert.ToInt32(Session["EmployeeId"]) + "' ";
SqlCommand cmdeeed = new SqlCommand(strdesig, con);
SqlDataAdapter adpeeed = new SqlDataAdapter(cmdeeed);
DataTable dteeed = new DataTable();
adpeeed.Fill(dteeed);
if (dteeed.Rows.Count > 0)
{
ViewState["DesignationName"] = dteeed.Rows[0]["DesignationName"].ToString();
}
if (ViewState["DesignationName"].ToString() == "Manager")
{
accesslevel = 3;
}
else if (ViewState["DesignationName"].ToString() == "Supervisor")
{
accesslevel = 2;
}
else if (ViewState["DesignationName"].ToString() == "Office Clerk")
{
accesslevel = 1;
}
else
{
accesslevel = 0;
}
string eeed = " Select * from DocumentProcessing where EmployeeId='" + Convert.ToInt32(Session["EmployeeId"]) + "' and DocumentId='" + rst + "'";
SqlCommand cmdeeedc = new SqlCommand(eeed, con);
SqlDataAdapter adpeeedc = new SqlDataAdapter(cmdeeedc);
DataTable dteeedc = new DataTable();
adpeeedc.Fill(dteeedc);
if (dteeedc.Rows.Count <= 0)
{
string str1 = " INSERT INTO DocumentProcessing (DocumentId ,EmployeeId,DocAllocateDate,CID,StatusId,Levelofaccess) VALUES ('" + rst + "' ,'" + Convert.ToInt32(Session["EmployeeId"]) + "','" + System.DateTime.Now.ToShortDateString() + "','" + Session["Comid"].ToString() + "','0','" + accesslevel + "') ";
SqlCommand cmd1 = new SqlCommand(str1, con);
con.Open();
insdata = Convert.ToBoolean(cmd1.ExecuteNonQuery());
con.Close();
}
bool fnws = clsDocument.UpdateDocumentDateDetail(rst, Convert.ToDateTime(dt.Rows[0]["DocumentDate"]));
int rsts = clsDocument.InsertDocumentLog(rst, Convert.ToInt32(Session["EmployeeId"]), Convert.ToDateTime(System.DateTime.Now), false, false, true, false, false, false, false, false);
lblmsg.Text = "Document copied successfully";
lblmsg.Visible = true;
}
}
}
}
else if (ddlcopyormove.SelectedValue == "1")
{
foreach (GridViewRow grd in GridView2.Rows)
{
string doc = "SELECT * FROM DocumentMaster where DocumentId='" + grd.Cells[0].Text + "'";
SqlDataAdapter adp = new SqlDataAdapter(doc, con);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
string sr51 = "update DocumentMaster set DocumentTypeId='" + ddldoctype.SelectedValue + "' where DocumentId='" + dt.Rows[0]["DocumentId"].ToString() + "' ";
SqlCommand cmd801 = new SqlCommand(sr51, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd801.ExecuteNonQuery();
con.Close();
lblmsg.Text = "Document moved successfully";
lblmsg.Visible = true;
}
}
}
else
{
}
}