//chagnes by me
public bool AddAdvertisementDetail(string LoanNo, string ProjectName, string BidPackageNo, string EstimatedAmount,
string AddvertisementDate, string Location, string LastSubmissionDate, string Contactperson, string Description,
int DocCategory, string fileType, byte[] fileContent, string FileName, int UserId, int AgencyId, string contactNum,
string emailid, EntAdvertisement objEnt = null)
{
try
{
// EntAdvertisement objEnt = new EntAdvertisement();
if (objConnection.Connection.State == ConnectionState.Closed)
{
objConnection.Connection.Open();
}
//objConnection.Connection.BeginTransaction();
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@LoanNo", LoanNo),
new SqlParameter("@ProjectName", ProjectName),
new SqlParameter("@BidPackageNo", BidPackageNo),
new SqlParameter("@EstimatedAmount", EstimatedAmount),
new SqlParameter("@AddvertisementDate", AddvertisementDate),
new SqlParameter("@Location", Location),
new SqlParameter("@LastSubmissionDate", LastSubmissionDate),
new SqlParameter("@Contactperson", Contactperson),
new SqlParameter("@Description", Description),
new SqlParameter("@iDocCategory", DocCategory),
new SqlParameter("@MimeType", fileType),
new SqlParameter("@FileContent", fileContent),
new SqlParameter("@DocFileName", FileName),
new SqlParameter("@UserId", UserId),
new SqlParameter("@AgencyId", AgencyId),
new SqlParameter("@output", 0),
new SqlParameter("@ContactNum", contactNum),
new SqlParameter("@EmailId", emailid)
};
param[15].Direction = System.Data.ParameterDirection.Output;
objConnection.ExecuteNonQuery(clsConstant.SP_INSERT_ADVERTISEMENT_DETAILS, CommandType.StoredProcedure, param);
objEnt.OutputValue = Convert.ToInt32((param.GetValue(15) as System.Data.SqlClient.SqlParameter).Value);//get value to retrive output perameter
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
private void SaveAddvertisement()
{
try
{
if (FileUploadDocument.HasFile)
{
filepath = FileUploadDocument.PostedFile.FileName; //IT CONTAINS FILNE NAME WITH EXTENTION
fileName = Path.GetFileName(filepath);
fileType = objAdvertisement.getFileType(filepath);
fileContent = objAdvertisement.getFileContent((FileUploadDocument));
}
else
{
fileContent = new byte[1];
}
CheckValidation objIsValid = new CheckValidation();
EntAdvertisement objEnt1 = new EntAdvertisement();//this(objEnt1) is send reffrence for getting output value without returning obj, we pass this refrence of the obj(objEnt1) fill the output value on this refrence and get without returnng ths one
if (objAdvertisement.AddAdvertisementDetail(ddlLoanNo.SelectedValue, txtProjectName.Text, txtBidPackageNo.Text, txtEstimatedAmount.Text == string.Empty ? "0" : txtEstimatedAmount.Text, txtAddDate.Text, txtLocation.Text, txtLastSubmissionDate.Text, txtContactPerson.Text, txtDescription.Text, Convert.ToInt32(ddlDocCat.SelectedValue), fileType, fileContent, fileName, userInform.UserID, userInform.AgencyID, txtContactNumber.Text, txtEmailId.Text, objEnt1))
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "Insert Successfuly";
Utility ObjUtility = new Utility();
if (flag)
{
ListOfSelectedVendorGroup(objEnt1.OutputValue);
}
else
{
ObjUtility.ResetFormControl(divControl);
}
}
else
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "Error is there.";
}
}
catch (Exception ex)
{
logger.Error(ex);
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "Error is there.";
}
}
private void fillAllInfo(int advertisementId)
{
try
{
if (advertisementId != 0)
{
objEnt = objAdvertisement.GetAdvertisementEntity(advertisementId);
}
if (objEnt != null)
{
txtProjectName.Text = objEnt.ProjectName;
ddlLoanNo.ClearSelection();
if (ddlLoanNo.Items.FindByValue(objEnt.LoanNo) != null)
{
((ListItem)ddlLoanNo.Items.FindByValue(objEnt.LoanNo)).Selected = true;
}
txtBidPackageNo.Text = objEnt.BidPackageNo;
txtEstimatedAmount.Text = objEnt.EstimatedAmount == "0" ? string.Empty : objEnt.EstimatedAmount;
txtLocation.Text = objEnt.Location;
txtContactPerson.Text = objEnt.Contactperson;
txtDescription.Text = objEnt.Description;
//file attachment
ddlDocCat.ClearSelection();
if (ddlDocCat.Items.FindByValue(objEnt.DocCategory) != null)
{
((ListItem)ddlDocCat.Items.FindByValue(objEnt.DocCategory)).Selected = true;
}
//if (objEnt.AddvertisementDate != null || objEnt.AddvertisementDate!= "01 Jan 1900")
string[] seprateAddDate = objEnt.AddvertisementDate.Split(' '); //0 index contain Date in 1/1/1900 format becoz we took string for storing date so its adding time also when we dispaly date in this property so we split it by space.
// if (objEnt.AddvertisementDate != null && objEnt.AddvertisementDate != "01 Jan 1900")
if (objEnt.AddvertisementDate != null && seprateAddDate[0] != "1/1/1900")
{
// if (objEnt.AddvertisementDate != "" || objEnt.AddvertisementDate != "01 Jan 1900")
// if (objEnt.AddvertisementDate != "" && objEnt.AddvertisementDate != "01 Jan 1900")
if (objEnt.AddvertisementDate != "" && seprateAddDate[0] != "1/1/1900")
{
DateTime dtaddvertisementdate = DateTime.Parse(objEnt.AddvertisementDate);
txtAddDate.Text = dtaddvertisementdate.ToString(clsConstant.DATE_FORMAT);
}
}
else
{
txtAddDate.Text = "";
}
string[] seprateLastSubDate = objEnt.LastSubmissionDate.Split(' '); //0 index contain Date in 1/1/1900 format becoz we took string for storing date so its adding time also when we dispaly date in this property so we split it by space.
// if (objEnt.LastSubmissionDate != null || objEnt.LastSubmissionDate != "01 Jan 1900")
// if (objEnt.LastSubmissionDate != null && objEnt.LastSubmissionDate != "01 Jan 1900")
if (objEnt.LastSubmissionDate != null && seprateLastSubDate[0] != "1/1/1900")
{
// if (objEnt.LastSubmissionDate != "" || objEnt.LastSubmissionDate != "01 Jan 1900")
// if (objEnt.LastSubmissionDate != "" && objEnt.LastSubmissionDate != "01 Jan 1900")
if (objEnt.LastSubmissionDate != "" && seprateLastSubDate[0] != "1/1/1900")
{
DateTime dtlastsubmissiondate = DateTime.Parse(objEnt.LastSubmissionDate);
txtLastSubmissionDate.Text = dtlastsubmissiondate.ToString(clsConstant.DATE_FORMAT);
}
}
else
{
txtLastSubmissionDate.Text = "";
}
FileContentDB = objEnt.FileContent;
filenamedb = objEnt.FileName;
txtContactNumber.Text = objEnt.ContactNumber;
txtEmailId.Text = objEnt.EmailId;
btnUpdate.Visible = true;
btnSubmit.Visible = false;
lblMessage.ForeColor = System.Drawing.Color.Black;
// lblMessage.Text = ds.Tables[0].Rows[11][1].ToString();
}
else
{
btnUpdate.Visible = false;
btnSubmit.Visible = true;
lblMessage.Text = "";
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
public EntAdvertisement GetAdvertisementEntity(int advertisementId)
{
EntAdvertisement objEnt = new EntAdvertisement();
SqlDataReader reader;
object objFile = null;
try
{
if (objConnection.Connection.State == ConnectionState.Closed)
{
objConnection.Connection.Open();
}
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@iAdvertisementId", advertisementId) };
reader = objConnection.ExecuteReaderQuery(clsConstant.SP_SELECT_SPECIFIC_ADVERTISEMENT_DETAILS, CommandType.StoredProcedure, param);
while (reader.Read())
{
// bnAdvertisementFile, dtAdvertisementSent, iSentEmailDocCat
objEnt.AdvertisementId = Convert.ToInt32(reader.GetValue(0));
objEnt.LoanNo = reader.GetValue(1).ToString();
objEnt.ProjectName = reader.GetValue(2).ToString();
objEnt.BidPackageNo = reader.GetValue(3).ToString();
objEnt.EstimatedAmount = reader.GetValue(4).ToString();
string dtAdvertisement = reader.GetValue(5).ToString();
if (dtAdvertisement == "" || dtAdvertisement == "01 Jan 1900")
{
objEnt.AddvertisementDate = "";
}
else
{
objEnt.AddvertisementDate = dtAdvertisement;
}
objEnt.Location = reader.GetValue(6).ToString();
string dtSubmission = reader.GetValue(7).ToString();
if (dtSubmission == "" || dtSubmission == "01 Jan 1900")
{
objEnt.LastSubmissionDate = "";
}
else
{
objEnt.LastSubmissionDate = dtSubmission;
}
objEnt.Contactperson = reader.GetValue(8).ToString();
objEnt.Description = reader.GetValue(9).ToString();
objEnt.DocCategory = reader.GetValue(10).ToString();
objFile = reader.GetValue(11);
if (DBNull.Value == objFile)
{
objEnt.FileContent = null;
}
else
{
objEnt.FileContent = (Byte[])(objFile);
}
objEnt.FileName = reader.GetValue(12).ToString();
objEnt.MimeType = reader.GetValue(13).ToString();
objEnt.ContactNumber = reader.GetValue(14).ToString();
objEnt.EmailId = reader.GetValue(15).ToString();
}
return(objEnt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
