public string DeleteReferenceLookup(RefLookupModel model)
{
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@UserId", model.UserId),
new KeyValuePair <string, object>("@Id", model.Id)
};
return(DataExecutor.ExecuteScalar(UtilityConstant.Procedures.Mst_DeleteReferenceLookup, param));
}
public string SaveReferenceLookup(RefLookupModel model)
{
List <string> lst = new List <string>();
lst = model.Value.Split("||").ToList();
foreach (var item in lst)
{
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("@key", model.Key),
new KeyValuePair <string, object>("@Value", item),
new KeyValuePair <string, object>("@Remark", model.Remark),
new KeyValuePair <string, object>("@UserId", model.UserId),
};
DataExecutor.ExecuteScalar(UtilityConstant.Procedures.Mst_SaveReferenceLookup, param);
}
return("Saved");
}
