internal General_Documents Get_Document_Details_By_Record_Id(
int p_General_Document_Id,
int p_User_Id_Document_Owner,
int p_User_Id_Searching_For_Document_Details)
{
General_Documents general_Document_To_Return = null;
SqlParameter spGeneral_Document_Id = new SqlParameter("@General_Document_Id", SqlDbType.Int);
SqlParameter spUser_Id_Document_Owner = new SqlParameter("@User_Id_Document_Owner", SqlDbType.Int);
SqlParameter spUser_Id_Searching_For_Document_Details = new SqlParameter("@User_Id_Searching_For_Document_Details", SqlDbType.Int);
spGeneral_Document_Id.Value = p_General_Document_Id;
spUser_Id_Document_Owner.Value = p_User_Id_Document_Owner;
spUser_Id_Searching_For_Document_Details.Value = p_User_Id_Searching_For_Document_Details;
var dataSet = SQLHelper.SelectUsingStoredProcedure_WithDefaultAppConfigConnectionString("p_TLBoard_Get_General_Document_Details",
new List <SqlParameter>()
{
spGeneral_Document_Id, spUser_Id_Document_Owner, spUser_Id_Searching_For_Document_Details
});
if (dataSet != null && dataSet.Tables[0].Rows.Count > 0)
{
general_Document_To_Return = Create_General_Document_Details_From_Data_Row(dataSet.Tables[0].Rows[0]);
}
return(general_Document_To_Return);
}
private General_Documents Create_General_Document_Details_From_Data_Row(DataRow dataRow)
{
General_Documents General_Document_To_Return = new General_Documents();
General_Document_To_Return.General_Document_Id = (int)dataRow["General_Document_Id"];
General_Document_To_Return.User_Id = (int)dataRow["User_Id"];
if (dataRow["General_Document_Type"] != DBNull.Value)
{
General_Document_To_Return.General_Document_Type = (short)dataRow["General_Document_Type"];
}
General_Document_To_Return.Title = dataRow["Title"].ToString();
General_Document_To_Return.Description = dataRow["Description"].ToString();
if (dataRow["Document_Creation_DateTime"] != DBNull.Value)
{
General_Document_To_Return.Document_Creation_DateTime = (DateTime)dataRow["Document_Creation_DateTime"];
}
General_Document_To_Return.Sent_By_Entity_Name = dataRow["Sent_By_Entity_Name"].ToString();
if (dataRow["Sent_By_Entity_Country_Id"] != DBNull.Value)
{
General_Document_To_Return.Sent_By_Entity_Country_Id = (short)dataRow["Sent_By_Entity_Country_Id"];
if (dataRow.Table.Columns.IndexOf("Sent_By_Entity_Country_Name") > -1)
{
General_Document_To_Return.Sent_By_Entity_Country_Name = dataRow["Sent_By_Entity_Country_Name"].ToString();
}
if (dataRow["Sent_By_Entity_State_Id"] != DBNull.Value)
{
General_Document_To_Return.Sent_By_Entity_State_Id = (short)dataRow["Sent_By_Entity_State_Id"];
}
}
General_Document_To_Return.Sent_By_Entity_City = dataRow["Sent_By_Entity_City"].ToString();
if (dataRow.Table.Columns.IndexOf("Sent_By_Entity_Address") > -1)
{
General_Document_To_Return.Sent_By_Entity_Address = dataRow["Sent_By_Entity_Address"].ToString();
General_Document_To_Return.Sent_By_Entity_ZipCode = dataRow["Sent_By_Entity_ZipCode"].ToString();
}
if (dataRow.Table.Columns.IndexOf("Sent_By_Entity_DateTime") > -1)
{
if (dataRow["Sent_By_Entity_DateTime"] != DBNull.Value)
{
General_Document_To_Return.Sent_By_Entity_DateTime = (DateTime)dataRow["Sent_By_Entity_DateTime"];
}
}
if (dataRow.Table.Columns.IndexOf("Sent_By_Entity_Email_Address") > -1)
{
General_Document_To_Return.Sent_By_Entity_Email_Address = dataRow["Sent_By_Entity_Email_Address"].ToString();
}
if (dataRow.Table.Columns.IndexOf("Sent_To_Entity_Name") > -1)
{
General_Document_To_Return.Sent_To_Entity_Name = dataRow["Sent_To_Entity_Name"].ToString();
if (dataRow["Sent_To_Entity_Country_Id"] != DBNull.Value)
{
General_Document_To_Return.Sent_To_Entity_Country_Id = (short)dataRow["Sent_To_Entity_Country_Id"];
if (dataRow["Sent_To_Entity_State_Id"] != DBNull.Value)
{
General_Document_To_Return.Sent_To_Entity_State_Id = (short)dataRow["Sent_To_Entity_State_Id"];
}
}
General_Document_To_Return.Sent_To_Entity_City = dataRow["Sent_To_Entity_City"].ToString();
General_Document_To_Return.Sent_To_Entity_Address = dataRow["Sent_To_Entity_Address"].ToString();
General_Document_To_Return.Sent_To_Entity_ZipCode = dataRow["Sent_To_Entity_ZipCode"].ToString();
General_Document_To_Return.Sent_To_Entity_Email_Address = dataRow["Sent_To_Entity_Email_Address"].ToString();
}
if (dataRow.Table.Columns.IndexOf("Recieved_Document_DateTime") > -1)
{
if (dataRow["Recieved_Document_DateTime"] != DBNull.Value)
{
General_Document_To_Return.Recieved_Document_DateTime = (DateTime)dataRow["Recieved_Document_DateTime"];
}
}
if (dataRow.Table.Columns.IndexOf("Recieved_In_Country_Id") > -1)
{
if (dataRow["Recieved_In_Country_Id"] != DBNull.Value)
{
General_Document_To_Return.Recieved_In_Country_Id = (short)dataRow["Recieved_In_Country_Id"];
if (dataRow["Recieved_In_State_Id"] != DBNull.Value)
{
General_Document_To_Return.Recieved_In_State_Id = (short)dataRow["Recieved_In_State_Id"];
}
}
}
if (dataRow.Table.Columns.IndexOf("Recieved_In_City") > -1)
{
General_Document_To_Return.Recieved_In_City = dataRow["Recieved_In_City"].ToString();
General_Document_To_Return.Recieved_In_Address = dataRow["Recieved_In_Address"].ToString();
General_Document_To_Return.Recieved_In_ZipCode = dataRow["Recieved_In_ZipCode"].ToString();
General_Document_To_Return.Recieved_In_Email_Address = dataRow["Recieved_In_Email_Address"].ToString();
}
if (dataRow.Table.Columns.IndexOf("User_Comments") > -1)
{
General_Document_To_Return.User_Comments = dataRow["User_Comments"].ToString();
}
if (dataRow.Table.Columns.IndexOf("Recieved_By_User_Id") > -1)
{
if (dataRow["Recieved_By_User_Id"] != DBNull.Value)
{
General_Document_To_Return.Recieved_By_User_Id = (int)dataRow["Recieved_By_User_Id"];
}
}
if (dataRow.Table.Columns.IndexOf("Recieved_DateTime") > -1)
{
if (dataRow["Recieved_DateTime"] != DBNull.Value)
{
General_Document_To_Return.Recieved_DateTime = (DateTime)dataRow["Recieved_DateTime"];
}
}
if (dataRow.Table.Columns.IndexOf("Original_File_Name") > -1)
{
General_Document_To_Return.Original_File_Name = dataRow["Original_File_Name"].ToString();
General_Document_To_Return.Azure_Block_Blob_Reference = dataRow["Azure_Block_Blob_Reference"].ToString();
}
General_Document_To_Return.Is_Visible_To_Anonymous_Users = (bool)dataRow["Is_Visible_To_Anonymous_Users"];
General_Document_To_Return.Is_Available_For_Download_For_Anonymous_Users = (bool)dataRow["Is_Available_For_Download_For_Anonymous_Users"];
General_Document_To_Return.Is_Visible_To_Followers_Users = (bool)dataRow["Is_Visible_To_Followers_Users"];
General_Document_To_Return.Is_Available_For_Download_For_Followers_Users = (bool)dataRow["Is_Available_For_Download_For_Followers_Users"];
General_Document_To_Return.Is_Active = (bool)dataRow["Is_Active"];
if (dataRow.Table.Columns.IndexOf("Record_Created_By_User_Id") > -1)
{
General_Document_To_Return.Record_Created_By_User_Id = (int)dataRow["Record_Created_By_User_Id"];
if (dataRow.Table.Columns.IndexOf("Created_By_First_Name") > -1)
{
General_Document_To_Return.Record_Created_By_User_Details = new Users();
General_Document_To_Return.Record_Created_By_User_Details.First_Name = dataRow["Created_By_First_Name"].ToString();
General_Document_To_Return.Record_Created_By_User_Details.Last_Name = dataRow["Created_By_Last_Name"].ToString();
}
General_Document_To_Return.Record_Creation_DateTime_UTC = (DateTime)dataRow["Record_Creation_DateTime_UTC"];
General_Document_To_Return.Record_Last_Updated_By_User_Id = (int)dataRow["Record_Last_Updated_By_User_Id"];
if (dataRow.Table.Columns.IndexOf("Last_Updated_By_First_Name") > -1)
{
General_Document_To_Return.Record_Last_Updated_By_User_Details = new Users();
General_Document_To_Return.Record_Last_Updated_By_User_Details.First_Name = dataRow["Last_Updated_By_First_Name"].ToString();
General_Document_To_Return.Record_Last_Updated_By_User_Details.Last_Name = dataRow["Last_Updated_By_Last_Name"].ToString();
}
General_Document_To_Return.Record_Last_Updated_DateTime_UTC = (DateTime)dataRow["Record_Last_Updated_DateTime_UTC"];
}
return(General_Document_To_Return);
}
internal General_Documents Insert_New_General_Document_Details(
int p_User_Id, short p_General_Document_Type, string p_Title,
string p_Description, DateTime?p_Document_Creation_DateTime,
string p_Sent_By_Entity_Name, short?p_Sent_By_Entity_Country_Id,
short?p_Sent_By_Entity_State_Id, string p_Sent_By_Entity_City,
string p_Sent_By_Entity_Address, string p_Sent_By_Entity_ZipCode,
DateTime?p_Sent_By_Entity_DateTime, string p_Sent_By_Entity_Email_Address,
string p_Sent_To_Entity_Name, short?p_Sent_To_Entity_Country_Id,
short?p_Sent_To_Entity_State_Id, string p_Sent_To_Entity_City,
string p_Sent_To_Entity_Address, string p_Sent_To_Entity_ZipCode,
string p_Sent_To_Entity_Email_Address,
DateTime?p_Recieved_Document_DateTime,
short?p_Recieved_In_Country_Id, short?p_Recieved_In_State_Id,
string p_Recieved_In_City, string p_Recieved_In_Address,
string p_Recieved_In_ZipCode, string p_Recieved_In_Email_Address,
string p_User_Comments, int?p_Recieved_By_User_Id, DateTime?p_Recieved_DateTime,
string p_Original_File_Name, string p_Azure_Block_Blob_Reference,
bool p_Is_Visible_To_Anonymous_Users, bool p_Is_Available_For_Download_For_Anonymous_Users,
bool p_Is_Visible_To_Followers_Users, bool p_Is_Available_For_Download_For_Followers_Users,
int p_Record_Created_By_User_Id, DateTime p_Record_Creation_DateTime_UTC,
int p_Record_Last_Updated_By_User_Id, DateTime p_Record_Last_Updated_DateTime_UTC,
bool p_Is_Active)
{
General_Documents new_Registered_Entity_To_Return = null;
SqlParameter spUser_Id = new SqlParameter("@User_Id", SqlDbType.Int);
SqlParameter spGeneral_Document_Type = new SqlParameter("@General_Document_Type", SqlDbType.SmallInt);
SqlParameter spTitle = new SqlParameter("@Title", SqlDbType.NVarChar, 200);
SqlParameter spDescription = new SqlParameter("@Description", SqlDbType.NVarChar, 1500);
SqlParameter spDocument_Creation_DateTime = new SqlParameter("@Document_Creation_DateTime", SqlDbType.DateTime);
SqlParameter spSent_By_Entity_Name = new SqlParameter("@Sent_By_Entity_Name", SqlDbType.NVarChar, 100);
SqlParameter spSent_By_Entity_Country_Id = new SqlParameter("@Sent_By_Entity_Country_Id", SqlDbType.SmallInt);
SqlParameter spSent_By_Entity_State_Id = new SqlParameter("@Sent_By_Entity_State_Id", SqlDbType.SmallInt);
SqlParameter spSent_By_Entity_City = new SqlParameter("@Sent_By_Entity_City", SqlDbType.NVarChar, 100);
SqlParameter spSent_By_Entity_Address = new SqlParameter("@Sent_By_Entity_Address", SqlDbType.NVarChar, 150);
SqlParameter spSent_By_Entity_ZipCode = new SqlParameter("@Sent_By_Entity_ZipCode", SqlDbType.NVarChar, 20);
SqlParameter spSent_By_Entity_DateTime = new SqlParameter("@Sent_By_Entity_DateTime", SqlDbType.DateTime);
SqlParameter spSent_By_Entity_Email_Address = new SqlParameter("@Sent_By_Entity_Email_Address", SqlDbType.NVarChar, 100);
SqlParameter spSent_To_Entity_Name = new SqlParameter("@Sent_To_Entity_Name", SqlDbType.NVarChar, 100);
SqlParameter spSent_To_Entity_Country_Id = new SqlParameter("@Sent_To_Entity_Country_Id", SqlDbType.SmallInt);
SqlParameter spSent_To_Entity_State_Id = new SqlParameter("@Sent_To_Entity_State_Id", SqlDbType.SmallInt);
SqlParameter spSent_To_Entity_City = new SqlParameter("@Sent_To_Entity_City", SqlDbType.NVarChar, 100);
SqlParameter spSent_To_Entity_Address = new SqlParameter("@Sent_To_Entity_Address", SqlDbType.NVarChar, 150);
SqlParameter spSent_To_Entity_ZipCode = new SqlParameter("@Sent_To_Entity_ZipCode", SqlDbType.NVarChar, 20);
SqlParameter spSent_To_Entity_Email_Address = new SqlParameter("@Sent_To_Entity_Email_Address", SqlDbType.NVarChar, 150);
SqlParameter spRecieved_Document_DateTime = new SqlParameter("@Recieved_Document_DateTime", SqlDbType.DateTime);
SqlParameter spRecieved_In_Country_Id = new SqlParameter("@Recieved_In_Country_Id", SqlDbType.SmallInt);
SqlParameter spRecieved_In_State_Id = new SqlParameter("@Recieved_In_State_Id", SqlDbType.SmallInt);
SqlParameter spRecieved_In_City = new SqlParameter("@Recieved_In_City", SqlDbType.NVarChar, 100);
SqlParameter spRecieved_In_Address = new SqlParameter("@Recieved_In_Address", SqlDbType.NVarChar, 150);
SqlParameter spRecieved_In_ZipCode = new SqlParameter("@Recieved_In_ZipCode", SqlDbType.NVarChar, 20);
SqlParameter spRecieved_In_Email_Address = new SqlParameter("@Recieved_In_Email_Address", SqlDbType.NVarChar, 100);
SqlParameter spUser_Comments = new SqlParameter("@User_Comments", SqlDbType.NVarChar, 500);
SqlParameter spRecieved_By_User_Id = new SqlParameter("@Recieved_By_User_Id", SqlDbType.Int);
SqlParameter spRecieved_DateTime = new SqlParameter("@Recieved_DateTime", SqlDbType.DateTime);
SqlParameter spOriginal_File_Name = new SqlParameter("@Original_File_Name", SqlDbType.NVarChar, 255);
SqlParameter spAzure_Block_Blob_Reference = new SqlParameter("@Azure_Block_Blob_Reference", SqlDbType.NVarChar, 255);
SqlParameter spIs_Visible_To_Anonymous_Users = new SqlParameter("@Is_Visible_To_Anonymous_Users", SqlDbType.Bit);
SqlParameter spIs_Available_For_Download_For_Anonymous_Users = new SqlParameter("@Is_Available_For_Download_For_Anonymous_Users", SqlDbType.Bit);
SqlParameter spIs_Visible_To_Followers_Users = new SqlParameter("@Is_Visible_To_Followers_Users", SqlDbType.Bit);
SqlParameter spIs_Available_For_Download_For_Followers_Users = new SqlParameter("@Is_Available_For_Download_For_Followers_Users", SqlDbType.Bit);
SqlParameter spRecord_Created_By_User_Id = new SqlParameter("@Record_Created_By_User_Id", SqlDbType.Int);
SqlParameter spRecord_Creation_DateTime_UTC = new SqlParameter("@Record_Creation_DateTime_UTC", SqlDbType.DateTime);
SqlParameter spRecord_Last_Updated_By_User_Id = new SqlParameter("@Record_Last_Updated_By_User_Id", SqlDbType.Int);
SqlParameter spRecord_Last_Updated_DateTime_UTC = new SqlParameter("@Record_Last_Updated_DateTime_UTC", SqlDbType.DateTime);
SqlParameter spIs_Active = new SqlParameter("@Is_Active", SqlDbType.Bit);
spUser_Id.Value = p_User_Id;
spGeneral_Document_Type.Value = p_General_Document_Type;
spTitle.Value = p_Title;
spDescription.Value = p_Description;
if (p_Document_Creation_DateTime.HasValue)
{
spDocument_Creation_DateTime.Value = p_Document_Creation_DateTime.Value;
}
else
{
spDocument_Creation_DateTime.Value = DBNull.Value;
}
spSent_By_Entity_Name.Value = p_Sent_By_Entity_Name;
if (p_Sent_By_Entity_Country_Id.HasValue)
{
spSent_By_Entity_Country_Id.Value = p_Sent_By_Entity_Country_Id;
}
else
{
spSent_By_Entity_Country_Id.Value = DBNull.Value;
}
if (p_Sent_By_Entity_State_Id.HasValue)
{
spSent_By_Entity_State_Id.Value = p_Sent_By_Entity_State_Id;
}
else
{
spSent_By_Entity_State_Id.Value = DBNull.Value;
}
spSent_By_Entity_City.Value = p_Sent_By_Entity_City;
spSent_By_Entity_Address.Value = p_Sent_By_Entity_Address;
spSent_By_Entity_ZipCode.Value = p_Sent_By_Entity_ZipCode;
if (p_Sent_By_Entity_DateTime.HasValue)
{
spSent_By_Entity_DateTime.Value = p_Sent_By_Entity_DateTime.Value;
}
else
{
spSent_By_Entity_DateTime.Value = DBNull.Value;
}
spSent_By_Entity_Email_Address.Value = p_Sent_By_Entity_Email_Address;
spSent_To_Entity_Name.Value = p_Sent_To_Entity_Name;
if (p_Sent_To_Entity_Country_Id.HasValue)
{
spSent_To_Entity_Country_Id.Value = p_Sent_To_Entity_Country_Id;
}
else
{
spSent_To_Entity_Country_Id.Value = DBNull.Value;
}
if (p_Sent_To_Entity_State_Id.HasValue)
{
spSent_To_Entity_State_Id.Value = p_Sent_To_Entity_State_Id;
}
else
{
spSent_To_Entity_State_Id.Value = DBNull.Value;
}
spSent_To_Entity_City.Value = p_Sent_To_Entity_City;
spSent_To_Entity_Address.Value = p_Sent_To_Entity_Address;
spSent_To_Entity_ZipCode.Value = p_Sent_To_Entity_ZipCode;
spSent_To_Entity_Email_Address.Value = p_Sent_To_Entity_Email_Address;
spRecieved_Document_DateTime.Value = p_Recieved_Document_DateTime;
if (p_Recieved_In_Country_Id.HasValue)
{
spRecieved_In_Country_Id.Value = p_Recieved_In_Country_Id;
}
else
{
spRecieved_In_Country_Id.Value = DBNull.Value;
}
if (p_Recieved_In_State_Id.HasValue)
{
spRecieved_In_State_Id.Value = p_Recieved_In_State_Id;
}
else
{
spRecieved_In_State_Id.Value = DBNull.Value;
}
spRecieved_In_City.Value = p_Recieved_In_City;
spRecieved_In_Address.Value = p_Recieved_In_Address;
spRecieved_In_ZipCode.Value = p_Recieved_In_ZipCode;
spRecieved_In_Email_Address.Value = p_Recieved_In_Email_Address;
spUser_Comments.Value = p_User_Comments;
if (p_Recieved_By_User_Id.HasValue)
{
spRecieved_By_User_Id.Value = p_Recieved_By_User_Id;
}
else
{
spRecieved_By_User_Id.Value = DBNull.Value;
}
spRecieved_DateTime.Value = p_Recieved_DateTime;
spOriginal_File_Name.Value = p_Original_File_Name;
spAzure_Block_Blob_Reference.Value = p_Azure_Block_Blob_Reference;
spIs_Visible_To_Anonymous_Users.Value = p_Is_Visible_To_Anonymous_Users;
spIs_Available_For_Download_For_Anonymous_Users.Value = p_Is_Available_For_Download_For_Anonymous_Users;
spIs_Visible_To_Followers_Users.Value = p_Is_Visible_To_Followers_Users;
spIs_Available_For_Download_For_Followers_Users.Value = p_Is_Available_For_Download_For_Followers_Users;
spRecord_Created_By_User_Id.Value = p_Record_Created_By_User_Id;
spRecord_Creation_DateTime_UTC.Value = p_Record_Creation_DateTime_UTC;
spRecord_Last_Updated_By_User_Id.Value = p_Record_Last_Updated_By_User_Id;
spRecord_Last_Updated_DateTime_UTC.Value = p_Record_Last_Updated_DateTime_UTC;
spIs_Active.Value = p_Is_Active;
object new_General_Document_Id = SQLHelper.ExecuteStoredProcedure_ReturnDataObjectResult("p_TLBoard_Insert_General_Document_Details",
new List <SqlParameter>()
{
spUser_Id, spGeneral_Document_Type,
spTitle, spDescription, spDocument_Creation_DateTime,
spSent_By_Entity_Name, spSent_By_Entity_Country_Id,
spSent_By_Entity_State_Id, spSent_By_Entity_City,
spSent_By_Entity_Address, spSent_By_Entity_ZipCode,
spSent_By_Entity_DateTime, spSent_By_Entity_Email_Address,
spSent_To_Entity_Name, spSent_To_Entity_Country_Id,
spSent_To_Entity_State_Id, spSent_To_Entity_City,
spSent_To_Entity_Address, spSent_To_Entity_ZipCode,
spSent_To_Entity_Email_Address,
spRecieved_Document_DateTime, spRecieved_In_Country_Id,
spRecieved_In_State_Id, spRecieved_In_City,
spRecieved_In_Address, spRecieved_In_ZipCode,
spRecieved_In_Email_Address,
spUser_Comments, spRecieved_By_User_Id,
spRecieved_DateTime,
spOriginal_File_Name, spAzure_Block_Blob_Reference,
spIs_Visible_To_Anonymous_Users, spIs_Available_For_Download_For_Anonymous_Users,
spIs_Visible_To_Followers_Users, spIs_Available_For_Download_For_Followers_Users,
spRecord_Created_By_User_Id, spRecord_Creation_DateTime_UTC,
spRecord_Last_Updated_By_User_Id, spRecord_Last_Updated_DateTime_UTC,
spIs_Active
});
if (new_General_Document_Id != null)
{
int General_Document_Id_Registered = Convert.ToInt32(new_General_Document_Id);
if (General_Document_Id_Registered > 0)
{
new_Registered_Entity_To_Return = Get_Document_Details_By_Record_Id(General_Document_Id_Registered, p_User_Id, p_Record_Created_By_User_Id);
}
}
return(new_Registered_Entity_To_Return);
}
private void Set_Page_FormControls_Values()
{
int General_Document_Record_Id = int.Parse(this.Request.QueryString["id"]);
int user_Id_Document_Owner = base.Authenticated_User_ID;
General_Documents documentDetails = Business_Logic_Layer_Facade.Instance.GeneralDocuments_Get_By_Id(
General_Document_Record_Id,
user_Id_Document_Owner,
base.Authenticated_User_ID,
base.Authenticated_Permission_Type);
if (documentDetails != null)
{
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
documentDetails.General_Document_Type.ToString(),
this.dropdown_General_Document_Type,
this.label_General_Document_Type);
Common_Tools.Set_DateTime_To_ComboBoxes_And_Label(
documentDetails.Document_Creation_DateTime,
this.textbox_Document_Creation_Date,
this.label_Document_Creation_Date,
this.dropdown_Document_Creation_Time_Hours,
this.dropdown_Document_Creation_Time_Minutes,
this.dropdown_Document_Creation_Time_Seconds,
this.label_Document_Creation_Time
);
this.textbox_Title.Text = documentDetails.Title;
this.label_Title.Text = documentDetails.Title;
this.textbox_Description.Text = documentDetails.Description;
this.label_Description.Text = documentDetails.Description;
this.textbox_Sent_By_Entity_Name.Text = documentDetails.Sent_By_Entity_Name;
this.label_Sent_By_Entity_Name.Text = documentDetails.Sent_By_Entity_Name;
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
documentDetails.Sent_By_Entity_Country_Id.ToString(),
this.dropdown_Sent_By_Entity_Country,
this.label_Sent_By_Entity_Country);
this.Bind_Sent_By_Entity_States_ComboBox();
if (documentDetails.Sent_By_Entity_State_Id.HasValue)
{
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
documentDetails.Sent_By_Entity_State_Id.ToString(),
this.dropdown_Sent_By_Entity_State,
this.label_Sent_By_Entity_State);
}
this.textbox_Sent_By_Entity_City.Text = documentDetails.Sent_By_Entity_City;
this.label_Sent_By_Entity_City.Text = documentDetails.Sent_By_Entity_City;
this.textbox_Sent_By_Entity_Address.Text = documentDetails.Sent_By_Entity_Address;
this.label_Sent_By_Entity_Address.Text = documentDetails.Sent_By_Entity_Address;
this.textbox_Sent_By_Entity_ZipCode.Text = documentDetails.Sent_By_Entity_ZipCode;
this.label_Sent_By_Entity_ZipCode.Text = documentDetails.Sent_By_Entity_ZipCode;
this.textbox_Sent_By_Entity_ZipCode.Text = documentDetails.Sent_By_Entity_ZipCode;
this.label_Sent_By_Entity_ZipCode.Text = documentDetails.Sent_By_Entity_ZipCode;
Common_Tools.Set_DateTime_To_ComboBoxes_And_Label(
documentDetails.Sent_By_Entity_DateTime,
this.textbox_Sent_By_Entity_DateTime,
this.label_Sent_By_Entity_DateTime,
this.dropdown_Sent_By_Entity_Time_Hours,
this.dropdown_Sent_By_Entity_Time_Minutes,
this.dropdown_Sent_By_Entity_Time_Seconds,
this.label_Sent_By_Entity_Time);
this.textbox_Sent_By_Entity_Email_Address.Text = documentDetails.Sent_By_Entity_Email_Address;
this.label_Sent_By_Entity_Email_Address.Text = documentDetails.Sent_By_Entity_Email_Address;
this.textbox_Sent_To_Entity_Name.Text = documentDetails.Sent_To_Entity_Name;
this.label_Sent_To_Entity_Name.Text = documentDetails.Sent_To_Entity_Name;
this.textbox_Sent_To_Entity_Name.Text = documentDetails.Sent_To_Entity_Name;
this.label_Sent_To_Entity_Name.Text = documentDetails.Sent_To_Entity_Name;
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
documentDetails.Sent_To_Entity_Country_Id.ToString(),
this.dropdown_Sent_To_Entity_Country,
this.label_Sent_To_Entity_Country);
this.Bind_Sent_To_Entity_States_ComboBox();
if (documentDetails.Sent_To_Entity_State_Id.HasValue)
{
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
documentDetails.Sent_To_Entity_State_Id.ToString(),
this.dropdown_Sent_To_Entity_State,
this.label_Sent_To_Entity_State);
}
this.textbox_Sent_To_Entity_City.Text = documentDetails.Sent_To_Entity_City;
this.label_Sent_To_Entity_City.Text = documentDetails.Sent_To_Entity_City;
this.textbox_Sent_To_Entity_Address.Text = documentDetails.Sent_To_Entity_Address;
this.label_Sent_To_Entity_Address.Text = documentDetails.Sent_To_Entity_Address;
this.textbox_Sent_To_Entity_ZipCode.Text = documentDetails.Sent_To_Entity_ZipCode;
this.label_Sent_To_Entity_ZipCode.Text = documentDetails.Sent_To_Entity_ZipCode;
this.textbox_Sent_To_Entity_Email_Address.Text = documentDetails.Sent_To_Entity_Email_Address;
this.label_Sent_To_Entity_Email_Address.Text = documentDetails.Sent_To_Entity_Email_Address;
Common_Tools.Set_DateTime_To_ComboBoxes_And_Label(
documentDetails.Sent_By_Entity_DateTime,
this.textbox_Recieved_Document_DateTime,
this.label_Recieved_Document_DateTime,
this.dropdown_Recieved_Document_Time_Hours,
this.dropdown_Recieved_Document_Time_Minutes,
this.dropdown_Recieved_Document_Time_Seconds,
this.label_Recieved_Document_Time);
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
documentDetails.Recieved_In_Country_Id.ToString(),
this.dropdown_Recieved_In_Country,
this.label_Recieved_In_Country);
this.Bind_Recieved_In_States_ComboBox();
if (documentDetails.Recieved_In_State_Id.HasValue)
{
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
documentDetails.Recieved_In_State_Id.ToString(),
this.dropdown_Recieved_In_State,
this.label_Recieved_In_State);
}
this.textbox_Recieved_In_City.Text = documentDetails.Recieved_In_City;
this.label_Recieved_In_City.Text = documentDetails.Recieved_In_City;
this.textbox_Recieved_In_Address.Text = documentDetails.Recieved_In_Address;
this.label_Recieved_In_Address.Text = documentDetails.Recieved_In_Address;
this.textbox_Recieved_In_ZipCode.Text = documentDetails.Recieved_In_ZipCode;
this.label_Recieved_In_ZipCode.Text = documentDetails.Recieved_In_ZipCode;
this.textbox_Recieved_In_Email_Address.Text = documentDetails.Recieved_In_Email_Address;
this.label_Recieved_In_Email_Address.Text = documentDetails.Recieved_In_Email_Address;
this.textbox_User_Comments.Text = documentDetails.User_Comments;
this.label_User_Comments.Text = documentDetails.User_Comments;
this.textbox_User_Comments.Text = documentDetails.User_Comments;
this.label_User_Comments.Text = documentDetails.User_Comments;
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
documentDetails.Recieved_By_User_Id.ToString(),
this.dropdown_Recieved_By_User,
this.label_Recieved_By_User);
Common_Tools.Set_DateTime_To_ComboBoxes_And_Label(
documentDetails.Recieved_DateTime,
this.textbox_Recieved_DateTime,
this.label_Recieved_DateTime,
this.dropdown_Recieved_Time_Hours,
this.dropdown_Recieved_Time_Minutes,
this.dropdown_Recieved_Time_Seconds,
this.label_Recieved_Time);
// ToDo: Show file changing option + view the actual file
this.checkbox_Is_Visible_To_Anonymous_Users.Checked = documentDetails.Is_Visible_To_Anonymous_Users;
this.label_Is_Visible_To_Anonymous_Users.Text = documentDetails.Is_Visible_To_Anonymous_Users ? "Yes" : "No";
this.checkbox_Is_Available_For_Download_For_Anonymous_Users.Checked = documentDetails.Is_Available_For_Download_For_Anonymous_Users;
this.label_Is_Available_For_Download_For_Anonymous_Users.Text = documentDetails.Is_Available_For_Download_For_Anonymous_Users ? "Yes" : "No";
this.checkbox_Is_Visible_To_Followers_Users.Checked = documentDetails.Is_Visible_To_Followers_Users;
this.label_Is_Visible_To_Followers_Users.Text = documentDetails.Is_Visible_To_Followers_Users ? "Yes" : "No";
this.checkbox_Is_Available_For_Download_For_Followers_Users.Checked = documentDetails.Is_Available_For_Download_For_Followers_Users;
this.label_Is_Available_For_Download_For_Followers_Users.Text = documentDetails.Is_Available_For_Download_For_Followers_Users ? "Yes" : "No";
this.checkbox_Is_Active.Checked = documentDetails.Is_Active;
this.label_Is_Active.Text = documentDetails.Is_Active ? "Yes" : "No";
this.label_Record_Created_By_User.Text = documentDetails.Record_Created_By_User_Details.FullName_With_Email;
this.label_Record_Creation_DateTime_UTC.Text = documentDetails.Record_Creation_DateTime_UTC.ToString("dd/MM/yyyy HH:mm:ss UTC");
this.label_Record_Last_Updated_By_User.Text = documentDetails.Record_Last_Updated_By_User_Details.FullName_With_Email.ToString();
this.label_Record_Last_Updated_DateTime_UTC.Text = documentDetails.Record_Last_Updated_DateTime_UTC.ToString("dd/MM/yyyy HH:mm:ss UTC");
}
}
