public LookupDetails SaveLookupDetails(LookupDetails lookupDetails)
{
Logging.LogDebugMessage("Method: SaveLookupDetails, MethodType: Post, Layer: LookupsController, Parameters: lookupDetails = " + JsonConvert.SerializeObject(lookupDetails));
using (LookupsBL lookupsBL = new LookupsBL())
{
return(lookupsBL.SaveLookupDetails(lookupDetails));
}
}
/// <summary> Save or Update Lookup Details </summary>
/// <param name="lookupDetail">LookupDetails Object</param>
/// <returns>LookupDetails Object</returns>
public LookupDetails SaveLookupDetails(LookupDetails lookupDetail)
{
Logging.LogDebugMessage("Method: SaveLookupDetails, MethodType: Post, Layer: LookupsBL, Parameters: lookupDetails = " + JsonConvert.SerializeObject(lookupDetail));
try
{
using (LookupsDAL lookups = new LookupsDAL())
{
return(lookups.SaveLookupDetails(lookupDetail));
}
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: SaveLookupDetails, Layer: LookupsBL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: SaveLookupDetails, Layer: LookupsBL, Stack Trace: " + ex.ToString());
throw;
}
}
/// <summary> Get LoookupDetails By LookupDetailsId </summary>
/// <param name="LookupDetailsId">The Integer object</param>
/// <returns>LookupDetails object</returns>
public LookupDetails GetLookupDetailsById(int LookupDetailsId)
{
Logging.LogDebugMessage("Method: GetLookupDetailsById, MethodType: Get, Layer: LookupsDAL, Parameters: LookupDetailsId = " + LookupDetailsId.ToString());
var dataSet = new DataSet();
LookupDetails lookupDetails = new LookupDetails();
try
{
using (var command = new SqlCommand())
{
command.Connection = new SqlConnection(this.ConnectionString);
command.CommandText = "USP_GetLookupDetailsById";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsId", Value = LookupDetailsId
});
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
adapter.Fill(dataSet);
if (dataSet != null && dataSet.Tables.Count > 0)
{
lookupDetails = EntityCollectionHelper.ConvertTo <LookupDetails>(dataSet.Tables[0]).FirstOrDefault();
}
}
}
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: GetLookupDetailsById, Layer: LookupsDAL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: GetLookupDetailsById, Layer: LookupsDAL, Stack Trace: " + ex.ToString());
throw;
}
return(lookupDetails);
}
/// <summary>
/// To set the lookup details of the field.
/// </summary>
/// <param name="fieldName">Name (String) of the field</param>
/// <param name="value">value (Object) of the field</param>
public void SetLookupDetails(string fieldName, object value)
{
LookupDetails.Add(fieldName, value);
}
/// <summary> Save or Update Lookup Details </summary>
/// <param name="lookupDetail">LookupDetails Object</param>
/// <returns>LookupDetails Object</returns>
public LookupDetails SaveLookupDetails(LookupDetails lookupDetail)
{
var dataset = new DataSet();
LookupDetails lookupDetails = new LookupDetails();
Logging.LogDebugMessage("Method: SaveLookupDetails, MethodType: Post, Layer: LookupsDAL, Parameters: lookupDetail = " + JsonConvert.SerializeObject(lookupDetail));
try
{
using (var command = new SqlCommand())
{
command.Connection = new SqlConnection(this.ConnectionString);
command.CommandText = "USP_SaveLookupDetails";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsId", Value = lookupDetail.LookupDetailsId
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupId", Value = lookupDetail.LookupId
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsDescription", Value = lookupDetail.LookupDetailsDescription
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsValue", Value = lookupDetail.LookupDetailsValue
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsLongDescription", Value = lookupDetail.LookupDetailsLongDescription
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsSequenceOrder", Value = lookupDetail.LookupDetailsSequenceOrder
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsCrossWalkValue", Value = lookupDetail.LookupDetailsCrossWalkValue
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsCategory", Value = lookupDetail.LookupDetailsCategory
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsType", Value = lookupDetail.LookupDetailsType
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsSubSequenceOrder", Value = lookupDetail.LookupDetailsSubSequenceOrder
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsSubCategory", Value = lookupDetail.LookupDetailsSubCategory
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsSubType", Value = lookupDetail.LookupDetailsSubType
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsShortDescription", Value = lookupDetail.LookupDetailsShortDescription
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsDisplayDescription", Value = lookupDetail.LookupDetailsDisplayDescription
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsUsedInDisplay", Value = lookupDetail.IsUsedInDisplay
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsEffectiveFrom", Value = lookupDetail.LookupDetailsEffectiveFrom
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDetailsEffectiveTo", Value = lookupDetail.LookupDetailsEffectiveTo
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreatedByUserID", Value = lookupDetail.CreateUserId
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@RowStatus", Value = lookupDetail.RowStatus
});
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
adapter.Fill(dataset);
if (dataset != null)
{
lookupDetails = EntityCollectionHelper.ConvertTo <LookupDetails>(dataset.Tables[0]).FirstOrDefault();
}
}
}
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: SaveLookupDetails, Layer: LookupsDAL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: SaveLookupDetails, Layer: LookupsDAL, Stack Trace: " + ex.ToString());
throw;
}
return(lookupDetails);
}
