public static void DeleteSpecialField(int SpecialFieldId)
{
try
{
SpecialFieldsDAL.DeleteSpecialField(SpecialFieldId);
}
catch (SqlException exDB)
{
throw (new ApplicationException(exDB.Message, exDB));
}
}
public static void SetSpecialFieldsValidStartEndDate(ref DateTime?StartDate, ref DateTime?EndDate, string StateFIPS, FormType DataForm)
{
SpecialFieldsDAL.SetSpecialFieldsValidStartEndDate(ref StartDate, ref EndDate, StateFIPS, DataForm);
}
public static IEnumerable <ViewSpecialFieldsViewData> GetSpecialFieldsView(string StateFIPS, DateTime StartDate, DateTime EndDate, FormType DataForm)
{
return(SpecialFieldsDAL.GetSpecialFields(StateFIPS, StartDate, EndDate, DataForm));
}
public static ViewSpecialFieldsViewData GetSpecialFieldsView(int SpecialFieldId)
{
SpecialField sf = SpecialFieldsDAL.GetSpecialFieldsById(SpecialFieldId);
return(GetSpecialFieldsViewData(sf));
}
public static int AddUpdateSpecialField(ViewSpecialFieldsViewData FieldData)
{
SpecialField FieldRec = new SpecialField();
FieldRec.Description = FieldData.Description;
FieldRec.StartDate = Convert.ToDateTime(FieldData.StartDate);
FieldRec.EndDate = Convert.ToDateTime(FieldData.EndDate);
if (FormType.ClientContact.ToString() == FieldData.FormType)
{
FieldRec.FormType = FormType.ClientContact;
}
if (FormType.PublicMediaActivity.ToString() == FieldData.FormType)
{
FieldRec.FormType = FormType.PublicMediaActivity;
}
FieldRec.IsRequired = false;
if (FieldData.IsRequired.ToUpper() == "YES")
{
FieldRec.IsRequired = true;
}
FieldRec.Name = FieldData.Name;
FieldRec.State = FieldData.State;
FieldRec.Ordinal = FieldData.Ordinal;
FieldRec.Id = FieldData.Id;
if (FieldData.ValidationName == ShiptalkLogic.BusinessObjects.ValidationType.None.ToString())
{
FieldRec.ValidationType = ShiptalkLogic.BusinessObjects.ValidationType.None;
}
if (FieldData.ValidationName == ShiptalkLogic.BusinessObjects.ValidationType.AlphaNumeric.ToString())
{
FieldRec.ValidationType = ShiptalkLogic.BusinessObjects.ValidationType.AlphaNumeric;
}
if (FieldData.ValidationName == ShiptalkLogic.BusinessObjects.ValidationType.Numeric.ToString())
{
FieldRec.ValidationType = ShiptalkLogic.BusinessObjects.ValidationType.Numeric;
}
//Added by Lavanya Maram: 06/27/2013
if (FieldData.ValidationName == ShiptalkLogic.BusinessObjects.ValidationType.Range.ToString())
{
FieldRec.ValidationType = ShiptalkLogic.BusinessObjects.ValidationType.Range;
}
if (FieldData.ValidationName == ShiptalkLogic.BusinessObjects.ValidationType.Option.ToString())
{
FieldRec.ValidationType = ShiptalkLogic.BusinessObjects.ValidationType.Option;
}
FieldRec.Range = FieldData.Range;
// end
FieldRec.CreatedBy = FieldData.CreatedBy;
try
{
return(SpecialFieldsDAL.AddSpecialField(FieldRec));
}
catch (SqlException exSql)
{
//2601 is thrown when the unique constraint is has been violated.
if (exSql.Number == 2601)
{
throw (new ApplicationException("Existing field has been defined for ordinal value " + FieldData.Ordinal.ToString(), exSql));
}
else
{
throw (new ApplicationException(exSql.Message, exSql));
}
}
}
