public static ATTGeneralTippani GetTippaniDetail(int orgID, int tippaniID)
{
try
{
ATTGeneralTippani tippani = new ATTGeneralTippani();
DataTable tbl = DLLGeneralTippani.GetTippaniDetail(orgID, tippaniID);
if (tbl.Rows.Count == 1)
{
DataRow row = tbl.Rows[0];
tippani.OrgID = int.Parse(row["org_id"].ToString());
tippani.TippaniID = int.Parse(row["tippani_id"].ToString());
tippani.TippaniSubjectID = int.Parse(row["tippani_subject_id"].ToString());
tippani.TippaniText = row["tippani_text"].ToString();
tippani.FileNo = int.Parse(row["file_no"].ToString());
tippani.FinalStatus = int.Parse(row["final_status"].ToString());
tippani.PriorityID = int.Parse(row["priority_id"].ToString());
}
return(tippani);
}
catch (Exception ex)
{
throw ex;
}
}
public ATTGeneralTippani GetTippani(string entryBy, string msgIDs, string darIDs)
{
ATTGeneralTippani tippani = new ATTGeneralTippani();
int? MsgOrgID = null;
int? MsgID = null;
int? DarOrgID = null;
string DarRegDate = null;
int? DarRegNo = null;
if (msgIDs != "")
{
char[] token = { '/' };
MsgOrgID = int.Parse(msgIDs.Split(token)[0]);
MsgID = int.Parse(msgIDs.Split(token)[1]);
}
if (darIDs != "")
{
char[] token = { '_' };
DarOrgID = int.Parse(msgIDs.Split(token)[0]);
DarRegDate = msgIDs.Split(token)[1];
DarRegNo = int.Parse(msgIDs.Split(token)[2]);
}
if (this.ActionMode == "A")
{
tippani.OrgID = int.Parse(this.ddlOrg.SelectedValue);
tippani.TippaniID = 0;
tippani.Action = "A";
}
else
{
string ids = this.hdnIDS.Value;
char[] token = { '/' };
tippani.OrgID = int.Parse(ids.Split(token)[0]);
tippani.TippaniID = int.Parse(ids.Split(token)[1]);
tippani.Action = "E";
}
tippani.TippaniName = this.TippaniSubjectType;
tippani.TippaniSubjectID = int.Parse(this.ddlTippaniSubject.SelectedValue);
tippani.TippaniBy = this.User.UserName;
tippani.TippaniOn = "";
tippani.TippaniText = this.txtTippaniText.Text;
tippani.FileNo = double.Parse(this.txtFileNo.Text);
tippani.PriorityID = int.Parse(this.ddlPriority.SelectedValue);
tippani.TippaniBy = entryBy;
tippani.FinalStatus = 1;
tippani.CreatedBy = this.User.PID;
tippani.MsgOrgID = MsgOrgID;
tippani.MsgID = MsgID;
tippani.DarOrgID = DarOrgID;
tippani.DarRegDate = DarRegDate;
tippani.DarRegNo = DarRegNo;
return(tippani);
}
public static bool AddGeneralTippani(ATTGeneralTippani tippani)
{
object conn;
object tran;
try
{
conn = DLLGeneralTippani.GetConnection();
tran = DLLGeneralTippani.BeginTransaction(conn);
}
catch (Exception ex)
{
throw ex;
}
try
{
DLLGeneralTippani.AddGeneralTippani(tippani, tran);
if (tippani.Committee != null)
{
BLLCommitteeByTippani.AddCommitteeByTippani(tippani.Committee, tran, tippani.TippaniSubjectID, tippani.TippaniName, tippani.TippaniID);
foreach (ATTGeneralTippaniDetail d in tippani.LstTippaniDetail)
{
d.CommitteeID = tippani.Committee.CommitteeID;
}
}
if (tippani.LstTippaniDetail.Count > 0)
{
BLLGeneralTippaniDetail.AddGeneralTippaniDetail(tippani.LstTippaniDetail, tran, tippani.TippaniSubjectID, tippani.TippaniName, tippani.TippaniID);
}
if (tippani.LstTippaniProcess.Count > 0)
{
BLLGeneralTippaniProcess.AddGeneralTippaniProcessDetail(tippani.LstTippaniProcess, tran, tippani.TippaniSubjectID, tippani.TippaniName, tippani.TippaniID);
}
if (tippani.LstTippaniAttachment.Count > 0)
{
BLLGeneralTippaniAttachment.AddAttachment(tippani.LstTippaniAttachment, tran, tippani.TippaniSubjectID, tippani.TippaniName, tippani.TippaniID, tippani.LstTippaniProcess[0].TippaniProcessID);
}
DLLGeneralTippani.CommitTransaction(tran);
return(true);
}
catch (Exception ex)
{
DLLGeneralTippani.RollbackTransaction(tran);
throw ex;
}
finally
{
DLLGeneralTippani.CloseConnection(conn);
}
}
public static bool AddGeneralTippani(ATTGeneralTippani tippani, object tran)
{
string SP = "";
if (tippani.Action == "A")
{
SP = "SP_ADD_TIPPANI";
}
else if (tippani.Action == "E")
{
SP = "SP_EDIT_TIPPANI";
}
else if (tippani.Action == "D")
{
SP = "";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam("P_ORG_ID", tippani.OrgID, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", tippani.TippaniID, OracleDbType.Int16, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam("P_TIPPANI_SUBJECT_ID", tippani.TippaniSubjectID, OracleDbType.Int16, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_TIPPANI_BY", tippani.TippaniBy, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ON", tippani.TippaniOn, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_TIPPANI_TEXT", tippani.TippaniText, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_FILE_NO", tippani.FileNo, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_PRIORITY_ID", tippani.PriorityID, OracleDbType.Int16, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_CREATED_BY", tippani.CreatedBy, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_msg_org_id", tippani.MsgOrgID, OracleDbType.Int16, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_msg_id", tippani.MsgID, OracleDbType.Int16, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_dar_org_id", tippani.DarOrgID, OracleDbType.Int16, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_dar_org_id", tippani.DarRegDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_dar_reg_no", tippani.DarRegNo, OracleDbType.Int16, ParameterDirection.Input));
try
{
SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray());
tippani.TippaniID = int.Parse(paramArray[1].Value.ToString());
paramArray.Clear();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public void LoadTippaniDetail(int orgID, int tippaniID)
{
try
{
ATTGeneralTippani tippani = BLLGeneralTippani.GetTippaniDetail(orgID, tippaniID);
this.txtTippaniText.Text = tippani.TippaniText;
this.txtFileNo.Text = tippani.FileNo.ToString();
this.ddlPriority.SelectedValue = tippani.PriorityID.ToString();
this.hdnIDS.Value = orgID.ToString() + "/" + tippaniID.ToString();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
#region validation
if (this.Tippani.TippaniText.Text.Trim() == "")
{
this.lblStatusMessage.Text = "कृपया टिप्पणीको बिषय राख्नुहोस्।";
this.programmaticModalPopup.Show();
return;
}
if (this.Tippani.FileNo.Text.Trim() == "")
{
this.lblStatusMessage.Text = "कृपया टिप्पणीको फाइल नं राख्नुहोस्।";
this.programmaticModalPopup.Show();
return;
}
if (this.Tippani.TippaniPriority.SelectedIndex <= 0)
{
this.lblStatusMessage.Text = "कृपया टिप्पणीको प्राथमिक्ता छन्नुहोस।";
this.programmaticModalPopup.Show();
return;
}
#endregion
/* tippani created */
this.Tippani.ActionMode = this.hdnMode.Value;
ATTGeneralTippani tippani = this.Tippani.GetTippani(this.User.UserName, this.hdnMsgIDs.Value, this.hdnDarIDs.Value);
/* tippani detail created */
this.VisitTippani.ActionMode = this.hdnMode.Value;
tippani.LstTippaniDetail = this.VisitTippani.GetVisitorList();
if (tippani.TippaniDetail == null)
{
return;
}
/* tippani attachment created */
this.TippaniAttachment.ActionMode = this.hdnMode.Value;
tippani.LstTippaniAttachment = this.TippaniAttachment.GetAttachment(tippani.OrgID, tippani.TippaniID, this.User.UserName);
/* tippani process created for self actor */
ATTGeneralTippaniProcess selfProcess = new ATTGeneralTippaniProcess();
if (hdnMode.Value == "A")
{
selfProcess.OrgID = tippani.OrgID;
selfProcess.TippaniID = tippani.TippaniID;
selfProcess.TippaniProcessID = 0;
}
else if (hdnMode.Value == "E")
{
char[] token = { '/' };
selfProcess.OrgID = int.Parse(this.hdnIDs.Value.Split(token)[0]);
selfProcess.TippaniID = int.Parse(this.hdnIDs.Value.Split(token)[1]);
selfProcess.TippaniProcessID = 1;
}
selfProcess.SenderOrgID = null;
selfProcess.SenderUnitID = null;
selfProcess.SendBy = null;
selfProcess.SendOn = "";
selfProcess.ReceiverOrgID = this.User.OrgID;
selfProcess.ReceiverUnitID = this.User.UnitID;
selfProcess.SendTo = (int)this.User.PID;
selfProcess.Note = this.VisitTippani.Note.Text;
selfProcess.Status = int.Parse(this.VisitTippani.Status.SelectedValue);
selfProcess.SendType = "F";
selfProcess.IsChannelPerson = "Y";
selfProcess.EntryBy = this.User.UserName;
selfProcess.Action = this.hdnMode.Value;
/* created list of process for tippani movement */
//if (this.hdnMode.Value == "A")
{
tippani.LstTippaniProcess = this.chnlPerson.GetTippaniProcessList(tippani.OrgID, tippani.TippaniID, this.User.UserName);
}
/* add self process object at the begining of the process list */
tippani.LstTippaniProcess.Insert(0, selfProcess);
#region Validation
bool hasDetail = tippani.LstTippaniDetail.Exists
(
delegate(ATTGeneralTippaniDetail d)
{
return(d.Action != "D");
}
);
if (hasDetail == false)
{
this.lblStatusMessage.Text = "कृपया टिप्पणीको लागी कर्मचारी राख्नुहोस्।";
this.programmaticModalPopup.Show();
return;
}
#endregion
try
{
BLLGeneralTippani.AddGeneralTippani(tippani);
foreach (ATTGeneralTippaniAttachment attach in tippani.LstTippaniAttachment)
{
if (attach.RawContent != null)
{
GC.Collect();
GC.SuppressFinalize(attach.RawContent);
attach.RawContent = null;
}
}
this.ClearME();
this.lblStatusMessage.Text = "Visit Tippani has been saved successfully.";
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
#region Validation
if (this.grdEmployee.SelectedIndex < 0)
{
this.lblStatusMessage.Text = "क्रिपया कर्मचारी छन्नुहोस ।";
this.programmaticModalPopup.Show();
return;
}
if (this.txtLocation_Rqd.Text.Trim() == "")
{
this.lblStatusMessage.Text = "क्रिपया भ्रमणको स्थना छन्नुहोस ।";
this.programmaticModalPopup.Show();
return;
}
if (this.ddlCountry_Rqd.SelectedIndex == 0)
{
this.lblStatusMessage.Text = "क्रिपया भ्रमणको देश छन्नुहोस ।";
this.programmaticModalPopup.Show();
return;
}
if (this.txtFromDate_Rdt.Text.Trim() == "")
{
this.lblStatusMessage.Text = "क्रिपया अवधि देखि को मिति राख्न्नुहोस ।";
this.programmaticModalPopup.Show();
return;
}
if (this.txtToDate_Rdt.Text.Trim() == "")
{
this.lblStatusMessage.Text = "क्रिपया अवधि सम्म को मिति राख्न्नुहोस ।";
this.programmaticModalPopup.Show();
return;
}
if (this.txtSubject_Rqd.Text.Trim() == "")
{
this.lblStatusMessage.Text = "क्रिपया भ्रमणको बिषय राख्न्नुहोस ।";
this.programmaticModalPopup.Show();
return;
}
#endregion
double EmpID = double.Parse(this.grdEmployee.SelectedRow.Cells[0].Text);
ATTGeneralTippani tippani = new ATTGeneralTippani();
tippani.TippaniName = TippaniSubject.Visit;
tippani.OrgID = int.Parse(this.ddlOrg_Rqd.SelectedValue);
tippani.TippaniID = 0;
tippani.TippaniSubjectID = int.Parse(this.ddlTippaniSubject_Rqd.SelectedValue);
tippani.TippaniBy = this.User.UserName;
tippani.TippaniOn = "";
tippani.TippaniText = this.txtTippaniText.Text;
tippani.FinalStatus = 1;
tippani.Action = "A";
tippani.TippaniDetail.OrgID = tippani.OrgID;
tippani.TippaniDetail.TippaniID = tippani.TippaniID;
tippani.TippaniDetail.TippaniSNO = 0;
tippani.TippaniDetail.EmpID = EmpID;
tippani.TippaniDetail.VisitLocation = this.txtLocation_Rqd.Text;
tippani.TippaniDetail.VisitCountryID = int.Parse(this.ddlCountry_Rqd.SelectedValue);
tippani.TippaniDetail.VisitFromDate = this.txtFromDate_Rdt.Text;
tippani.TippaniDetail.VisitToDate = this.txtToDate_Rdt.Text;
tippani.TippaniDetail.VisitPurpose = this.txtSubject_Rqd.Text;
tippani.TippaniDetail.VisitRemark = this.txtRemarks_Rdt.Text;
tippani.TippaniDetail.VisitEntryBy = this.User.UserName;
tippani.TippaniDetail.Action = "A";
/****************** extra added later ******************/
ATTGeneralTippaniProcess self = new ATTGeneralTippaniProcess();
self.OrgID = tippani.OrgID;
self.TippaniID = tippani.TippaniID;
self.TippaniProcessID = 0;
self.SendBy = null;
self.SendOn = "";
self.SendTo = (int)this.User.PID;
self.Note = this.txtDOB.Text;
self.Status = int.Parse(this.ddlTippaniStatus.SelectedValue);
self.SendType = "F";
self.IsChannelPerson = "Y";
self.Action = "A";
tippani.LstTippaniProcess.Add(self);
/************************************/
foreach (GridViewRow row in this.grdChannelPerson.Rows)
{
CheckBox box = (CheckBox)row.FindControl("chkSelect");
if (box.Checked == true)
{
ATTGeneralTippaniProcess process = new ATTGeneralTippaniProcess();
/*process.OrgID = tippani.OrgID;
* process.TippaniID = tippani.TippaniID;
* process.TippaniProcessID = 0;
* process.ProcessBy = this.User.PID;
* process.ProcessOn = "";
* process.ProcessTo = int.Parse(row.Cells[1].Text);
* process.Status = null;
* process.SendType = "F";
* process.Action = "A";*/
process.OrgID = tippani.OrgID;
process.TippaniID = tippani.TippaniID;
process.TippaniProcessID = 0;
process.SendBy = this.User.PID;
process.SendOn = "";
process.SendTo = int.Parse(row.Cells[8].Text);
process.Note = "";
process.Status = null;
process.SendType = "F";
process.IsChannelPerson = "Y";
process.Action = "A";
tippani.LstTippaniProcess.Add(process);
//box.Checked = false;
}
}
foreach (GridViewRow row in this.grdSEmployee.Rows)
{
CheckBox box = (CheckBox)row.FindControl("chkGSelect");
if (box.Checked == true)
{
ATTGeneralTippaniProcess process = new ATTGeneralTippaniProcess();
process.OrgID = tippani.OrgID;
process.TippaniID = tippani.TippaniID;
process.TippaniProcessID = 0;
process.SendBy = this.User.PID;
process.SendOn = "";
process.SendTo = int.Parse(row.Cells[0].Text);
process.Note = "";
process.Status = null;
process.SendType = "F";
process.IsChannelPerson = "N";
process.Action = "A";
tippani.LstTippaniProcess.Add(process);
//box.Checked = false;
}
}
try
{
BLLGeneralTippani.AddGeneralTippani(tippani);
this.ClearME();
this.lblStatusMessage.Text = "Visit Tippani has been saved successfully.";
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
