private PartnerStatusLog ConvertDataRowToPartnerStatusLog(DataRow row)
{
var obj = new PartnerStatusLog();
obj.Id = row["log_id"] == DBNull.Value ? -1 : int.Parse(row["log_id"].ToString());
obj.Note = row["note"] == DBNull.Value ? string.Empty : row["note"].ToString();
var partnerAccount = row["partner_acc"] == DBNull.Value ? -1 : int.Parse(row["partner_acc"].ToString());
obj.Partner = partnerManager.GetPartnerByAccount(partnerAccount);
var oldStatus = row["old_status"] == DBNull.Value ? -1 : int.Parse(row["old_status"].ToString());
obj.OldStatus = new PartnerStatusRepo(db).GetStatus(oldStatus);
var newStatus = row["new_status"] == DBNull.Value ? -1 : int.Parse(row["new_status"].ToString());
obj.NewStatus = new PartnerStatusRepo(db).GetStatus(newStatus);
obj.CreatedOn = row["createdon"] == DBNull.Value ? DateTime.MinValue : DateTime.Parse(row["createdon"].ToString());
obj.NewStatusExpireOn = row["newstatus_expireon"] == DBNull.Value ? DateTime.MinValue : DateTime.Parse(row["newstatus_expireon"].ToString());
var createdAccount = row["createdbyacc"] == DBNull.Value ? -1 : int.Parse(row["createdbyacc"].ToString());
var creator = partnerManager.GetPartnerByAccount(createdAccount);
obj.CreatedBy.Id = creator.Id;
obj.CreatedBy.Account = creator.Account;
obj.CreatedBy.Name = creator.Name;
return(obj);
}
public OpertionResult Create(PartnerStatusLog log)
{
try
{
#region Parameters
var parameters = new List <OracleParameter> {
new OracleParameter {
ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue
},
new OracleParameter {
ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = log.CreatedBy.Id
},
new OracleParameter {
ParameterName = "v_createdbyacc", OracleDbType = OracleDbType.Int32, Value = log.CreatedBy.Account
},
new OracleParameter {
ParameterName = "v_partner_id", OracleDbType = OracleDbType.Varchar2, Value = log.Partner.Id
},
new OracleParameter {
ParameterName = "v_partner_acc", OracleDbType = OracleDbType.Int32, Value = log.Partner.Account
},
new OracleParameter {
ParameterName = "v_old_status", OracleDbType = OracleDbType.Int32, Value = log.OldStatus.Id
},
new OracleParameter {
ParameterName = "v_new_status", OracleDbType = OracleDbType.Int32, Value = log.NewStatus.Id
},
new OracleParameter {
ParameterName = "v_note", OracleDbType = OracleDbType.NVarchar2, Value = log.Note
},
new OracleParameter {
ParameterName = "v_newstatus_expireon", OracleDbType = OracleDbType.Date, Value = log.NewStatusExpireOn
}
};
#endregion
db.ExecuteStoredProc("pk_infra.fn_create_partnerstatus_log", parameters);
var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString());
if (result > 0)
{
return(new OpertionResult {
AffectedCount = result, Success = true, Error = string.Empty
});
}
else
{
return(new OpertionResult {
AffectedCount = result, Success = false, Error = string.Empty
});
}
}
catch (Exception ex)
{
return(new OpertionResult {
AffectedCount = -1, Success = false, Error = ex.Message
});
}
}
