public int SaveLookupByDesiger(DesignerLookup designerLookup)
{
Logging.LogDebugMessage("Method: SaveLookupByDesiger, MethodType: Post, Layer: LookupsController, Parameters: DesignerLookup = " + JsonConvert.SerializeObject(designerLookup));
using (LookupsBL lookupsBL = new LookupsBL())
{
return(lookupsBL.SaveLookupByDesiger(designerLookup));
}
}
/// <summary>This method save the lookup and lookup details by designer</summary>
/// <param name="designerLookup">The DesignerLookup Object.</param>
/// <returns>returns Integer Object</returns>
public int SaveLookupByDesiger(DesignerLookup designerLookup)
{
var dataset = new DataSet();
int lookupId = 0;
Logging.LogDebugMessage("Method: SaveLookupByDesiger, MethodType: Post, Layer: LookupsDAL, Parameters: Parameters: DesignerLookup = " + JsonConvert.SerializeObject(designerLookup));
try
{
using (var command = new SqlCommand())
{
command.Connection = new SqlConnection(this.ConnectionString);
command.CommandText = "USP_SaveLookupByDesigner";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupName", Value = designerLookup.LookupName
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupDescription", Value = designerLookup.LookupDescription
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupShortDescription", Value = designerLookup.LookupShortDescription
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = designerLookup.CreateUserId
});
DataTable dataTable = new DataTable();
dataTable = EntityCollectionHelper.ConvertTo <DesignerLookupDetails>(designerLookup.designerLookupDetails);
SqlParameter structuredParamOne = new SqlParameter("@LookupDetailsType", SqlDbType.Structured);
structuredParamOne.Value = dataTable;
command.Parameters.Add(structuredParamOne);
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
adapter.Fill(dataset);
if (dataset != null && dataset.Tables.Count > 0)
{
lookupId = Convert.ToInt32(dataset.Tables[0].Rows[0][0]);
}
}
}
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: SaveLookupByDesiger, Layer: LookupsDAL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: SaveLookupByDesiger, Layer: LookupsDAL, Stack Trace: " + ex.ToString());
throw;
}
return(lookupId);
}
/// <summary>This method save the lookup and lookup details by designer</summary>
/// <param name="designerLookup">The DesignerLookup Object.</param>
/// <returns>returns Integer Object</returns>
public int SaveLookupByDesiger(DesignerLookup designerLookup)
{
Logging.LogDebugMessage("Method: SaveLookupByDesiger, MethodType: Post, Layer: LookupsBL, Parameters: DesignerLookup = " + JsonConvert.SerializeObject(designerLookup));
try
{
using (LookupsDAL lookups = new LookupsDAL())
{
return(lookups.SaveLookupByDesiger(designerLookup));
}
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: SaveLookupByDesiger, Layer: LookupsBL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: SaveLookupByDesiger, Layer: LookupsBL, Stack Trace: " + ex.ToString());
throw;
}
}
