//private void BindDBID()
//{
// objNotes = new NotesClass();
// DataTable dt = objNotes.GetALLDBID();
// ddlDBID.DataSource = dt;
// ddlDBID.DataTextField = "DBID";
// ddlDBID.DataValueField = "DBID";
// ddlDBID.DataBind();
//}
private void GetHandle()
{
try
{
objNotes = new NotesClass();
objNotes.NotesHandle = Request.QueryString["handle"];
DataTable dt = objNotes.GetALLHandleByID();
if (dt.Rows.Count > 0)
{
txtNotesHandle.Text = dt.Rows[0]["NotesHandle"].ToString();
txtAcessIndex.Text = dt.Rows[0]["AccessIndex"].ToString();
txtTableName.Text = dt.Rows[0]["TableName"].ToString();
txtTableDesc.Text = dt.Rows[0]["TableDescription"].ToString();
txtRemarks.Text = dt.Rows[0]["Remarks"].ToString();
txtDBID.Text = dt.Rows[0]["DBID"].ToString();
btnSaveHandle.Text = "Update";
txtNotesHandle.Enabled = false;
divHeader.InnerText = "Update Notes Handle";
}
else
{
btnSaveHandle.Text = "Save";
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
}
}
protected void lnkDelete_Click(object sender, EventArgs e)
{
try
{
objNotes = new NotesClass();
objNotes.NotesHandle = Request.QueryString["handle"];
DataTable dtHandle = objNotes.GetUsedHandle();
if (dtHandle.Rows.Count == 0)
{
int res = objNotes.DeleteNotesHandle();
if (res > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Deleted Successfully');", true);
Response.Redirect("View_NotesHandle.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Deleted');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Notes Handle used somewhere');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
}
}
protected void btnSaveColor_Click(object sender, EventArgs e)
{
try
{
if (txtUser.Text != "" && hdfColor.Value != "")
{
string[] user = txtUser.Text.Split('-');
NotesClass objNotesClass = new NotesClass();
objNotesClass.User = user[1].Trim();
objNotesClass.Color = hdfColor.Value;
int res = objNotesClass.InsertColor();
if (res > 0)
{
GEtUserColor();
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Assigned');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Assigned');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Please Enter all fields');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Some technical issue Not Assigned');", true);
}
}
private void GetNotes()
{
try
{
objNotes = new NotesClass();
objNotes.NotesHandle = Request.QueryString["handle"];
objNotes.IndexValue = Request.QueryString["index"];
DataTable dt = objNotes.GetNotesFromASPNETUSer();
if (dt.Rows.Count > 0)
{
if (Request.QueryString["Hd"] == null)
{
spIndex.InnerHtml = dt.Rows[0]["TableDescription"].ToString() + " , " + Request.QueryString["index"];
}
rptNotes.DataSource = dt;
rptNotes.DataBind();
}
else
{
if (Request.QueryString["Hd"] == null)
{
objNotes = new NotesClass();
objNotes.NotesHandle = Request.QueryString["handle"];
DataTable dtHandle = objNotes.GetALLHandleByID();
spIndex.InnerHtml = dtHandle.Rows[0]["TableDescription"].ToString() + " , " + Request.QueryString["Index"];
}
//ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('No record found');", true);
}
}
catch (Exception ex)
{
}
}
private void BindNotesHandle()
{
NotesClass objNotes = new NotesClass();
DataTable dt = objNotes.GetALLNotesHandle();
gvData.DataSource = dt;
gvData.DataBind();
}
private void GEtUserColor()
{
NotesClass objNotesClass = new NotesClass();
DataTable dt = objNotesClass.GEtUSerColor();
gvdata.DataSource = dt;
gvdata.DataBind();
}
protected void btnSaveHandle_Click(object sender, EventArgs e)
{
try
{
if (txtNotesHandle.Text != "" && txtAcessIndex.Text != "" && txtTableName.Text != "")
{
objNotes = new NotesClass();
objNotes.DBID = txtDBID.Text.Trim();
objNotes.NotesHandle = txtNotesHandle.Text.Trim();
objNotes.IndexValue = txtAcessIndex.Text.Trim();
objNotes.TableName = txtTableName.Text.Trim();
objNotes.TableDesc = txtTableDesc.Text.Trim();
objNotes.Remarks = txtRemarks.Text.Trim();
if (btnSaveHandle.Text == "Save")
{
int res = objNotes.InsertNotesHandle();
if (res > 0)
{
txtNotesHandle.Text = "";
txtAcessIndex.Text = "";
txtTableName.Text = "";
txtTableDesc.Text = "";
txtDBID.Text = "";
txtRemarks.Text = "";
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Saved Successfully');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Saved');", true);
}
}
else
{
int res = objNotes.UpdateNotesHandle();
if (res > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Updated Successfully');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Updated');", true);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Please enter all data');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
}
}
public static string[] GetUSer(string prefixText, int count)
{
NotesClass objNotes = new NotesClass();
DataTable dt = objNotes.GetUser(prefixText);
List <string> lst = new List <string>();
foreach (DataRow dr in dt.Rows)
{
string UserId = dr["EmployeeName"].ToString() + "-" + dr["CardNo"].ToString();
// string UserName = ;
lst.Add(UserId);
// lst.Add(UserName);
}
return(lst.ToArray());
}
private void GetNotesReminder()
{
NotesClass objNotes = new NotesClass();
DataTable dt = objNotes.GetNotesReminder();
if (dt.Rows.Count > 0)
{
gvData.DataSource = dt;
gvData.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('No record found');", true);
}
}
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];
objNotes = new NotesClass();
objNotes.NoteID = Value[1];
DataTable dt = objNotes.GetNotesByRunningId();
txtMailTo.Text = dt.Rows[0]["SendEmailTo"].ToString();
txtTitle.Text = dt.Rows[0]["Title"].ToString();
txtDescription.Text = dt.Rows[0]["Description"].ToString();
//add color to desc and button
txtDescription.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") : "";
//if (uId == Request.QueryString["user"])
//{
// txtTitle.Enabled = true;
// txtDescription.Enabled = true;
// btnSaveNotes.Text = "Update";
// btnSaveNotes.Enabled = true;
// btnDeleteNotes.Enabled = true;
// btnDeleteNotes.Visible = true;
// txtMailTo.Enabled = true;
//}
//else
//{
// Request.QueryString["ed"] = "";
txtTitle.Enabled = false;
txtDescription.Enabled = false;
btnSaveNotes.Enabled = false;
btnDeleteNotes.Enabled = false;
txtMailTo.Enabled = false;
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Editing of Notes is not allowed');", true);
//}
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not Update');", true);
}
}
protected void SendMAil()
{
try
{
if (txtMailTo.Text != "")
{
objNotes = new NotesClass();
objNotes.User = Request.QueryString["user"];
DataTable dtUserMail = objNotes.GetEmployeeDetails();
MailMessage mM = new MailMessage();
mM.From = new MailAddress(dtUserMail.Rows[0]["EmailID"].ToString());
string[] MailTo = txtMailTo.Text.Split(';');
foreach (string Mailid in MailTo)
{
mM.To.Add(new MailAddress(Mailid));
}
mM.To.Add(dtUserMail.Rows[0]["EmailID"].ToString());
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 = txtDescription.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);
}
}
private void GetNotes()
{
objNotes = new NotesClass();
objNotes.NotesHandle = Request.QueryString["handle"];
objNotes.IndexValue = Request.QueryString["index"];
DataTable dt = objNotes.GetNotes();
if (dt.Rows.Count > 0)
{
gvData.DataSource = dt;
gvData.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('No record found');", true);
}
}
protected void btnSendMail_Click(object sender, EventArgs e)
{
try
{
if (txtTo.Text != "")
{
objNotes = new NotesClass();
objNotes.User = Request.QueryString["AttachedBy"];
DataTable dtUserMail = objNotes.GetEmployeeDetails();
MailMessage mM = new MailMessage();
mM.From = new MailAddress("*****@*****.**");
// mM.To.Add(txtTo.Text.Trim());
string[] MailTo = txtTo.Text.Split(';');
foreach (string Mailid in MailTo)
{
mM.To.Add(new MailAddress(Mailid));
}
mM.To.Add(dtUserMail.Rows[0]["EmailID"].ToString());
mM.Subject = hdfFile.Value;
string file = Server.MapPath("~/Files/") + hdfFile.Value;
mM.Attachments.Add(new System.Net.Mail.Attachment(file));
mM.Body = hdfFile.Value;
mM.IsBodyHtml = true;
SmtpClient sC = new SmtpClient("192.9.200.214", 25);
// 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');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Some technical issue Mail not sent');", true);
}
}
protected void lnkDeleteColor_Click(object sender, EventArgs e)
{
try
{
LinkButton lnkDelete = (LinkButton)sender;
string[] Value = lnkDelete.CommandArgument.Split('&');
NotesClass objNotesClass = new NotesClass();
objNotesClass.User = Value[1];
int res = objNotesClass.DeleteUserColor();
if (res > 0)
{
GEtUserColor();
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Deleted');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Deleted');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Some technical issue data Not Deleted');", true);
}
}
protected void btnDeleteNotes_Click(object sender, EventArgs e)
{
try
{
objNotes = new NotesClass();
objNotes.NoteID = hdfNoteId.Value;
int res = objNotes.DeleteNotes();
if (res > 0)
{
txtTitle.Text = "";
txtDescription.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 btnAttachment_Click(object sender, EventArgs e)
{
try
{
string url;
if (hdfNoteId.Value != "")
{
if (hdfUser.Value == Request.QueryString["user"])
{
// Response.Redirect("Attachment.aspx?AthHandle=" + Request.QueryString["handle"] + "&Index=" + hdfNoteId.Value + "&AttachedBy=" + Request.QueryString["user"] + "&ed=y");
url = "Attachment.aspx?AthHandle=JOOMLA_NOTES" + "&Index=" + hdfNoteId.Value + "&AttachedBy=" + Request.QueryString["user"] + "&ed=y";
}
else
{
url = "Attachment.aspx?AthHandle=JOOMLA_NOTES" + "&Index=" + hdfNoteId.Value + "&AttachedBy=" + Request.QueryString["user"];
}
string s = "window.open('" + url + "', 'popup_window','width=900,height=800,left=100,top=100,resizable=yes');"; //, 'width=300,height=100,left=100,top=100,resizable=yes'
ClientScript.RegisterStartupScript(this.GetType(), "script", s, true);
}
else
{
objNotes = new NotesClass();
objNotes.NotesHandle = Request.QueryString["handle"];
objNotes.IndexValue = Request.QueryString["index"];
objNotes.Title = txtTitle.Text != "" ? txtTitle.Text.Trim() : "Only Attachment";
objNotes.Description = txtDescription.Text != "" ? txtDescription.Text.Trim() : "Only Attachment";
objNotes.User = Request.QueryString["user"];
objNotes.SendEmailTo = txtMailTo.Text;
objNotes.RemiderMailId = txtMailIdReminder.Text.Trim();
objNotes.ReminderDateTime = txtDate.Text != "" ? Convert.ToDateTime(txtDate.Text.Trim()).ToString("yyyy-MM-dd") + " " + "9:00" : System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " " + "9:00";
//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();
DataTable dtNotesID = objNotes.Insertdata();
if (dtNotesID.Rows[0][0].ToString() != "0")
{
if (txtMailTo.Text != "")
{
SendMAil();
}
txtTitle.Text = "";
txtDescription.Text = "";
GetNotes();
hdfNewNoteId.Value = dtNotesID.Rows[0][0].ToString();
objNotes = new NotesClass();
string TempNoteId = objNotes.GetTempNoteID();
url = "Attachment.aspx?AthHandle=JOOMLA_NOTES" + "&Index=" + dtNotesID.Rows[0][0].ToString() + "&AttachedBy=" + Request.QueryString["user"] + "&ed=y";
string s = "window.open('" + url + "', 'popup_window','width=900,height=800,left=100,top=100,resizable=yes');"; //, 'width=300,height=100,left=100,top=100,resizable=yes'
ClientScript.RegisterStartupScript(this.GetType(), "script", s, true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Notes Handle does not exist');", true);
}
}
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not Saved');", true);
}
}
protected void btnSaveNotes_Click(object sender, EventArgs e)
{
try
{
if (txtTitle.Text != "" && txtDescription.Text != "")
{
objNotes = new NotesClass();
objNotes.NotesHandle = Request.QueryString["handle"];
objNotes.IndexValue = Request.QueryString["index"];
objNotes.Title = txtTitle.Text.Trim();
objNotes.Description = txtDescription.Text.Trim();
objNotes.User = Request.QueryString["user"];
objNotes.SendEmailTo = txtMailTo.Text;
objNotes.RemiderMailId = txtMailIdReminder.Text.Trim();
objNotes.ReminderDateTime = txtDate.Text != "" ? Convert.ToDateTime(txtDate.Text.Trim()).ToString("yyyy-MM-dd") + " " + "9:00" : System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " " + "9:00";
//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")
{
if (hdfNewNoteId.Value == "")
{
DataTable dtNotesID = objNotes.Insertdata();
if (dtNotesID.Rows[0][0].ToString() != "0")
{
if (txtMailTo.Text != "")
{
SendMAil();
}
txtTitle.Text = "";
txtDescription.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);
}
}
else
{
objNotes.NoteID = hdfNewNoteId.Value;
int res = objNotes.UpdateNotes();
if (txtMailTo.Text != "")
{
SendMAil();
}
if (res > 0)
{
txtTitle.Text = "";
txtDescription.Text = "";
hdfNewNoteId.Value = "";
GetNotes();
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Saved');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Updated');", true);
}
}
}
// Update
else
{
objNotes.NoteID = hdfNoteId.Value;
int res = objNotes.UpdateNotes();
if (txtMailTo.Text != "")
{
SendMAil();
}
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 btnAttachment_Click(object sender, EventArgs e)
{
try
{
string url;
if (Request.QueryString["RefHandle"] != null && Request.QueryString["RefIndex"] != null)
{
// url = "http://localhost/Attachment/Attachment.aspx?AthHandle=JOOMLA_NOTES" + "&Index=Notes230&AttachedBy=" + Request.QueryString["user"] + "&ed=a&RefHandle=" + Request.QueryString["RefHandle"] + "&RefIndex=" + Request.QueryString["RefIndex"] + "&ed=y";
// url = "http://localhost/Attachment/Attachment.aspx?AthHandle=J_PREORDER_WORKFLOW" + "&Index=389&AttachedBy=" + Request.QueryString["u"] + "&ed=a&RefHandle=TRANSMITTALLINES_200&RefIndex=BOi000532_JB0973-50270100-027-0001_00";
url = "Attachment.aspx?AthHandle=J_PREORDER_WORKFLOW" + "&Index=" + Request.QueryString["Index"] + "&AttachedBy=" + Request.QueryString["user"] + "&ed=a&RefHandle=" + Request.QueryString["RefHandle"] + "&RefIndex=" + Request.QueryString["RefIndex"] + "";
string s = "window.open('" + url + "', 'popup_window','width=900,height=800,left=100,top=100,resizable=yes');"; //, 'width=300,height=100,left=100,top=100,resizable=yes'
ClientScript.RegisterStartupScript(this.GetType(), "script", s, true);
}
else if (Request.QueryString["RefHandle"] == null && Request.QueryString["RefIndex"] == null)
{
if (hdfNoteId.Value != "")
{
//if (Request.QueryString["RefHandle"] != null && Request.QueryString["RefIndex"] != null && hdfUser.Value == Request.QueryString["user"])
//{
// url = "http://localhost/Attachment/Attachment.aspx?AthHandle=JOOMLA_NOTES" + "&Index=" + hdfNoteId.Value + "&AttachedBy=" + Request.QueryString["user"] + "&ed=a&RefHandle=" + Request.QueryString["RefHandle"] + "&RefIndex=" + Request.QueryString["RefIndex"] + "&ed=y";
//}
//else
if (hdfUser.Value == Request.QueryString["user"])
{
if (txtTitle.Enabled)
{
url = "Attachment.aspx?AthHandle=JOOMLA_NOTES" + "&Index=" + hdfNoteId.Value + "&AttachedBy=" + Request.QueryString["user"] + "&ed=y";
}
// Response.Redirect("Attachment.aspx?AthHandle=" + Request.QueryString["handle"] + "&Index=" + hdfNoteId.Value + "&AttachedBy=" + Request.QueryString["user"] + "&ed=y");
url = "Attachment.aspx?AthHandle=JOOMLA_NOTES" + "&Index=" + hdfNoteId.Value + "&AttachedBy=" + Request.QueryString["user"] + "&ed=n";
}
else
{
url = "Attachment.aspx?AthHandle=JOOMLA_NOTES" + "&Index=" + hdfNoteId.Value + "&AttachedBy=" + Request.QueryString["user"];
}
string s = "window.open('" + url + "', 'popup_window','width=900,height=800,left=100,top=100,resizable=yes');"; //, 'width=300,height=100,left=100,top=100,resizable=yes'
ClientScript.RegisterStartupScript(this.GetType(), "script", s, true);
}
else
{
objNotes = new NotesClass();
objNotes.NotesHandle = Request.QueryString["handle"];
objNotes.IndexValue = Request.QueryString["index"];
objNotes.Title = txtTitle.Text != "" ? txtTitle.Text.Trim() : "Only Attachment";
objNotes.Description = txtDescription.Text != "" ? txtDescription.Text.Trim() : "Only Attachment";
objNotes.User = Request.QueryString["user"];
objNotes.SendEmailTo = txtMailTo.Text;
objNotes.RemiderMailId = txtMailIdReminder.Text.Trim();
objNotes.ReminderDateTime = txtDate.Text != "" ? Convert.ToDateTime(txtDate.Text.Trim()).ToString("yyyy-MM-dd") + " " + "9:00" : System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " " + "9:00";
//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();
//Session["NotesHandle"] = objNotes.NotesHandle;
//Session["IndexValue"] = objNotes.IndexValue;
//Session["Title"] = objNotes.Title;
//Session["Description"] = objNotes.Description;
//Session["User"] = objNotes.User;
//Session["SendEmailTo"] = objNotes.SendEmailTo;
//Session["RemiderMailId"] = objNotes.RemiderMailId;
//Session["ReminderDateTime"] = objNotes.ReminderDateTime;
DataTable dtNotesID = objNotes.Insertdata();
if (dtNotesID.Rows[0][0].ToString() != "0")
{
//if (txtMailTo.Text != "")
//{
// SendMAil();
//}
// txtTitle.Text = "";
// txtDescription.Text = "";
// GetNotes();
hdfNewNoteId.Value = dtNotesID.Rows[0][0].ToString();
objNotes = new NotesClass();
string TempNoteId = objNotes.GetTempNoteID();
url = "Attachment.aspx?AthHandle=JOOMLA_NOTES" + "&Index=" + dtNotesID.Rows[0][0].ToString() + "&AttachedBy=" + Request.QueryString["user"] + "&ed=y";
string s = "window.open('" + url + "', 'popup_window','width=900,height=800,left=100,top=100,resizable=yes');"; //, 'width=300,height=100,left=100,top=100,resizable=yes'
ClientScript.RegisterStartupScript(this.GetType(), "script", s, true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Notes Handle does not exist');", true);
}
}
}
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not Saved');", true);
}
}
