public string CreateGroup(GroupDetails obj)
{
try
{
U_USR_GroupsDAL ocontactsDAL = new U_USR_GroupsDAL();
U_USR_Groups ogroup = new U_USR_Groups();
ogroup.Group_Id = Guid.NewGuid().ToString();
ogroup.Group_Name = obj.Group_Name;
ogroup.Group_Source = "";
ogroup.Group_Status = "1";
ogroup.Usr_Id = obj.User_Id;
ogroup.Updated_by = "";
ogroup.Updated_Date = DateTime.Now;
ogroup.Created_by = "";
ogroup.Created_Date = DateTime.Now;
ogroup.Group_Desc = "";
bool status = ocontactsDAL.InsertU_USR_Groups(ogroup);
if (status == true)
{
return("1");
}
else
{
return("0");
}
}
catch (Exception ex)
{
Console.Write(ex);
return(null);
}
}
private void SetParameters(SqlParameter[] U_USR_GroupsParms, U_USR_Groups tobjU_USR_Groups)
{
U_USR_GroupsParms[0].Value = tobjU_USR_Groups.Group_Id;
U_USR_GroupsParms[1].Value = tobjU_USR_Groups.Usr_Id;
U_USR_GroupsParms[2].Value = tobjU_USR_Groups.Group_Name;
U_USR_GroupsParms[3].Value = tobjU_USR_Groups.Group_Desc;
U_USR_GroupsParms[4].Value = tobjU_USR_Groups.Group_Source;
U_USR_GroupsParms[5].Value = tobjU_USR_Groups.Group_Status;
U_USR_GroupsParms[6].Value = tobjU_USR_Groups.Created_Date;
U_USR_GroupsParms[7].Value = tobjU_USR_Groups.Updated_Date;
U_USR_GroupsParms[8].Value = tobjU_USR_Groups.Created_by;
U_USR_GroupsParms[9].Value = tobjU_USR_Groups.Updated_by;
}
public bool InsertU_USR_Groups(U_USR_Groups tobjU_USR_Groups)
{
if (tobjU_USR_Groups != null)
{
//Get the parameter list needed by the given object
SqlParameter[] lParamArray = GetParameters(tobjU_USR_Groups);
SetParameters(lParamArray, tobjU_USR_Groups);
//Get the connection
SqlConnection con = General.GetConnection();
if (con == null)
{
//Connection is not created
return(false);
}
//Execute the insertion
int i = SqlHelper.ExecuteNonQuery(
con,
CommandType.Text,
SQL_INSERT_U_USR_Groups,
lParamArray);
//Dispose the Sql connection
con.Dispose();
if (i == 1)
{
//Done and insert the object to the table
return(true);
}
else
{
//Fail to execute the insertion
return(false);
}
}
else
{
//No object found to insert
return(false);
}
}
private SqlParameter[] GetParameters(U_USR_Groups tobjU_USR_Groups)
{
SqlParameter[] objParamArray = SqlHelperParameterCache.GetCachedParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_USR_Groups);
if (objParamArray == null)
{
//Represents a parameter to a System.Data.SqlClient.SqlCommand,
//and optionally, its mapping to System.Data.DataSet columns.
objParamArray = new SqlParameter[]
{
new SqlParameter(PARAM_Group_Id, tobjU_USR_Groups.Group_Id),
new SqlParameter(PARAM_Usr_Id, tobjU_USR_Groups.Usr_Id),
new SqlParameter(PARAM_Group_Name, tobjU_USR_Groups.Group_Name),
new SqlParameter(PARAM_Group_Desc, tobjU_USR_Groups.Group_Desc),
new SqlParameter(PARAM_Group_Source, tobjU_USR_Groups.Group_Source),
new SqlParameter(PARAM_Group_Status, tobjU_USR_Groups.Group_Status),
new SqlParameter(PARAM_Created_Date, tobjU_USR_Groups.Created_Date),
new SqlParameter(PARAM_Updated_Date, tobjU_USR_Groups.Updated_Date),
new SqlParameter(PARAM_Created_by, tobjU_USR_Groups.Created_by),
new SqlParameter(PARAM_Updated_by, tobjU_USR_Groups.Updated_by),
};
SqlHelperParameterCache.CacheParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_USR_Groups, objParamArray);
}
return(objParamArray);
}
