/// <summary>
/// Insert or Update StepDocMapped
/// </summary>
/// <param name="objStepDocMappedModel"></param>
/// <returns></returns>
public StepDocMappedModel InsertUpdateStepDocMapped(StepDocMappedModel objStepDocMappedModel)
{
try
{
int ErrorCode = 0;
string ErrorMessage = "";
SqlParameter pErrorCode = new SqlParameter("@ErrorCode", ErrorCode);
pErrorCode.Direction = ParameterDirection.Output;
SqlParameter pErrorMessage = new SqlParameter("@ErrorMessage", ErrorMessage);
pErrorMessage.Direction = ParameterDirection.Output;
SqlParameter[] parmList =
{
new SqlParameter("@StepDocMappedID", objStepDocMappedModel.StepDocMappedID)
, new SqlParameter("@DocumentID", objStepDocMappedModel.DocumentID)
, new SqlParameter("@StepID", objStepDocMappedModel.StepID)
, new SqlParameter("@DisplayOrder", objStepDocMappedModel.DisplayOrder)
, new SqlParameter("@IsActive", objStepDocMappedModel.IsActive)
, new SqlParameter("@CreatedBy", objStepDocMappedModel.CreatedBy)
, pErrorCode
, pErrorMessage
};
//If StepDocMappedId is 0 Than Insert StepDocMapped else Update StepDocMapped
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.ADMIN_INSERTUPDATESTEPDOCMAPPED, parmList);
//set error code and message
objStepDocMappedModel.ErrorCode = Convert.ToInt32(pErrorCode.Value);
objStepDocMappedModel.Message = Convert.ToString(pErrorMessage.Value);
return(objStepDocMappedModel);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Get StepDocMapped By Id
/// </summary>
/// <param name="StepDocMappedId"></param>
/// <returns>StepDocMapped Model</returns>
public StepDocMappedModel GetStepDocMappedById(int StepDocMappedId)
{
//Call GetStepDocMappedBYId method of dataLayer which will return Datatable.
DataTable dt = objDLStepDocMapped.GetStepDocMappedById(StepDocMappedId);
StepDocMappedModel objStepDocMappedModel = new StepDocMappedModel();
// if datatable has row than set object parameters
if (dt.Rows.Count > 0)
{
objStepDocMappedModel = GetDataRowToEntity <StepDocMappedModel>(dt.Rows[0]);
}
return(objStepDocMappedModel);
}
/// <summary>
/// Get StepDocMapped List based on paging, searching and sorting parameter
/// </summary>
/// <param name="objViewStepDocMappedModel">object of Model ViewStepDocMappedModel</param>
/// <returns></returns>
public ViewStepDocMappedModel GetStepDocMappedList(int StepID, int DocumentID)
{
ViewStepDocMappedModel objViewStepDocMappedModel = new ViewStepDocMappedModel();
objViewStepDocMappedModel.StepDocMappedList = new List <StepDocMappedModel>();
//call GetStepDocMappedList Method which will retrun datatable of StepDocMapped
DataTable dtStepDocMapped = objDLStepDocMapped.GetStepDocMappedByDocumentID(StepID, DocumentID);
//fetch each row of datable
foreach (DataRow dr in dtStepDocMapped.Rows)
{
//Convert datarow into Model object and set Model object property
StepDocMappedModel itemStepDocMappedModel = GetDataRowToEntity <StepDocMappedModel>(dr);
//Add StepDocMapped in List
objViewStepDocMappedModel.StepDocMappedList.Add(itemStepDocMappedModel);
}
return(objViewStepDocMappedModel);
}
public StepDocMappedModel InsertUpdateStepDocMapped(StepDocMappedModel objStepDocMappedModel)
{
return(objBLStepDocMapped.InsertUpdateStepDocMapped(objStepDocMappedModel));
}
/// <summary>
/// Insert or Update StepDocMapped
/// </summary>
/// <param name="objStepDocMappedModel">object of StepDocMapped Model</param>
/// <param name="ErrorCode"></param>
/// <param name="ErrorMessage"></param>
/// <returns></returns>
public StepDocMappedModel InsertUpdateStepDocMapped(StepDocMappedModel objStepDocMappedModel)
{
//call InsertUpdateStepDocMapped Method of dataLayer and return StepDocMappedModel
return(objDLStepDocMapped.InsertUpdateStepDocMapped(objStepDocMappedModel));
}
