public int Insert(ComplaintHistoryEntity entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO ComplaintHistory( ");
strSql.Append("ComplaintID,ModifiedBy,ModifiedOn,Comments,Action) ");
strSql.Append("VALUES( ");
strSql.Append("@ComplaintID,@ModifiedByID,@ModifiedOn,@Comments,@Action) ");
strSql.Append(";select ISNULL( SCOPE_IDENTITY(),0);");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "ComplaintID", DbType.Int32, entity.ComplaintID);
db.AddInParameter(dbCommand, "ModifiedByID", DbType.Int32, entity.ModifiedByID);
db.AddInParameter(dbCommand, "ModifiedOn", DbType.DateTime, entity.ModifiedOn);
db.AddInParameter(dbCommand, "Comments", DbType.String, entity.Comments);
db.AddInParameter(dbCommand, "Action", DbType.String, entity.Action);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(),
base.FormatParameters(dbCommand.Parameters),
ex.Message));
return(0);
}
}
}
public List <ComplaintHistoryEntity> GetHistorysByComID(int cid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ch.*, u.FirstName+' '+u.LastName AS ModifiedByName from ComplaintHistory ch, Users u ");
strSql.Append("WHERE ch.ComplaintID = @ComplaintID ");
strSql.Append("AND ch.ModifiedBy = u.UserID ");
strSql.Append("ORDER BY ch.ModifiedOn DESC ");
List <ComplaintHistoryEntity> list = new List <ComplaintHistoryEntity>();
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "ComplaintID", DbType.Int32, cid);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
list.Add(ComplaintHistoryEntity.ReaderBind(dataReader));
}
}
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(),
base.FormatParameters(dbCommand.Parameters),
ex.Message));
}
}
return(list);
}
public bool Update(ComplaintHistoryEntity entity)
{
return(true);
}
protected void btnOK_Click(object sender, EventArgs e)
{
IComplaintRepository comRepository = ObjectFactory.GetInstance <IComplaintRepository>();
cmplEntity = comRepository.Get(QS("ComplaintID", 0));
// Update Complaint History
ComplaintHistoryEntity comHisEntity = new ComplaintHistoryEntity();
comHisEntity.ComplaintID = QS("ComplaintID", 0);
comHisEntity.ModifiedOn = DateTime.Now;
comHisEntity.ModifiedByID = UserInfo.UserID;
comHisEntity.Comments = txtComments.Text;
string actionStr = ((ComplaintStatusEnum)this.cmplEntity.Status).ToString() + " To " + ddlAction.SelectedValue;
comHisEntity.Action = actionStr;
IComplaintHistoryRepository comHisRepository = ObjectFactory.GetInstance <IComplaintHistoryRepository>();
comHisRepository.Insert(comHisEntity);
// Update Complaint
ComplaintEntity newCmplEntity = new ComplaintEntity();
newCmplEntity.Comments = txtComments.Text;
newCmplEntity.UpdatedOn = DateTime.Now;
newCmplEntity.UpdatedByID = UserInfo.UserID;
newCmplEntity.ComplaintID = QS("ComplaintID", 0);
switch (ddlAction.SelectedValue)
{
case "DELETE":
//Response.Redirect("http://localhost:2777/Complaint/Complaint/Delete?id=" + newCmplEntity.ComplaintID + "&type=" + (SunNet.PMNew.Entity.ComplaintModel.Enums.ComplaintTypeEnum)cmplEntity.Type + "&returnUrl=http://localhost:27273/OA/Complaints/Complaints.aspx");
//Get System properties from System table
ISystemRepository systemRepository = ObjectFactory.GetInstance <ISystemRepository>();
SystemEntity sysEntity = systemRepository.GetBySysName(cmplEntity.SystemName);
//Delete Item
string serverName = sysEntity.IP + (sysEntity.Port.Length > 0 ? ":" + sysEntity.Port : "");
string connStr = String.Format("server={0};database={1};uid={2};pwd={3};max pool size =1024000",
serverName, sysEntity.DBLocation, sysEntity.UserName, sysEntity.UserPwd);
string type = ((ComplaintTypeEnum)cmplEntity.Type).ToString();
if (complaintApp.DeleteComItem(connStr, sysEntity.Procedure, type, cmplEntity.TargetID))
{
Response.Write("Deletion Succeeded.");
}
else
{
Response.Write("Deletion Failed.");
}
newCmplEntity.Status = 1;
break;
case "APPROVEBUTNOTDEL":
newCmplEntity.Status = 2;
break;
case "DENY":
newCmplEntity.Status = 3;
break;
}
complaintApp.UpdateComplaint(newCmplEntity);
Redirect(EmptyPopPageUrl, false, true);
}
