public IHttpActionResult Put(AssessorCommunicationDetail assessorCommunicationDetail, int assessorId)
{
OperationStatus operationStatus = new OperationStatus()
{
ServiceMethod = "PUT", ServiceName = "UpdateAssessorCommunicationDetail", RequestProcessed = false, RequestSuccessful = false
};
if (assessorCommunicationDetail != null)
{
if (assessorId > 0)
{
//Comment : Here set value of assessorId into DTO object and then call Update method
assessorCommunicationDetail.AssessorId = assessorId;
operationStatus = GetAssessorCommunicationDetailDbService().UpdateCommunicationDetail(assessorCommunicationDetail);
}
else
{
operationStatus.Messages.Add(new Message()
{
DTOName = "AssessorCommunicationDetail", DTOProperty = "", MessageType = MessageType.SystemError, Text = "Please use POST method to create object."
});
}
}
return(Ok(operationStatus));
}
OperationStatus IAssessorCommunicationDetailDbService.AddCommunicationDetail(AssessorCommunicationDetail data)
{
OperationStatus operationStatus = new OperationStatus()
{
RequestProcessed = false, RequestSuccessful = false
};
#region Comment : Here Add/Create details
try
{
#region Supply data object for DB insertion
//Comment : Here record id which is being effected at db level
Int64 effectedRecordId = SubmitAssessorCommunicationDetails(data);
//if successfully executed
if (effectedRecordId > 0)
{
//Comment : Here if data has been "successfully submitted" then capture those details
operationStatus.RequestProcessed = true;
operationStatus.RequestSuccessful = true;
operationStatus.ServiceName = "AddAssessorCommunicationDetail";
operationStatus.ServiceMethod = "POST";
operationStatus.AffectedIds.Add(new AffectedId()
{
DTOName = "AssessorCommunicationDetail", DTOProperty = "AssessorId", IdValue = effectedRecordId.ToString(), OperationType = OperationType.POST
});
}
else
{
//LoggingService.Instance.Fatal(string.Format("Unable to add user :{0}{1}", Environment.NewLine, object));
}
#endregion
}
catch (Exception ex)
{
operationStatus.RequestProcessed = true;
operationStatus.RequestSuccessful = false;
operationStatus.Messages.Add(new Message()
{
DTOName = "AssessorCommunicationDetail", DTOProperty = "", MessageType = MessageType.SystemError, Text = ex.Message
});
}
#endregion
return(operationStatus);
}
public IHttpActionResult Post(AssessorCommunicationDetail assessor)
{
OperationStatus operationStatus = new OperationStatus()
{
ServiceMethod = "POST", ServiceName = "AddAssessorCommunicationDetail", RequestProcessed = false, RequestSuccessful = false
};
if (assessor != null)
{
if (assessor.AssessorId > 0)
{
operationStatus = GetAssessorCommunicationDetailDbService().AddCommunicationDetail(assessor);
}
//else
//{
// operationStatus.Messages.Add(new Message() { DTOName = "AssessorCommunicationDetail", DTOProperty = "", MessageType = MessageType.SystemError, Text = "Please use PUT method to update state of object." });
//}
}
return(Ok(operationStatus));
}
private Int64 SubmitAssessorCommunicationDetails(AssessorCommunicationDetail data)
{
var parameterList = new List <System.Data.IDbDataParameter>
{
new SqlParameter()
{
ParameterName = "@AssessorId", Value = data.AssessorId, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "@CityId", Value = data.CityId, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@OtherLocalityName", Value = data.OtherLocalityName, SqlDbType = SqlDbType.VarChar, Size = 100
},
new SqlParameter()
{
ParameterName = "@EmailId", Value = data.EmailId, SqlDbType = SqlDbType.VarChar, Size = 150
},
new SqlParameter()
{
ParameterName = "@MobileNo", Value = data.MobileNo, SqlDbType = SqlDbType.VarChar, Size = 10
},
new SqlParameter()
{
ParameterName = "@WhatsAppOnPrimaryNo", Value = data.WhatsAppOnPrimaryNo, SqlDbType = SqlDbType.Bit
},
new SqlParameter()
{
ParameterName = "@WhatsAppNo", Value = data.WhatsAppNo, SqlDbType = SqlDbType.VarChar, Size = 10
},
new SqlParameter()
{
ParameterName = "@SecondaryEmailId", Value = data.SecondaryEmailId, SqlDbType = SqlDbType.VarChar, Size = 150
},
new SqlParameter()
{
ParameterName = "@SecondaryMobileNo", Value = data.SecondaryMobileNo, SqlDbType = SqlDbType.VarChar, Size = 10
},
new SqlParameter()
{
ParameterName = "@LandlineNo", Value = data.LandlineNo, SqlDbType = SqlDbType.VarChar, Size = 15
},
new SqlParameter()
{
ParameterName = "@EmergancyContactNo1", Value = data.EmergancyContactNo1, SqlDbType = SqlDbType.VarChar, Size = 10
},
new SqlParameter()
{
ParameterName = "@EmergancyContactNo2", Value = data.EmergancyContactNo2, SqlDbType = SqlDbType.VarChar, Size = 50
},
new SqlParameter()
{
ParameterName = "@CommAddressLine1", Value = data.CommAddressLine1, SqlDbType = SqlDbType.VarChar, Size = 50
},
new SqlParameter()
{
ParameterName = "@CommAddressLine2", Value = data.CommAddressLine2, SqlDbType = SqlDbType.VarChar, Size = 50
},
new SqlParameter()
{
ParameterName = "@CommAddressLine3", Value = data.CommAddressLine3, SqlDbType = SqlDbType.VarChar, Size = 50
},
new SqlParameter()
{
ParameterName = "@CommAddressPinCode", Value = data.CommAddressPinCode, SqlDbType = SqlDbType.VarChar, Size = 5
},
new SqlParameter()
{
ParameterName = "@HasSameAsCommAddress", Value = data.HasSameAsCommAddress, SqlDbType = SqlDbType.Bit
},
new SqlParameter()
{
ParameterName = "@PermanentAddressLine1", Value = data.PermanentAddressLine1, SqlDbType = SqlDbType.VarChar, Size = 50
},
new SqlParameter()
{
ParameterName = "@PermanentAddressLine2", Value = data.PermanentAddressLine2, SqlDbType = SqlDbType.VarChar, Size = 50
},
new SqlParameter()
{
ParameterName = "@PermanentAddressLine3", Value = data.PermanentAddressLine3, SqlDbType = SqlDbType.VarChar, Size = 50
},
new SqlParameter()
{
ParameterName = "@PermanentAddressPinCode", Value = data.PermanentAddressPinCode, SqlDbType = SqlDbType.VarChar, Size = 5
},
new SqlParameter()
{
ParameterName = "AssessorId", SqlDbType = SqlDbType.BigInt, Direction = ParameterDirection.ReturnValue
}
};
//Comment : Here get DbConnector object
var rowEffeted = GetDbConnector().ExecuteNonQuery("MaintainAssessorCommunicationDetails", QueryCommandType.StoredProcedure, parameterList);
//if successfully executed
if (rowEffeted > 0)
{
Int64 assessorId = Convert.ToInt32(parameterList[parameterList.Count() - 1].Value);
return(assessorId);
}
else
{
//LoggingService.Instance.Fatal(string.Format("Unable to add user :{0}{1}", Environment.NewLine, object));
}
return(0);
}
