public static void Save(string name, string component, int sortOrder, RequestProfile requestProfile)
{
var obj = new DBComponentNameDataModel();
obj.ApplicationId = requestProfile.ApplicationId;
obj.Name = name;
obj.Description = name;
obj.SortOrder = sortOrder;
var dt = DBComponentNameDataManager.Search(obj, requestProfile);
if (dt.Rows.Count == 0)
{
DBComponentNameDataManager.Create(obj, requestProfile);
}
else if (dt.Rows.Count == 1)
{
obj.DBComponentNameId = (int)(dt.Rows[0][DBComponentNameDataModel.DataColumns.DBComponentNameId]);
DBComponentNameDataManager.Update(obj, requestProfile);
}
}
public static void SaveEntityDetails(String entityName, String dbName, String dbProjectName, String dbComponentName, RequestProfile requestProfile)
{
var dbNameId = 0;
var dbComponentNameId = 0;
var dbProjectNameId = 0;
var obj1 = new DBNameDataModel();
obj1.Name = dbName;
var dt = DBNameDataManager.Search(obj1, requestProfile);
if (dt.Rows.Count >= 1)
{
if (dbName.Equals(obj1.Name))
{
dbNameId = Convert.ToInt32(dt.Rows[0][DBNameDataModel.DataColumns.DBNameId].ToString());
}
}
var obj2 = new DBComponentNameDataModel();
obj2.Name = dbComponentName;
dt = DBComponentNameDataManager.Search(obj2, requestProfile);
if (dt.Rows.Count >= 1)
{
if (dbComponentName.Equals(obj2.Name))
{
dbComponentNameId = Convert.ToInt32(dt.Rows[0][DBComponentNameDataModel.DataColumns.DBComponentNameId].ToString());
}
}
var obj3 = new DBProjectNameDataModel();
obj3.Name = dbProjectName;
dt = DBProjectNameDataManager.Search(obj3, requestProfile);
if (dt.Rows.Count >= 1)
{
if (dbProjectName.Equals(obj3.Name))
{
dbProjectNameId = Convert.ToInt32(dt.Rows[0][DBProjectNameDataModel.DataColumns.DBProjectNameId].ToString());
}
}
var obj4 = new AllEntityDetailDataModel();
var AllEntityDetailId = 0;
obj4.EntityName = entityName;
dt = AllEntityDetailDataManager.Search(obj4, requestProfile);
if (dt.Rows.Count >= 1)
{
if (entityName.Equals(obj4.EntityName))
{
AllEntityDetailId = Convert.ToInt32(dt.Rows[0][AllEntityDetailDataModel.DataColumns.AllEntityDetailId].ToString());
}
}
var obj = new AllEntityDetailDataModel();
obj.ApplicationId = requestProfile.ApplicationId;
obj.EntityName = entityName;
obj.DB_Name = dbName;
obj.DB_Project_Name = dbProjectName;
obj.Component_Project_Name = dbComponentName;
obj.DBNameId = dbNameId;
obj.DBProjectNameId = dbProjectNameId;
obj.DBComponentNameId = dbComponentNameId;
if (AllEntityDetailId == 0)
{
AllEntityDetailDataManager.Create(obj, requestProfile);
}
else if (AllEntityDetailId != 0)
{
obj.AllEntityDetailId = AllEntityDetailId;
AllEntityDetailDataManager.Update(obj, requestProfile);
}
}