protected void lnkDownload_Click(object sender, EventArgs e)
{
try
{
LinkButton lnkbtn = (LinkButton)sender;
string[] values = lnkbtn.CommandArgument.Split('@');
objProjectCls = new ProjectClass();
objProjectCls.AttachmentHandle = "T_ERECTIONACTIVITY";
DataTable dt = objProjectCls.GetPath();
string ServerPath = "D:\\" + dt.Rows[0]["t_path"].ToString() + "\\";
// string ServerPath = "D:\\" + dt.Rows[0]["t_serv"].ToString() + "\\" + dt.Rows[0]["t_path"].ToString() + "\\" + values[0];// dt.Rows[0]["Path"].ToString() + "\\" + values[0];// Server.MapPath("~/Files/") + values[0]; //
//string ServerPath = "E:\\attachmentlibrary1\\" + values[0];
//"D:\\" + dt.Rows[0]["t_path"].ToString() + "\\" + values[0];
WebClient req = new WebClient();
HttpResponse response = HttpContext.Current.Response;
response.Clear();
response.ClearContent();
response.ClearHeaders();
response.Buffer = true;
response.AddHeader("Content-Disposition", "attachment;filename=\"" + values[1] + "\"");
byte[] data = req.DownloadData(ServerPath);
response.BinaryWrite(data);
response.End();
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Could not find');", true);
}
}
protected void SendMAil(string sUsername)
{
try
{
if (txtMailTo.Text != "")
{
objProjectCls = new ProjectClass();
// objNotes.User = Request.QueryString["user"];
DataTable dtUserMail = objProjectCls.GetMAilID(sUsername);
MailMessage mM = new MailMessage();
mM.From = new MailAddress(dtUserMail.Rows[0]["EMailid"].ToString());
// mM.From = new MailAddress(txtSupplierEmail.Text);
// mM.From = new MailAddress("*****@*****.**"); // for testing only
string[] MailTo = txtMailTo.Text.Split(';');
foreach (string Mailid in MailTo)
{
mM.To.Add(new MailAddress(Mailid));
}
if (FileUpload.HasFile)
{
foreach (HttpPostedFile PostedFile in FileUpload.PostedFiles)
{
string fileName = Path.GetFileName(PostedFile.FileName);
Attachment myAttachment = new Attachment(FileUpload.FileContent, fileName);
mM.Attachments.Add(myAttachment);
}
}
//mM.To.Add(dtUserMail.Rows[0]["EmailID"].ToString());
mM.Subject = txtTitle.Text.Trim();
// mM.Subject = txtTitle.Text.Trim() + "-" + spIndex.InnerHtml;
// string file = Server.MapPath("~/Files/") + hdfFile.Value;
// mM.Attachments.Add(new System.Net.Mail.Attachment(file));
mM.Body = txtNotesDescription.Text.Trim();
mM.IsBodyHtml = true;
mM.Body = mM.Body.ToString().Replace("\n", "<br />");
SmtpClient sC = new SmtpClient("192.9.200.214", 25);
mM.Body += "<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />This mail has been triggered to draw your attention on the respective ERP/Joomla module. Please login to respective module to see further details and file attachments";
// sC.Host = "192.9.200.214"; //"smtp-mail.outlook.com"// smtp.gmail.com
// sC.Port = 25; //587
sC.DeliveryMethod = SmtpDeliveryMethod.Network;
sC.UseDefaultCredentials = false;
sC.Credentials = new NetworkCredential("*****@*****.**", "isgec");
//sC.Credentials = new NetworkCredential("adskvaultadmin", "isgec@123");
sC.EnableSsl = false; // true
sC.Timeout = 10000000;
sC.Send(mM);
// ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Mail has been sent');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Please provide proper mail id and Content');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Some technical issue Mail not sent');", true);
}
}
protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlProject.SelectedValue != null)
{
DataTable dtProjDetails = new DataTable();
string sUsername = (string)(Session["Username"]);
ProjectClass projDetail = new ProjectClass();
projDetail.sProjId = ddlProject.SelectedValue;
projDetail.User = sUsername;
dtProjDetails = projDetail.GetSelectedProjectDetails();
if (dtProjDetails.Rows.Count > 0)
{
string sProjName = (dtProjDetails.Rows[0]["t_dsca"]).ToString();
string sDept = (dtProjDetails.Rows[0]["t_dept"]).ToString();
int nDay = (int)(dtProjDetails.Rows[0]["t_day"]);
lblProjDetail.Text = projDetail.sProjId + " - " + sProjName;
Session["projId"] = projDetail.sProjId;
Session["day"] = nDay;
Session["projName"] = sProjName;
Session["Dept"] = sDept;
ShowActivity(projDetail.sProjId, nDay, sDept);
}
}
}
protected void GetProjectProgress(string username)
{
objProjectCls = new ProjectClass();
DataTable dt = objProjectCls.GetProjectProgressByID(username, Request.QueryString["cprj"], Request.QueryString["cact"]);
if (dt.Rows.Count > 0)
{
txtActivity.Text = dt.Rows[0]["t_cact"].ToString();
txtDescription.Text = dt.Rows[0]["t_dsca"].ToString();
txtScheduledStartDate.Text = Convert.ToDateTime(dt.Rows[0]["t_sdst"]).ToString("dd-MM-yyyy");
txtScheduledFinishDate.Text = Convert.ToDateTime(dt.Rows[0]["t_sdfn"]).ToString("dd-MM-yyyy");
txtRemarks.Text = dt.Rows[0]["t_remk"].ToString();
}
txtOutStartDate.Attributes.Add("type", "date");
if ((Convert.ToDateTime(dt.Rows[0]["t_otst"]).ToString("yyyy") == "1753" || Convert.ToDateTime(dt.Rows[0]["t_otst"]).ToString("yyyy") == "1900" || (dt.Rows[0]["t_otst"]).ToString() == string.Empty))
{
string sdate = "yyyy-MM-dd";
txtOutStartDate.Attributes.Add("value", sdate);
}
else
{
txtOutStartDate.Attributes.Add("value", Convert.ToDateTime(dt.Rows[0]["t_otst"]).ToString("yyyy-MM-dd"));
}
txtOutFinishDate.Attributes.Add("type", "date");
if ((Convert.ToDateTime(dt.Rows[0]["t_otfn"]).ToString("yyyy") == "1753" || Convert.ToDateTime(dt.Rows[0]["t_otfn"]).ToString("yyyy") == "1900" || (dt.Rows[0]["t_otfn"]).ToString() == string.Empty))
{
string fdate = "yyyy-MM-dd";
txtOutFinishDate.Attributes.Add("value", fdate);
}
else
{
txtOutFinishDate.Attributes.Add("value", Convert.ToDateTime(dt.Rows[0]["t_otfn"]).ToString("yyyy-MM-dd"));
}
txtActualStartDate.Attributes.Add("type", "date");
if ((Convert.ToDateTime(dt.Rows[0]["t_acsd"]).ToString("yyyy") == "1753" || Convert.ToDateTime(dt.Rows[0]["t_acsd"]).ToString("yyyy") == "1900" || (dt.Rows[0]["t_acsd"]).ToString() == string.Empty))
{
string sdate = "yyyy-MM-dd";
txtActualStartDate.Attributes.Add("value", sdate);
}
else
{
txtActualStartDate.Attributes.Add("value", Convert.ToDateTime(dt.Rows[0]["t_acsd"]).ToString("yyyy-MM-dd"));
}
txtActualFinishDate.Attributes.Add("type", "date");
if ((Convert.ToDateTime(dt.Rows[0]["t_acfn"]).ToString("yyyy") == "1753" || Convert.ToDateTime(dt.Rows[0]["t_acfn"]).ToString("yyyy") == "1900" || (dt.Rows[0]["t_acfn"]).ToString() == string.Empty))
{
string fdate = "yyyy-MM-dd";
txtActualFinishDate.Attributes.Add("value", fdate);
}
else
{
txtActualFinishDate.Attributes.Add("value", Convert.ToDateTime(dt.Rows[0]["t_acfn"]).ToString("yyyy-MM-dd"));
btnUpdate.Enabled = false;
}
}
protected void lnkUpdate_Click(object sender, EventArgs e)
{
try
{
LinkButton lnkBtn = (LinkButton)sender;
string[] Value = lnkBtn.CommandArgument.Split('&');
string uId = Value[0];
hdfUser.Value = uId;
hdfNoteId.Value = Value[1];
objProjectCls = new ProjectClass();
objProjectCls.NoteID = Value[1];
DataTable dt = objProjectCls.GetNotesByRunningId();
txtMailTo.Text = dt.Rows[0]["SendEmailTo"].ToString();
txtTitle.Text = dt.Rows[0]["Title"].ToString();
txtNotesDescription.Text = dt.Rows[0]["Description"].ToString();
//add color to desc and button
txtNotesDescription.Attributes.Add("style", "background-color:" + dt.Rows[0]["ColorId"].ToString() + ";");
btnNewNotes.Attributes.Add("style", "background-color:" + dt.Rows[0]["ColorId"].ToString() + ";");
//------
// txtMailIdReminder.Text = dt.Rows[0]["ReminderTo"].ToString();
// txtDate.Text = dt.Rows[0]["ReminderDateTime"].ToString() != "" ? Convert.ToDateTime(dt.Rows[0]["ReminderDateTime"].ToString()).ToString("dd-MM-yyyy") : "";
string sUsername = (string)(Session["Username"]);
// sUsername = "******";// for testing only
//if (uId == Request.QueryString["user"])
if (uId == sUsername)
{
txtTitle.Enabled = true;
txtNotesDescription.Enabled = true;
btnSaveNotes.Text = "Update";
btnSaveNotes.Enabled = true;
btnDeleteNotes.Enabled = true;
btnDeleteNotes.Visible = true;
txtMailTo.Enabled = true;
}
else
{
txtTitle.Enabled = false;
txtNotesDescription.Enabled = false;
btnSaveNotes.Enabled = false;
btnDeleteNotes.Enabled = false;
txtMailTo.Enabled = false;
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('You are not authorised to update records');", true);
}
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not Update');", true);
}
}
public static List <ProjectClass> GetProject(string userName, string ProjectId, int nDay, string Dept)
{
string conStrng = string.Empty;
List <ProjectClass> ProjectDetails = new List <ProjectClass>();
if (userName == "isgec" || userName == "3194" || userName == "0330")
{
conStrng = cs;
}
else
{
conStrng = csLive;
}
using (SqlConnection con = new SqlConnection(conStrng))
{
string Getproj = @"select top 100 a.t_cprj, a.t_remk, a.t_cact, a.t_sdst, a.t_sdfn, a.t_acsd, a.t_acfn, a.t_dsca, b.t_dsca from ttpisg910200 a join ttcmcs052200 b on a.t_cprj = b.t_cprj WHERE a.t_cprj = '" + ProjectId + "' and a.t_dept = '" + Dept + "' and UPPER(a.t_pact)not in ('PARENT') and t_sdst <= (GETDATE() + " + nDay + ") and a.t_acfn in ('1753-01-01','1900-01-01') order by a.t_sdst asc";
SqlCommand cmd = new SqlCommand(Getproj, con);
cmd.CommandType = CommandType.Text;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
ProjectClass projDetail = new ProjectClass();
projDetail.Activity = (rdr["t_dsca"]).ToString();
projDetail.ActivityID = (rdr["t_cact"]).ToString();
projDetail.ScheduledStartDate = Convert.ToDateTime(rdr["t_sdst"]);
projDetail.ScheduledFinishedDate = Convert.ToDateTime(rdr["t_sdfn"]);
projDetail.ActualStartDate = Convert.ToDateTime(rdr["t_acsd"]);
projDetail.ActualFinishDate = Convert.ToDateTime(rdr["t_acfn"]);
projDetail.sRemarks = (rdr["t_remk"]).ToString();
ProjectDetails.Add(projDetail);
}
}
else
{
//lblActivityShow.Visible = false;
//mydiv.Visible = false;
//Label5.Visible = true;
//Label5.Text = "No Activity found with such description !";
}
return(ProjectDetails);
}
}
private void GetNotes()
{
try
{
objProjectCls = new ProjectClass();
string sProjId = (string)(Session["projId"]);
string sLogisticCompany = objProjectCls.GetLogisticCompany(sProjId);
objProjectCls.NotesHandle = "T_ERECTIONACTIVITY_" + sLogisticCompany + "";
objProjectCls.AttachmentHandle = "T_ERECTIONACTIVITY_" + sLogisticCompany + "";
objProjectCls.IndexValue = hdfNoteId.Value;
//DataTable dt = objProjectCls.GetNotesFromASPNETUSer();
DataTable dt = objProjectCls.GetNotes();
if (dt.Rows.Count > 0)
{
rptNotes.DataSource = dt;
rptNotes.DataBind();
}
else
{
//ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('No record found');", true);
}
// DataTable dtAttach = objProjectCls.GetAllAttachments();
DataTable dtAttach = objProjectCls.GetAttachments();
if (dtAttach.Rows.Count > 0)
{
gvAttachment.DataSource = dtAttach;
gvAttachment.DataBind();
divNoRecord.Visible = false;
divViewAttachment.Visible = true;
}
else
{
divNoRecord.Visible = true;
divViewAttachment.Visible = false;
}
}
catch (Exception ex)
{
}
}
private void BindData()
{
try
{
DataTable dt = new DataTable();
string sUsername = (string)(Session["Username"]);
// sUsername = "******";// for testing only
//if (Request.QueryString["user"] != null)
if (sUsername != null)
{
objProjectCls = new ProjectClass();
string sProjId = (string)(Session["projId"]);
string sLogisticCompany = objProjectCls.GetLogisticCompany(sProjId);
objProjectCls.IndexValue = hdfNoteId.Value;
objProjectCls.AttachmentHandle = "T_ERECTIONACTIVITY_" + sLogisticCompany + "";
dt = objProjectCls.GetAttachments();
if (dt.Rows.Count > 0)
{
gvAttachment.DataSource = dt;
gvAttachment.DataBind();
divNoRecord.Visible = false;
divViewAttachment.Visible = true;
}
else
{
divNoRecord.Visible = true;
divViewAttachment.Visible = false;
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('No Data found');", true);
}
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
}
}
protected void btnDeleteNotes_Click(object sender, EventArgs e)
{
try
{
objProjectCls = new ProjectClass();
objProjectCls.NoteID = hdfNoteId.Value;
int res = objProjectCls.DeleteNotes();
if (res > 0)
{
txtTitle.Text = "";
txtNotesDescription.Text = "";
GetNotes();
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Deleted');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Deleted ');", true);
}
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue data Not deleted');", true);
}
}
protected void ValidateUser(string Id, string password)
{
objProjectCls = new ProjectClass();
DataTable dt = new DataTable();
int userrecord = objProjectCls.ValidateUser(Id, password);
if (userrecord > 0)
{
lblError.Visible = false;
dt = objProjectCls.GetUserRecord(Id);
Session.Add("RecordTable", dt);
Session["Username"] = Id;
if (dt.Rows.Count > 0)
{
Session["projId"] = dt.Rows[0]["t_cprj"];
Session["day"] = dt.Rows[0]["t_day"];
Session["projName"] = dt.Rows[0]["t_dsca"];
Session["Dept"] = dt.Rows[0]["t_dept"];
// Session["DrpProj"] = dt.Rows[0]["drpdwn"];
Response.Redirect("ProjectProgressReport.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page),
"alert", "alert('User is not associated with any Project');", true);
}
}
else
{
lblError.Visible = true;
//ScriptManager.RegisterStartupScript(this, typeof(Page),
// "alert", "alert('The Username and/or password you have entered is invalid');", true);
}
}
protected void UploadAttachment(string NotesId)
{
try
{
string sUsername = (string)(Session["Username"]);
// sUsername = "******";// for testing only
//if (Request.QueryString["user"] != null)
if (sUsername != null)
{
objProjectCls = new ProjectClass();
// objProjectCls.IndexValue = Request.QueryString["Index"];
objProjectCls.AttachmentHandle = "T_ERECTIONACTIVITY";
DataTable dt = objProjectCls.GetPath();
if (dt.Rows.Count > 0)
{
//string ServerPath = dt.Rows[0]["t_serv"].ToString() + "\\"+ "D:\\" + dt.Rows[0]["t_path"].ToString() + "\\"; //dt.Rows[0]["Path"].ToString() + "\\";// // Server.MapPath("~/Files/");//
string ServerPath = "D:\\" + dt.Rows[0]["t_path"].ToString() + "\\"; //dt.Rows[0]["Path"].ToString() + "\\";// // Server.MapPath("~/Files/");//
//attachmentlibrary1
// string ServerPath = "E:\\attachmentlibrary1\\";
string LocalPath = Server.MapPath("~/Files/");
if (FileUpload.HasFile)
{
int filecount = 0;
filecount = FileUpload.PostedFiles.Count;
if (filecount > 0)
{
foreach (HttpPostedFile PostedFile in FileUpload.PostedFiles)
{
string fileName = Path.GetFileNameWithoutExtension(PostedFile.FileName);
string fileExtension = Path.GetExtension(PostedFile.FileName);
try
{
objProjectCls = new ProjectClass();
objProjectCls.AttachmentHandle = "T_ERECTIONACTIVITY";
objProjectCls.IndexValue = NotesId;
objProjectCls.PurposeCode = "Attachment for Mobile App Notes";// Request.QueryString["PurposeCode"];
//objProjectCls.AttachedBy = Request.QueryString["user"];
objProjectCls.AttachedBy = sUsername;
objProjectCls.FileName = fileName + fileExtension;
objProjectCls.LibraryCode = dt.Rows[0]["LibCode"].ToString();
//"LIB000001";
// DataTable dtFile = objProjectCls.GetFileName();
// if (dtFile.Rows.Count == 0)
// {
DataTable dtDocID = objProjectCls.InsertAttachment();
if (dtDocID.Rows[0][0].ToString() != "0")
{
try
{
string AttachServerPath = ServerPath + dtDocID.Rows[0][0];
FileUpload.SaveAs(AttachServerPath);
}
catch (Exception ex)
{
// err.Text = ex.Message;
}
// FileUpload.SaveAs(LocalPath + fileName + fileExtension);
HttpContext.Current.Cache.Remove("ATHData");
//AttachmentBindData(NotesId);
BindData();
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Uploaded');", true);
}
else
{
//objProjectCls = new AttachmentCls();
//objProjectCls.DocumentId = dtDocID.Rows[0][0].ToString();
//int res = objProjectCls.DeleteAttachment();
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Attachment Handle does not exist');", true);
}
// }
// else
// {
// ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('This file name already exist please change your file name');", true);
// }
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('" + ex.Message + "');", true);
}
}
}
else
{
}
}
}
else
{
}
// }
//else
//{
// ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Attachment Handle does not exist');", true);
//}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data not found Properly');", true);
}
}
catch (Exception ex)
{
}
}
protected void btnSaveNotes_Click(object sender, EventArgs e)
{
try
{
string sUsername = (string)(Session["Username"]);
// sUsername = "******"; // for testing only
if (txtTitle.Text != "" && txtNotesDescription.Text != "")
{
objProjectCls = new ProjectClass();
string sProjId = (string)(Session["projId"]);
string sLogisticCompany = objProjectCls.GetLogisticCompany(sProjId);
objProjectCls.NotesHandle = "T_ERECTIONACTIVITY_" + sLogisticCompany + "";
objProjectCls.IndexValue = hdfNoteId.Value;
//Request.QueryString["cprj"].ToString() + "_" + Request.QueryString["cact"];
//hdfWFID.Value;
objProjectCls.Title = txtTitle.Text.Trim();
objProjectCls.Description = txtNotesDescription.Text.Trim();
//objProjectCls.User = Request.QueryString["user"];
objProjectCls.User = sUsername;
objProjectCls.SendEmailTo = txtMailTo.Text;
objProjectCls.RemiderMailId = "";
objProjectCls.ReminderDateTime = "";
//objNotes.ReminderDateTime =txtDate.Text!=""? Convert.ToDateTime(txtDate.Text.Trim()).ToString("yyyy-MM-dd") +" "+ txtTime.Text.Trim(): System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " " + txtTime.Text.Trim();
if (btnSaveNotes.Text == "Submit")
{
DataTable dtNotesID = objProjectCls.Insertdata();
if (dtNotesID.Rows[0][0].ToString() != "0")
{
SendMAil(sUsername);
UploadAttachment(objProjectCls.IndexValue);
txtTitle.Text = "";
txtNotesDescription.Text = "";
GetNotes();
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Saved');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Notes Handle does not exist');", true);
}
}
// Update
else
{
objProjectCls.NoteID = hdfNoteId.Value;
int res = objProjectCls.UpdateNotes();
SendMAil(sUsername);
if (res > 0)
{
GetNotes();
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Updated');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Updated');", true);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Please Enter all fields');", true);
}
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not Saved');", true);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string sUsername = (string)(Session["Username"]);
string Actual_SDate;
string Actual_FDate;
string Outlook_SDate;
string Outlook_FDate;
string Remarks;
try
{
objProjectCls = new ProjectClass();
if (txtOutStartDate.Text == "")
{
Outlook_SDate = "";
}
else
{
Outlook_SDate = Convert.ToDateTime(txtOutStartDate.Text).ToString("yyyy-MM-dd");
}
if (txtOutFinishDate.Text == "")
{
Outlook_FDate = "";
}
else
{
Outlook_FDate = Convert.ToDateTime(txtOutFinishDate.Text).ToString("yyyy-MM-dd");
}
if (txtActualStartDate.Text == "")
{
Actual_SDate = "";
}
else
{
Actual_SDate = Convert.ToDateTime(txtActualStartDate.Text).ToString("yyyy-MM-dd");
}
if (txtActualFinishDate.Text == "")
{
Actual_FDate = "";
}
else
{
Actual_FDate = Convert.ToDateTime(txtActualFinishDate.Text).ToString("yyyy-MM-dd");
}
if (txtRemarks.Text == "")
{
Remarks = "";
}
else
{
Remarks = txtRemarks.Text.ToString();
}
int res = objProjectCls.UpdatRecords(sUsername, Request.QueryString["cprj"], Request.QueryString["cact"], Actual_SDate, Actual_FDate, Remarks, Outlook_SDate, Outlook_FDate);
if (res > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Updated');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Updated');", true);
}
}
catch (Exception ex)
{
string tt = ex.Message;
}
GetNotes();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string sProjId = (string)(Session["projId"]);
int nDay = (int)(Session["day"]);
string sProjname = (string)(Session["projName"]);
string sUsername = (string)(Session["Username"]);
string sDept = (string)(Session["Dept"]);
lblProjDetail.Text = sProjId + " - " + sProjname;
lblActivityShow.Text = "Activities to be started upto " + (DateTime.Today.AddDays(nDay)).ToString("dd-MM-yyyy");
string search = txtDsc.Text;
string conStrng = string.Empty;
List <ProjectClass> ProjectDetails = new List <ProjectClass>();
if (sUsername == "isgec" || sUsername == "3194" || sUsername == "0330")
{
conStrng = cs;
}
else
{
conStrng = csLive;
}
using (SqlConnection con = new SqlConnection(conStrng))
{
string SearchActivity = @"select top 100 a.t_cprj, a.t_remk, a.t_cact, a.t_sdst, a.t_sdfn, a.t_acsd, a.t_acfn,a.t_dsca, b.t_dsca from ttpisg910200 a inner join ttcmcs052200 b on a.t_cprj=b.t_cprj WHERE a.t_cprj = '" + sProjId + "' and a.t_dept = '" + sDept + "' and UPPER(a.t_dsca) like '%" + search.ToUpper() + "%' and UPPER(a.t_pact) not in ('PARENT') and t_sdst <= (GETDATE() + 30) order by a.t_sdst asc";
SqlCommand cmd = new SqlCommand(SearchActivity, con);
cmd.CommandType = CommandType.Text;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
lblActivityShow.Visible = true;
mydiv.Visible = true;
Label5.Visible = false;
while (rdr.Read())
{
ProjectClass projDetail = new ProjectClass();
projDetail.Activity = (rdr["t_dsca"]).ToString();
projDetail.ActivityID = (rdr["t_cact"]).ToString();
projDetail.ScheduledStartDate = Convert.ToDateTime(rdr["t_sdst"]);
projDetail.ScheduledFinishedDate = Convert.ToDateTime(rdr["t_sdfn"]);
projDetail.ActualStartDate = Convert.ToDateTime(rdr["t_acsd"]);
projDetail.ActualFinishDate = Convert.ToDateTime(rdr["t_acfn"]);
projDetail.sRemarks = (rdr["t_remk"]).ToString();
ProjectDetails.Add(projDetail);
}
List <ProjectClass> tmp = ProjectDetails;
string str = "";
str += "<table class='table'><thead><tr class='btn-dark'>";
str += "<td>Activity</td><td>Schedule Start Date</td><td>Scheduled Finish Date</td>";
str += "</tr></thead>";
foreach (ProjectClass x in tmp)
{
if ((x.ActualFinishDate).ToString("dd-mm-yyyy") != ("01-00-1900") && (x.ActualFinishDate).ToString("dd-mm-yyyy") != ("01-00-1753"))
{
str += "<tr class='table-success'><td><a style='text-decoration:none; color: black' target='_blank' href='UpdateProjectProgress.aspx?cprj=" + sProjId + "&cact=" + x.ActivityID + "'>" + x.Activity + "</a></td><td>" + x.ScheduledStartDate.ToString("dd/MM/yyyy") + "</td><td>" + x.ScheduledFinishedDate.ToString("dd/MM/yyyy") + "</td></tr>";
}
else if ((x.sRemarks != string.Empty || ((x.ActualStartDate).ToString("dd-mm-yyyy") != ("01-00-1900") && (x.ActualStartDate).ToString("dd-mm-yyyy") != ("01-00-1753"))))
{
str += "<tr class='table-info'><td><a style='text-decoration:none; color: black' target='_blank' href='UpdateProjectProgress.aspx?cprj=" + sProjId + "&cact=" + x.ActivityID + "'> " + x.Activity + "</a></td><td>" + x.ScheduledStartDate.ToString("dd/MM/yyyy") + "</td><td>" + x.ScheduledFinishedDate.ToString("dd/MM/yyyy") + "</td></tr>";
}
else
{
str += "<tr class='table-warning'><td><a style='text-decoration:none; color: black' target='_blank' href='UpdateProjectProgress.aspx?cprj=" + sProjId + "&cact=" + x.ActivityID + "'>" + x.Activity + "</a></td><td>" + x.ScheduledStartDate.ToString("dd/MM/yyyy") + "</td><td>" + x.ScheduledFinishedDate.ToString("dd/MM/yyyy") + "</td></tr>";
}
}
str += "</table>";
mydiv.InnerHtml = str;
}
else
{
lblActivityShow.Visible = false;
mydiv.Visible = false;
Label5.Visible = true;
Label5.Text = "No Activity found with such description !";
}
}
}