public PI_Master GetPI_Master(int PI_MasterID, SqlConnection con)
{
PI_Master objPIM = new PI_Master();
DataTable dt = new DataTable();
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from T_PI_Master where PIMID=@PIMasterID", con);
da.SelectCommand.Parameters.Add("@PIMasterID", SqlDbType.Int).Value = PI_MasterID;
da.Fill(dt);
da.Dispose();
if (dt.Rows.Count == 0)
{
return(null);
}
objPIM.PIMID = dt.Rows[0].Field <int>("PIMID");
objPIM.CurrencyID = Convert.ToInt32(dt.Rows[0].Field <int>("CurrencyID"));
objPIM.PIType = dt.Rows[0].Field <string>("PIType");
objPIM.PINO = dt.Rows[0].Field <string>("PINO");
objPIM.PIDate = dt.Rows[0].Field <DateTime>("PIDate");
objPIM.FactoryID = (dt.Rows[0].Field <object>("FactoryID") == DBNull.Value || dt.Rows[0].Field <object>("FactoryID") == null)?0:dt.Rows[0].Field <int>("FactoryID");
objPIM.Attention = dt.Rows[0].Field <string>("Attention");
objPIM.CustomerOrSupplierID = dt.Rows[0].Field <int>("CustSuppID");
objPIM.Rate = Convert.ToDouble(dt.Rows[0].Field <object>("Rate"));
objPIM.TermsCondition = GlobalFunctions.isNull(dt.Rows[0].Field <object>("TermsCond"), "");
return(objPIM);
}
catch (Exception ex)
{
throw ex;
}
}
public int SaveUpdatePI_Master(PI_Master obPI_Master, SqlConnection con, SqlTransaction trans)
{
SqlCommand com = null;
int ID = 0;
try
{
com = new SqlCommand();
com.Transaction = trans;
com.Connection = con;
com.CommandText = "spSaveUpdatePI_Master";
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@PIMID", SqlDbType.Int).Value = obPI_Master.PIMID;
com.Parameters.Add("@PINO", SqlDbType.VarChar, 50).Value = obPI_Master.PINO;
com.Parameters.Add("@PIDate", SqlDbType.DateTime).Value = obPI_Master.PIDate;
//com.Parameters.Add("OrderID", SqlDbType.Int).Value = obPI_Master.OrderID;
if (obPI_Master.FactoryID <= 0)
{
com.Parameters.Add("@FactoryID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
com.Parameters.Add("@FactoryID", SqlDbType.Int).Value = obPI_Master.FactoryID;
}
com.Parameters.Add("@PIType", SqlDbType.VarChar, 50).Value = obPI_Master.PIType;
if (obPI_Master.CurrencyID <= 0)
{
com.Parameters.Add("@CurrencyID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
com.Parameters.Add("@CurrencyID", SqlDbType.Int).Value = obPI_Master.CurrencyID;
}
com.Parameters.Add("@Attention", SqlDbType.VarChar, 500).Value = obPI_Master.Attention;
com.Parameters.Add("@CompanyID", SqlDbType.Int).Value = LogInInfo.CompanyID;
com.Parameters.Add("@UserID", SqlDbType.Int).Value = LogInInfo.UserID;
com.Parameters.Add("@CustSuppID", SqlDbType.Int).Value = obPI_Master.CustomerOrSupplierID;
com.Parameters.Add("@Rate", SqlDbType.Money).Value = obPI_Master.Rate;
com.Parameters.Add("@TermsCond", SqlDbType.VarChar, 5000).Value = obPI_Master.TermsCondition;
com.ExecuteNonQuery();
if (obPI_Master.PIMID == 0)
{
SqlCommand cmd = new SqlCommand("SELECT ISNULL(MAX(PIMID),0) FROM T_PI_Master", con, trans);
ID = Convert.ToInt32(cmd.ExecuteScalar());
}
else
{
ID = obPI_Master.PIMID;
}
}
catch (Exception ex)
{
throw new Exception("Unable to Save or Update " + ex.Message);
}
return(ID);
}
/// <summary>
/// USed For Saving The Pi
/// </summary>
/// <returns></returns>
protected bool SavePI()
{
TTSHWCFServiceClient cl = new TTSHWCFServiceClient();
string result = string.Empty;
PI_Master pi = new PI_Master();
try
{
pi.i_ID = Convert.ToInt32("1");
pi.i_Dept_ID = Convert.ToInt32(HdnNewDeptId.Value);
pi.s_Firstname = txtPiFirstName.Text;
pi.s_Lastname = txtPiLastName.Text;
pi.s_Email = txtPIEmailAddress.Text;
pi.s_Phone_no = txtPiPhNo.Text;
pi.s_MCR_No = txtPIMCR_NO.Text;
result = cl.PI_Master(pi, "Insert");
if (result.Split('|')[0].ToLower().Trim() == "success" && result.Split('|')[1].ToLower().Trim().CheckInt() == true)
{
this.PopUpMsg(" PI Details Save Successfully..!!", "CallNewPi()");
}
else
{
this.MsgBox(result.Split('|')[1]);
return(false);
}
}
catch (Exception ex)
{
this.MsgBox(ex.ToString());
return(false);
}
return(true);
}
public string Get(PI_Master _PI_Master, string mode)
{
string result = string.Empty;
SqlDataReader reader = null;
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = @"Data Source=192.168.0.110;Initial Catalog=TTSHTemp;User ID=sa;Password=ROOT#123";
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.CommandText = "spPI_MasterDML";
sqlCmd.Connection = myConnection;
myConnection.Open();
sqlCmd.Parameters.Add("@StatementType", SqlDbType.VarChar);
sqlCmd.Parameters["@StatementType"].Value = mode;
sqlCmd.Parameters.Add("@i_ID", SqlDbType.Int);
sqlCmd.Parameters["@i_ID"].Value = _PI_Master.i_ID;
if (mode.ToString() != "Delete")
{
sqlCmd.Parameters.Add("@i_Dept_ID", SqlDbType.Int);
sqlCmd.Parameters["@i_Dept_ID"].Value = _PI_Master.i_Dept_ID;
sqlCmd.Parameters.Add("@s_Firstname", SqlDbType.VarChar);
sqlCmd.Parameters["@s_Firstname"].Value = _PI_Master.s_Firstname;
sqlCmd.Parameters.Add("@s_Lastname", SqlDbType.VarChar);
sqlCmd.Parameters["@StatementType"].Value = _PI_Master.s_Lastname;
sqlCmd.Parameters.Add("@s_Email", SqlDbType.VarChar);
sqlCmd.Parameters["@s_Email"].Value = _PI_Master.s_Email;
sqlCmd.Parameters.Add("@s_Phone_no", SqlDbType.VarChar);
sqlCmd.Parameters["@s_Phone_no"].Value = _PI_Master.s_Phone_no;
sqlCmd.Parameters.Add("@s_MCR_No", SqlDbType.VarChar);
sqlCmd.Parameters["@s_MCR_No"].Value = _PI_Master.s_MCR_No;
sqlCmd.Parameters.Add("@UserCID", SqlDbType.VarChar);
sqlCmd.Parameters["@UserCID"].Value = _PI_Master.s_CreatedBy_ID;
}
sqlCmd.Parameters.Add("@Ret_Parameter", SqlDbType.VarChar);
sqlCmd.Parameters["@Ret_Parameter"].Size = 500;
sqlCmd.Parameters["@Ret_Parameter"].Direction = ParameterDirection.Output;
sqlCmd.ExecuteNonQuery();
if (string.IsNullOrEmpty(sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString()))
{
result = "Success" + " | " + sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
}
else
{
result = sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
}
return(result);
}
public string Post([FromBody] PI_Master pi_Master, string mode = "Insert")
{
string result = string.Empty;
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = Files.Config.ConnectionString;
SqlCommand sqlCmd = new SqlCommand();
myConnection.Open();
sqlCmd.Connection = myConnection;
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.CommandText = "spPI_MasterDML";
sqlCmd.Parameters.Add("@StatementType", SqlDbType.VarChar);
sqlCmd.Parameters["@StatementType"].Value = mode;
sqlCmd.Parameters.Add("@i_ID", SqlDbType.Int);
sqlCmd.Parameters["@i_ID"].Value = pi_Master.i_ID;
if (mode.ToString() != "Delete")
{
sqlCmd.Parameters.Add("@i_Dept_ID", SqlDbType.Int);
sqlCmd.Parameters["@i_Dept_ID"].Value = pi_Master.i_Dept_ID;
sqlCmd.Parameters.Add("@s_Firstname", SqlDbType.VarChar);
sqlCmd.Parameters["@s_Firstname"].Value = pi_Master.s_Firstname;
sqlCmd.Parameters.Add("@s_Lastname", SqlDbType.VarChar);
sqlCmd.Parameters["@s_Lastname"].Value = pi_Master.s_Lastname;
sqlCmd.Parameters.Add("@s_Email", SqlDbType.VarChar);
sqlCmd.Parameters["@s_Email"].Value = pi_Master.s_Email;
sqlCmd.Parameters.Add("@s_Phone_no", SqlDbType.VarChar);
sqlCmd.Parameters["@s_Phone_no"].Value = pi_Master.s_Phone_no;
sqlCmd.Parameters.Add("@s_MCR_No", SqlDbType.VarChar);
sqlCmd.Parameters["@s_MCR_No"].Value = pi_Master.s_MCR_No;
sqlCmd.Parameters.Add("@UserCID", SqlDbType.VarChar);
sqlCmd.Parameters["@UserCID"].Value = pi_Master.s_CreatedBy_ID;
}
sqlCmd.Parameters.Add("@Ret_Parameter", SqlDbType.VarChar);
sqlCmd.Parameters["@Ret_Parameter"].Size = 500;
sqlCmd.Parameters["@Ret_Parameter"].Direction = ParameterDirection.Output;
sqlCmd.ExecuteNonQuery();
if (!string.IsNullOrEmpty(sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString()))
{
if (sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString().ToLower().Contains("success"))
{
result = sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
//success is returned from db
}
else
{
result = sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
}
}
else
{
result = sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
}
myConnection.Close();
return(result);
}
/************************** End of PI_Print_Setting ********************************
*
*************************** Save or Update PI_Master ***************************/
public int SaveUpdatePI_Master(PI_Master obPI_Master, SqlConnection con)
{
SqlCommand com = null;
SqlTransaction trans = null;
int ID = 0;
try
{
com = new SqlCommand();
trans = con.BeginTransaction();
com.Transaction = trans;
com.Connection = con;
com.CommandText = "spSaveUpdatePI_Master";
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@PIMID", SqlDbType.Int).Value = obPI_Master.PIMID;
com.Parameters.Add("@PINO", SqlDbType.VarChar, 50).Value = obPI_Master.PINO;
com.Parameters.Add("@PIDate", SqlDbType.DateTime).Value = obPI_Master.PIDate;
//com.Parameters.Add("OrderID", SqlDbType.Int).Value = obPI_Master.OrderID;
if (obPI_Master.FactoryID <= 0)
{
com.Parameters.Add("@FactoryID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
com.Parameters.Add("@FactoryID", SqlDbType.Int).Value = obPI_Master.FactoryID;
}
//com.Parameters.Add("TotalOrderQty", SqlDbType.Int).Value = obPI_Master.TotalOrderQty;
//com.Parameters.Add("UnitID", SqlDbType.Int).Value = obPI_Master.UnitID;
//com.Parameters.Add("OrderValue", SqlDbType.Money).Value = obPI_Master.OrderValue;
//com.Parameters.Add("CurrencyID", SqlDbType.Int).Value = obPI_Master.CurrencyID;
com.Parameters.Add("@PIType", SqlDbType.VarChar, 50).Value = obPI_Master.PIType;
com.Parameters.Add("@Attention", SqlDbType.VarChar, 500).Value = obPI_Master.Attention;
com.Parameters.Add("@CompanyID", SqlDbType.Int).Value = LogInInfo.CompanyID;
com.Parameters.Add("@UserID", SqlDbType.Int).Value = LogInInfo.UserID;
com.Parameters.Add("@CustSuppID", SqlDbType.Int).Value = obPI_Master.CustomerOrSupplierID;
com.ExecuteNonQuery();
if (obPI_Master.PIMID == 0)
{
ID = ConnectionHelper.GetIDForInsert(con, trans, "PIMID", "T_PI_Master");
}
else
{
ID = obPI_Master.PIMID;
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception("Unable to Save or Update " + ex.Message);
}
return(ID);
}
protected bool SavePI()
{
string result = string.Empty;
PI_Master pi = new PI_Master();
try
{
pi.i_ID = Convert.ToInt32("1");
pi.i_Dept_ID = Convert.ToInt32(HdnNewDeptId.Value);
pi.s_Firstname = txtPiFirstName.Text;
pi.s_Lastname = txtPiLastName.Text;
pi.s_Email = txtPIEmailAddress.Text;
pi.s_Phone_no = txtPiPhNo.Text;
pi.s_MCR_No = txtPIMCR_NO.Text;
//result = cl.PI_Master(pi, "Insert");
//using (var client = new System.Net.Http.HttpClient())
//{
// //client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/PIMaster/");
// client.BaseAddress = new Uri(Session["WebApiUrl"].ToString() + "api/PIMaster/");
// client.DefaultRequestHeaders.Accept.Clear();
// client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
// var json = Newtonsoft.Json.JsonConvert.SerializeObject(pi);
// HttpContent content = new StringContent(json);
// content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
// // var response = client.PostAsJsonAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", pmm).Result;
// var response = client.PostAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/PIMaster/", content).Result;
// JavaScriptSerializer serializer = new JavaScriptSerializer();
// result = serializer.Deserialize<String>(response.Content.ReadAsStringAsync().Result);
//}
if (result.Split('|')[0].ToLower().Trim() == "success" && result.Split('|')[1].ToLower().Trim().CheckInt() == true)
{
this.PopUpMsg(" PI Details Save Successfully..!!", "CallNewPi()");
}
else
{
this.MsgBox(result.Split('|')[1]);
return(false);
}
}
catch (Exception ex)
{
this.MsgBox(ex.ToString());
return(false);
}
return(true);
}
public PI_Master Get(int id)
{
string result = string.Empty;
SqlDataReader reader = null;
PI_Master mas = new PI_Master();
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = @"Data Source=192.168.0.110;Initial Catalog=TTSHTemp;User ID=sa;Password=ROOT#123";
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.CommandText = "spPI_MasterDML";
sqlCmd.Connection = myConnection;
myConnection.Open();
sqlCmd.Parameters.Add("@StatementType", SqlDbType.VarChar);
sqlCmd.Parameters["@StatementType"].Value = "Select";
sqlCmd.Parameters.Add("@i_ID", SqlDbType.Int);
sqlCmd.Parameters["@i_ID"].Value = id;
sqlCmd.Parameters.Add("@Ret_Parameter", SqlDbType.VarChar);
sqlCmd.Parameters["@Ret_Parameter"].Size = 500;
sqlCmd.Parameters["@Ret_Parameter"].Direction = ParameterDirection.Output;
reader = sqlCmd.ExecuteReader();
while (reader.Read())
{
mas.s_Email = reader.GetValue(4).ToString();
mas.s_Phone_no = reader.GetValue(5).ToString();
mas.s_MCR_No = reader.GetValue(6).ToString();
}
//if (string.IsNullOrEmpty(sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString()))
//{
// result = "Success" + " | " + sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
// mas.s_Email=
//}
//else
//{
// result = sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
//}
return(mas);
}
protected bool SavePI()
{
string result = string.Empty;
PI_Master pi = new PI_Master();
try
{
pi.i_ID = Convert.ToInt32("1");
pi.i_Dept_ID = Convert.ToInt32(HdnNewDeptId.Value);
pi.s_Firstname = txtPiFirstName.Text;
pi.s_Lastname = txtPiLastName.Text;
pi.s_Email = txtPIEmailAddress.Text;
pi.s_Phone_no = txtPiPhNo.Text;
pi.s_MCR_No = txtPIMCR_NO.Text;
//result = cl.PI_Master(pi, "Insert");
using (var client = new System.Net.Http.HttpClient())
{
//client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/PIMaster/");
client.BaseAddress = new Uri(Session["WebApiUrl"].ToString() + "api/PIMaster/");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var json = Newtonsoft.Json.JsonConvert.SerializeObject(pi);
HttpContent content = new StringContent(json);
content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
// var response = client.PostAsJsonAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", pmm).Result;
var response = client.PostAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/PIMaster/", content).Result;
JavaScriptSerializer serializer = new JavaScriptSerializer();
result = serializer.Deserialize<String>(response.Content.ReadAsStringAsync().Result);
}
if (result.Split('|')[0].ToLower().Trim() == "success" && result.Split('|')[1].ToLower().Trim().CheckInt() == true)
{
this.PopUpMsg(" PI Details Save Successfully..!!", "CallNewPi()");
}
else
{
this.MsgBox(result.Split('|')[1]);
return false;
}
}
catch (Exception ex)
{
this.MsgBox(ex.ToString());
return false;
}
return true;
}
protected void btnSaveNewPI_Click(object sender, EventArgs e)
{
try
{
TTSHWCFServiceClient client = new TTSHWCFServiceClient();
TTSHWCFReference.PI_Master pi = new PI_Master();
pi.i_Dept_ID = Convert.ToInt32(HdnNewDeptId.Value);
pi.s_Email = txtNewPIEmail.Text;
pi.s_Firstname = txtNewPIFName.Text;
pi.s_Lastname = txtNewPILName.Text;
pi.s_MCR_No = txtNewPIMCR.Text;
pi.s_Phone_no = txtNewPIPhone.Text;
string res = client.PI_Master(pi, Mode.Insert.ToString());
var retMsg = res.Split('|')[1];
if (retMsg != "")
{
int val;
if (!int.TryParse(retMsg, out val))
CallJS("MessageBox('" + retMsg + "');ApplyAutoComplete();");
else
CallJS("$('.newPI').click();ApplyAutoComplete();MessageBox('PI Details saved successfully')");
}
else
{
CallJS("$('.newPI').click();ApplyAutoComplete();MessageBox('PI Details saved successfully')");
}
}
catch (Exception)
{
throw;
}
}
protected void btnSaveNewPI_Click(object sender, EventArgs e)
{
try
{
TTSHWCFServiceClient client = new TTSHWCFServiceClient();
TTSHWCFReference.PI_Master pi = new PI_Master();
pi.i_Dept_ID = Convert.ToInt32(HdnNewDeptId.Value);
pi.s_Email = txtNewPIEmail.Text;
pi.s_Firstname = txtNewPIFName.Text;
pi.s_Lastname = txtNewPILName.Text;
pi.s_MCR_No = txtNewPIMCR.Text;
pi.s_Phone_no = txtNewPIPhone.Text;
string res = client.PI_Master(pi, Mode.Insert.ToString());
if (res.Split('|')[1] != "")
{
if (res.Split('|')[1].ToLower().Trim() == "mcr exists")
CallJS("MessageBox('PI with same MCR Number already exists for selected Department');ApplyAutoComplete();");
else if (res.Split('|')[1].ToLower().Trim() == "email exists")
CallJS("MessageBox('PI with same Email already exists for selected Department');ApplyAutoComplete();");
else
CallJS("$('.newPI').click();ApplyAutoComplete();MessageBox('PI Details saved successfully')");
}
else
{
CallJS("$('.newPI').click();ApplyAutoComplete();MessageBox('PI Details saved successfully')");
}
}
catch (Exception)
{
throw;
}
}
protected bool SavePI()
{
string result = string.Empty;
PI_Master pi = new PI_Master();
try
{
pi.i_ID = Convert.ToInt32("1");
pi.i_Dept_ID = Convert.ToInt32(HdnNewDeptId.Value);
pi.s_Firstname = txtPiFirstName.Text;
pi.s_Lastname = txtPiLastName.Text;
pi.s_Email = txtPIEmailAddress.Text;
pi.s_Phone_no = txtPiPhNo.Text;
pi.s_MCR_No = txtPIMCR_NO.Text;
//result = cl.PI_Master(pi, "Insert");
//using (var client = new System.Net.Http.HttpClient())
//{
// //client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/PIMaster/");
// client.BaseAddress = new Uri(Session["WebApiUrl"].ToString() + "api/PIMaster/");
// client.DefaultRequestHeaders.Accept.Clear();
// client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
// var json = Newtonsoft.Json.JsonConvert.SerializeObject(pi);
// HttpContent content = new StringContent(json);
// content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
// // var response = client.PostAsJsonAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", pmm).Result;
// var response = client.PostAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/PIMaster/", content).Result;
// JavaScriptSerializer serializer = new JavaScriptSerializer();
// result = serializer.Deserialize<String>(response.Content.ReadAsStringAsync().Result);
//}
var baseAddress = Session["WebApiUrl"].ToString() + "api/PIMaster/";
var http = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(new Uri(baseAddress));
http.Accept = "application/json";
http.ContentType = "application/json";
http.Method = "POST";
string parsedContent = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(pi);
ASCIIEncoding encoding = new ASCIIEncoding();
Byte[] bytes = encoding.GetBytes(parsedContent);
System.IO.Stream newStream = http.GetRequestStream();
newStream.Write(bytes, 0, bytes.Length);
newStream.Close();
var response = http.GetResponse();
var stream = response.GetResponseStream();
var sr = new StreamReader(stream);
result = sr.ReadToEnd();
if (result.Split('|')[0].ToLower().Trim() == "success" && result.Split('|')[1].ToLower().Trim().CheckInt() == true)
{
this.PopUpMsg(" PI Details Save Successfully..!!", "CallNewPi()");
}
else
{
this.MsgBox(result.Split('|')[1]);
return(false);
}
}
catch (Exception ex)
{
this.MsgBox(ex.ToString());
return(false);
}
return(true);
}
protected bool SavePI()
{
string result = string.Empty;
PI_Master pi = new PI_Master();
try
{
pi.i_ID = Convert.ToInt32("1");
pi.i_Dept_ID = Convert.ToInt32(HdnNewDeptId.Value);
pi.s_Firstname = txtPiFirstName.Text;
pi.s_Lastname = txtPiLastName.Text;
pi.s_Email = txtPIEmailAddress.Text;
pi.s_Phone_no = txtPiPhNo.Text;
pi.s_MCR_No = txtPIMCR_NO.Text;
//result = cl.PI_Master(pi, "Insert");
//using (var client = new System.Net.Http.HttpClient())
//{
// //client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/PIMaster/");
// client.BaseAddress = new Uri(Session["WebApiUrl"].ToString() + "api/PIMaster/");
// client.DefaultRequestHeaders.Accept.Clear();
// client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
// var json = Newtonsoft.Json.JsonConvert.SerializeObject(pi);
// HttpContent content = new StringContent(json);
// content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
// // var response = client.PostAsJsonAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", pmm).Result;
// var response = client.PostAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/PIMaster/", content).Result;
// JavaScriptSerializer serializer = new JavaScriptSerializer();
// result = serializer.Deserialize<String>(response.Content.ReadAsStringAsync().Result);
//}
var baseAddress = Session["WebApiUrl"].ToString() + "api/PIMaster/";
var http = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(new Uri(baseAddress));
http.Accept = "application/json";
http.ContentType = "application/json";
http.Method = "POST";
string parsedContent = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(pi);
ASCIIEncoding encoding = new ASCIIEncoding();
Byte[] bytes = encoding.GetBytes(parsedContent);
System.IO.Stream newStream = http.GetRequestStream();
newStream.Write(bytes, 0, bytes.Length);
newStream.Close();
var response = http.GetResponse();
var stream = response.GetResponseStream();
var sr = new StreamReader(stream);
result = sr.ReadToEnd();
if (result.Split('|')[0].ToLower().Trim() == "success" && result.Split('|')[1].ToLower().Trim().CheckInt() == true)
{
this.PopUpMsg(" PI Details Save Successfully..!!", "CallNewPi()");
}
else
{
this.MsgBox(result.Split('|')[1]);
return false;
}
}
catch (Exception ex)
{
this.MsgBox(ex.ToString());
return false;
}
return true;
}
/// <summary>
/// USed For Saving The Pi
/// </summary>
/// <returns></returns>
protected bool SavePI()
{
TTSHWCFServiceClient cl = new TTSHWCFServiceClient();
string result = string.Empty;
PI_Master pi = new PI_Master();
try
{
pi.i_ID = Convert.ToInt32("1");
pi.i_Dept_ID = Convert.ToInt32(HdnNewDeptId.Value);
pi.s_Firstname = txtPiFirstName.Text;
pi.s_Lastname = txtPiLastName.Text;
pi.s_Email = txtPIEmailAddress.Text;
pi.s_Phone_no = txtPiPhNo.Text;
pi.s_MCR_No = txtPIMCR_NO.Text;
result = cl.PI_Master(pi, "Insert");
if (result.Split('|')[0].ToLower().Trim() == "success" && result.Split('|')[1].ToLower().Trim().CheckInt() == true)
{
this.PopUpMsg(" PI Details Save Successfully..!!", "CallNewPi()");
}
else
{
this.MsgBox(result.Split('|')[1]);
return false;
}
}
catch (Exception ex)
{
this.MsgBox(ex.ToString());
return false;
}
return true;
}
