public static Entity.Common.MemberDocument GetAllById(int MemberId)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pMemberId", SqlDbType.Int, MemberId);
oDm.CommandType = CommandType.StoredProcedure;
Entity.Common.MemberDocument memberDocument = new Entity.Common.MemberDocument();
SqlDataReader dr;
dr = oDm.ExecuteReader("usp_MemberDocument_GetAllById");
if (dr.HasRows)
{
while (dr.Read())
{
memberDocument.DocName_1 = dr["DocName_1"].ToString();
memberDocument.DocFile_1 = dr["DocFile_1"].ToString();
memberDocument.DocName_2 = dr["DocName_2"].ToString();
memberDocument.DocFile_2 = dr["DocFile_2"].ToString();
memberDocument.DocName_3 = dr["DocName_3"].ToString();
memberDocument.DocFile_3 = dr["DocFile_3"].ToString();
}
}
return(memberDocument);
}
}
private void PopulateMemberDocument()
{
BusinessLayer.Common.MemberDocument objMemberDocument = new BusinessLayer.Common.MemberDocument();
Entity.Common.MemberDocument memberDocument = new Entity.Common.MemberDocument();
memberDocument = objMemberDocument.GetAllById(MemberId);
if (memberDocument != null)
{
txtDocName_1.Text = memberDocument.DocName_1;
txtDocName_2.Text = memberDocument.DocName_2;
txtDocName_3.Text = memberDocument.DocName_3;
if (memberDocument.DocFile_1 != null && !string.IsNullOrEmpty(memberDocument.DocFile_1.Trim()))
{
lblDocFile_1.Text = Server.HtmlDecode(@"<a href='MemberDocument/" + memberDocument.DocFile_1.Trim() + "' target='_blank'>Download File</a>");
}
if (memberDocument.DocFile_2 != null && !string.IsNullOrEmpty(memberDocument.DocFile_2.Trim()))
{
lblDocFile_2.Text = Server.HtmlDecode(@"<a href='MemberDocument/" + memberDocument.DocFile_2.Trim() + "' target='_blank'>Download File</a>");
}
if (memberDocument.DocFile_3 != null && !string.IsNullOrEmpty(memberDocument.DocFile_3.Trim()))
{
lblDocFile_3.Text = Server.HtmlDecode(@"<a href='MemberDocument/" + memberDocument.DocFile_3.Trim() + "' target='_blank'>Download File</a>");
}
}
}
private void SaveDocument(int ID)
{
BusinessLayer.Common.MemberDocument objMemberDocument = new BusinessLayer.Common.MemberDocument();
Entity.Common.MemberDocument memberDocument = new Entity.Common.MemberDocument();
memberDocument.Mode = Mode;
memberDocument.MemberId = ID;
memberDocument.DocName_1 = txtDocName_1.Text.Trim();
memberDocument.DocName_2 = txtDocName_2.Text.Trim();
memberDocument.DocName_3 = txtDocName_3.Text.Trim();
if (fileUploadDocument_1.PostedFile.FileName != null && fileUploadDocument_1.PostedFile.ContentLength > 0)
{
memberDocument.DocFile_1 = System.IO.Path.GetExtension(fileUploadDocument_1.FileName);
}
else
{
memberDocument.DocFile_1 = "";
}
if (fileUploadDocument_2.PostedFile.FileName != null && fileUploadDocument_2.PostedFile.ContentLength > 0)
{
memberDocument.DocFile_2 = System.IO.Path.GetExtension(fileUploadDocument_2.FileName);
}
else
{
memberDocument.DocFile_2 = "";
}
if (fileUploadDocument_3.PostedFile.FileName != null && fileUploadDocument_3.PostedFile.ContentLength > 0)
{
memberDocument.DocFile_3 = System.IO.Path.GetExtension(fileUploadDocument_3.FileName);
}
else
{
memberDocument.DocFile_3 = "";
}
objMemberDocument.Save(memberDocument);
if (!string.IsNullOrEmpty(memberDocument.DocFile_1.Trim()))
{
string ff = (Server.MapPath("") + "\\MemberDocument\\" + ID.ToString() + "_1" + memberDocument.DocFile_1.Trim());
fileUploadDocument_1.PostedFile.SaveAs(ff);
}
if (!string.IsNullOrEmpty(memberDocument.DocFile_2.Trim()))
{
string ff = (Server.MapPath("") + "\\MemberDocument\\" + ID.ToString() + "_2" + memberDocument.DocFile_2.Trim());
fileUploadDocument_2.PostedFile.SaveAs(ff);
}
if (!string.IsNullOrEmpty(memberDocument.DocFile_3.Trim()))
{
string ff = (Server.MapPath("") + "\\MemberDocument\\" + ID.ToString() + "_3" + memberDocument.DocFile_3.Trim());
fileUploadDocument_3.PostedFile.SaveAs(ff);
}
}
public static void Save(Entity.Common.MemberDocument memberDocument)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pMode", SqlDbType.VarChar, 10, memberDocument.Mode);
oDm.Add("@pMemberId", SqlDbType.Int, memberDocument.MemberId);
oDm.Add("@pDocName_1", SqlDbType.VarChar, 100, memberDocument.DocName_1);
oDm.Add("@pDocFile_1", SqlDbType.VarChar, 50, memberDocument.DocFile_1);
oDm.Add("@pDocName_2", SqlDbType.VarChar, 100, memberDocument.DocName_2);
oDm.Add("@pDocFile_2", SqlDbType.VarChar, 50, memberDocument.DocFile_2);
oDm.Add("@pDocName_3", SqlDbType.VarChar, 100, memberDocument.DocName_3);
oDm.Add("@pDocFile_3", SqlDbType.VarChar, 50, memberDocument.DocFile_3);
oDm.CommandType = CommandType.StoredProcedure;
oDm.ExecuteNonQuery("usp_MemberDocument_Save");
}
}
public void Save(Entity.Common.MemberDocument memberDocument)
{
DataAccess.Common.MemberDocument.Save(memberDocument);
}
