protected void grdAttachment_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Cells[0].Visible = false;
e.Row.Cells[1].Visible = false;
e.Row.Cells[2].Visible = false;
e.Row.Cells[3].Visible = false;
if (e.Row.RowType == DataControlRowType.DataRow)
{
((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick", "return confirm('Do you really want to delete?');");
ATTGeneralTippaniAttachment attach = e.Row.DataItem as ATTGeneralTippaniAttachment;
System.Drawing.Color c = BLLGeneralTippani.GetActionColor(attach.Action);
e.Row.ForeColor = c;
if (attach.Action == "D")
{
((LinkButton)e.Row.Cells[6].Controls[0]).Text = "Undo";
}
else if (attach.Action == "N" || attach.Action == "A" || attach.Action == "E")
{
((LinkButton)e.Row.Cells[6].Controls[0]).Text = "Delete";
}
}
}
public static List <ATTGeneralTippaniAttachment> GetAttachment(ATTGeneralTippaniAttachment attach, string tippaniList)
{
List <ATTGeneralTippaniAttachment> lst = new List <ATTGeneralTippaniAttachment>();
try
{
if (tippaniList != "")
{
tippaniList = tippaniList.Remove(tippaniList.LastIndexOf(','), 2);
DataTable tbl = DLLGeneralTippaniAttachment.GetAttachment(attach);
foreach (DataRow row in tbl.Rows)
{
ATTGeneralTippaniAttachment attachment = new ATTGeneralTippaniAttachment();
attachment.OrgID = int.Parse(row["org_id"].ToString());
attachment.TippaniID = int.Parse(row["tippani_id"].ToString());
attachment.TippaniProcessID = int.Parse(row["tippani_process_id"].ToString());
attachment.AttachmentID = int.Parse(row["attachment_id"].ToString());
attachment.DocumentName = row["doc_name"].ToString();
attachment.Description = row["Description"].ToString();
attachment.Action = "N";
lst.Add(attachment);
}
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (this.fupAttachment.HasFile == false)
{
this.lblStatusMessage.Text = "कृपया कागजपत्र दिनुहोस।";
this.programmaticModalPopup.Show();
return;
}
List <ATTGeneralTippaniAttachment> lst = Session["Tippani_Attachment"] as List <ATTGeneralTippaniAttachment>;
ATTGeneralTippaniAttachment attachment = new ATTGeneralTippaniAttachment();
attachment.OrgID = 0;
attachment.TippaniID = 0;
attachment.TippaniProcessID = 0;
attachment.AttachmentID = 0;
attachment.DocumentName = this.fupAttachment.FileName;
attachment.Description = this.txtDescription.Text;
attachment.RawContent = this.fupAttachment.FileBytes;
attachment.Action = "A";
lst.Add(attachment);
this.grdAttachment.DataSource = lst;
this.grdAttachment.DataBind();
this.txtDescription.Text = "";
}
protected void grdAttachment_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
List <ATTGeneralTippaniAttachment> lst = Session["Tippani_Attachment"] as List <ATTGeneralTippaniAttachment>;
ATTGeneralTippaniAttachment currentO = lst[e.RowIndex];
GridViewRow CurrentRow = this.grdAttachment.Rows[e.RowIndex];
int DelCmdIndex = 6;
if (currentO.Action == "A")
{
GC.Collect();
GC.SuppressFinalize(lst[e.RowIndex].RawContent);
lst[e.RowIndex].RawContent = null;
lst.RemoveAt(e.RowIndex);
this.grdAttachment.DataSource = lst;
this.grdAttachment.DataBind();
}
else if (currentO.Action == "N" || currentO.Action == "D" || currentO.Action == "E")
{
if (((LinkButton)CurrentRow.Cells[DelCmdIndex].Controls[0]).Text == "Delete")
{
lst[e.RowIndex].Action = "D";
this.grdAttachment.DataSource = lst;
this.grdAttachment.DataBind();
}
else if (((LinkButton)CurrentRow.Cells[DelCmdIndex].Controls[0]).Text == "Undo")
{
lst[e.RowIndex].Action = "N";
this.grdAttachment.DataSource = lst;
this.grdAttachment.DataBind();
}
}
}
public static DataTable GetAttachment(ATTGeneralTippaniAttachment attach)
{
string SQL = "SELECT * FROM VW_TIPPANI_ATTACHMENT_INFO WHERE 1 = 1";
SQL = SQL + " AND ORG_ID = " + attach.OrgID.ToString();
SQL = SQL + " AND TIPPANI_ID = " + attach.TippaniID.ToString();
try
{
return(SqlHelper.ExecuteDataset(CommandType.Text, SQL, Module.OAS, null).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
public void LoadAttachmentFromDartaaChalaani(int orgID, string regDate, int regNo)
{
try
{
List <ATTDartaaChalaani> dlist = BLLDartaaChalaani.GetDartaaChalaaniByIDs(orgID, regDate, regNo);
List <ATTGeneralTippaniAttachment> lst = new List <ATTGeneralTippaniAttachment>();
foreach (ATTDartaaChalaani att in dlist)
{
if (att.FileName != "" && att.RegFile != null)
{
ATTGeneralTippaniAttachment ah = new ATTGeneralTippaniAttachment();
ah.OrgID = 0;
ah.TippaniID = 0;
ah.TippaniProcessID = 0;
ah.AttachmentID = 0;
ah.DocumentName = att.FileName;
ah.Description = "";
ah.RawContent = att.RegFile;
ah.Action = "A";
lst.Add(ah);
}
}
foreach (ATTDartaaChalaani attach in dlist)
{
if (attach.RegFile != null)
{
GC.Collect();
GC.SuppressFinalize(attach.RegFile);
attach.RegFile = null;
}
}
this.grdAttachment.DataSource = lst;
this.grdAttachment.DataBind();
Session["Tippani_Attachment"] = lst;
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
public void LoadTippaniAttachmentDetail(int orgID, int tippaniID)
{
ATTGeneralTippaniAttachment info = new ATTGeneralTippaniAttachment();
info.OrgID = orgID;
info.TippaniID = tippaniID;
try
{
List <ATTGeneralTippaniAttachment> lst = BLLGeneralTippaniAttachment.GetAttachment(info, tippaniID.ToString() + ", ");
this.grdAttachment.DataSource = lst;
this.grdAttachment.DataBind();
Session["Tippani_Attachment"] = lst;
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
public void LoadAttachmentFromMessage(int orgID, int msgID)
{
try
{
List <ATTMessageAttachment> mlist = BLLMessageAttachment.GetMsgAttachmentByIDs(orgID, msgID);
List <ATTGeneralTippaniAttachment> lst = new List <ATTGeneralTippaniAttachment>();
foreach (ATTMessageAttachment att in mlist)
{
ATTGeneralTippaniAttachment ah = new ATTGeneralTippaniAttachment();
ah.OrgID = 0;
ah.TippaniID = 0;
ah.TippaniProcessID = 0;
ah.AttachmentID = 0;
ah.DocumentName = att.FileName;
ah.Description = "";
ah.RawContent = att.ContentFile;
ah.Action = "A";
lst.Add(ah);
}
foreach (ATTMessageAttachment attach in mlist)
{
if (attach.ContentFile != null)
{
GC.Collect();
GC.SuppressFinalize(attach.ContentFile);
attach.ContentFile = null;
}
}
this.grdAttachment.DataSource = lst;
this.grdAttachment.DataBind();
Session["Tippani_Attachment"] = lst;
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
public static List <ATTGeneralTippaniRequestInfo> GetTippaniRequestInfoList(ATTGeneralTippaniRequestInfo info, int sIndex, int eIndex, ref decimal totalRecord)
{
List <ATTGeneralTippaniRequestInfo> lst = new List <ATTGeneralTippaniRequestInfo>();
try
{
DataTable tbl = new DataTable();
if (info.RequestType == TippaniProcessRequestType.Request)
{
tbl = DLLGeneralTippaniRequestInfo.GetTippaniRequestInfo(info, sIndex, eIndex, ref totalRecord);
}
else if (info.RequestType == TippaniProcessRequestType.History)
{
tbl = DLLGeneralTippaniRequestInfo.GetTippaniRequestHistory(info);
}
string tippaniList = "";
foreach (DataRow row in tbl.Rows)
{
ATTGeneralTippaniRequestInfo obj = new ATTGeneralTippaniRequestInfo();
obj.OrgID = int.Parse(row["org_id"].ToString());
obj.TippaniID = int.Parse(row["tippani_id"].ToString());
obj.TippaniProcessID = int.Parse(row["tippani_process_id"].ToString());
obj.ProcessByID = (row["process_by_id"].ToString() == "") ? 0 : double.Parse(row["process_by_id"].ToString());
obj.ProcessBy = row["process_by"].ToString();
obj.IsChannelPerson = row["is_channel_person"].ToString();
obj.TippaniSubject = row["tippani_text"].ToString();
obj.ProcessOn = row["send_on"].ToString();
obj.ProcessToID = double.Parse(row["process_to_id"].ToString());
obj.ProcessTo = row["process_to"].ToString();
obj.TippaniSubjectID = int.Parse(row["tippani_subject_id"].ToString());
obj.TippaniSubjectName = row["tippani_subject_name"].ToString();
obj.TippaniStatusID = int.Parse(row["tippani_status_ID"].ToString());
obj.TippaniStatusName = row["tippani_status_Name"].ToString();
obj.ProcessStatusID = (row["process_status_ID"].ToString() == "") ? 0 : int.Parse(row["process_status_ID"].ToString());
obj.ProcessStatusName = row["process_status_Name"].ToString();
obj.Note = row["note"].ToString();
obj.SenderOrgID = (row["sender_org_id"].ToString() == "") ? 0 : int.Parse(row["sender_org_id"].ToString());
obj.SenderUnitID = (row["sender_unit_id"].ToString() == "") ? 0 : int.Parse(row["sender_unit_id"].ToString());
obj.SenderOrgName = row["sender_org_name"].ToString();
obj.SenderUnitName = row["sender_unit_name"].ToString();
obj.ReceiverOrgID = int.Parse(row["receiver_org_id"].ToString());
obj.ReceiverUnitID = int.Parse(row["receiver_unit_id"].ToString());
obj.ReceiverOrgName = row["receiver_org_name"].ToString();
obj.ReceiverUnitName = row["receiver_unit_name"].ToString();
tippaniList = tippaniList + obj.TippaniID.ToString() + ", ";
lst.Add(obj);
}
if (info.RequestType == TippaniProcessRequestType.History)
{
ATTGeneralTippaniAttachment infox = new ATTGeneralTippaniAttachment();
infox.OrgID = info.OrgID;
infox.TippaniID = info.TippaniID;
List <ATTGeneralTippaniAttachment> lstAttachment = BLLGeneralTippaniAttachment.GetAttachment(infox, tippaniList);
foreach (ATTGeneralTippaniRequestInfo request in lst)
{
request.LstAttachment = lstAttachment.FindAll
(
delegate(ATTGeneralTippaniAttachment a)
{
return(a.OrgID == request.OrgID &&
a.TippaniID == request.TippaniID &&
a.TippaniProcessID == request.TippaniProcessID);
}
);
}
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
