public CustomFieldMaster(DataRow DR)
{
this.CFMid = Convert.ToInt64(DR["CFMid"]);
this.cid = Convert.ToInt32(DR["cid"]);
this.Label = Convert.ToString(DR["Label"]);
this.FieldName = Convert.ToString(DR["FieldName"]);
this.DataType = Convert.ToInt32(DR["DataType"]);
this.compulsory = Convert.ToInt32(DR["compulsory"]);
this.active = Convert.ToInt32(DR["active"]);
this.created_by = Convert.ToInt32(DR["created_by"]);
this.date_created = Convert.ToDateTime(DR["date_created"]);
this.date_modified = Convert.ToDateTime(DR["date_modified"]);
this.customFieldList = CustomFieldList.GetByFeild(this.CFMid);
}
public CustomFieldList Create(CustomFieldList cfl)
{
Connection con = new Connection();
Command cmd = new Command();
string query1 = "";
string query2 = "";
if (cfl.cid == 0)
{
throw new Exception("cid is required");
}
else
{
query1 += "cid,";
query2 += "@cid,";
cmd.Parameters.Add("@cid", DBType.Int, cfl.cid);
}
if (cfl.CFMid == 0)
{
throw new Exception("CFMid is required");
}
else
{
query1 += "CFMid,";
query2 += "@CFMid,";
cmd.Parameters.Add("@CFMid", DBType.Int, cfl.CFMid);
}
if (string.IsNullOrEmpty(cfl.DataField))
{
throw new Exception("DataField is required");
}
else
{
query1 += "DataField,";
query2 += "@DataField,";
cmd.Parameters.Add("@DataField", DBType.VarChar, cfl.DataField);
}
if (string.IsNullOrEmpty(cfl.TextField))
{
throw new Exception("TextField is required");
}
else
{
query1 += "TextField,";
query2 += "@TextField,";
cmd.Parameters.Add("@TextField", DBType.VarChar, cfl.TextField);
}
query1 += "active,";
query2 += "@active,";
cmd.Parameters.Add("@active", DBType.Int, cfl.active);
if (cfl.created_by == 0)
{
throw new Exception("created by is required");
}
else
{
query1 += "created_by,";
query2 += "@created_by,";
cmd.Parameters.Add("@created_by", DBType.Int, cfl.created_by);
}
if (cfl.date_created == Convert.ToDateTime("1900-01-01"))
{
throw new Exception("date created is required");
}
else
{
query1 += "date_created,";
query2 += "@date_created,";
cmd.Parameters.Add("@date_created", DBType.DateTime, cfl.date_created);
}
if (cfl.date_modified == Convert.ToDateTime("1900-01-01"))
{
throw new Exception("date modified is required");
}
else
{
query1 += "date_modified,";
query2 += "@date_modified,";
cmd.Parameters.Add("@date_modified", DBType.DateTime, cfl.date_modified);
}
string Query = "INSERT INTO CustomFieldList(" + query1.TrimEnd(',') + ") VALUES (" + query2.TrimEnd(',') + ") SELECT @@IDENTITY";
cmd.CommandText = Query;
cmd.CommandType = DBConnection.CommandType.Text;
con.cmd = cmd;
DataTable DT = con.getDataTable();
cfl.CFLid = Convert.ToInt32(DT.Rows[0][0]);
return(cfl);
}
